Logo
JobRialto

AWS Redshift Administrator Engineer

JobRialto, Boston, Massachusetts, us, 02298

Save Job

Job Summary:

• Administer and maintain scalable cloud environments and applications for data organization.

• Understand business objectives and create cloud-based solutions to facilitate those objectives.

• Implement Infrastructure as Code and deploy code using Terraform, GitLab.

• Install and maintain software, services, and applications by identifying system requirements.

• Hands-on AWS Services and DB and Server troubleshooting experience.

• Extensive database experience with RDS, AWS Redshift, MySQL.

• Maintain environment by identifying system requirements, installing upgrades, and monitoring system performance.

• Knowledge of day-to-day database operations, deployments, and development.

• Experience in Snowflake.

• Knowledge of SQL and Performance tuning.

• Knowledge of Linux Shell Scripting or Python.

• Migrate system from one AWS cloud to another AWS account.

• Hands-on DB and Server troubleshooting experience.

• Maintain system performance by performing system monitoring and analysis and performance tuning.

• Troubleshoot system hardware, software, and operating and system management systems.

• Secure web system by developing system access, monitoring, control, and evaluation.

• Test disaster recovery policies and procedures; complete back-ups; and maintain documentation.

• Upgrade system and services and develop, test, evaluate, and install enhancements and new software.

• Communicate with internal teams, like EIMO, Operations, and Cloud Architect.

• Communicate with stakeholders and build applications to meet project needs.

Required Qualifications:

• Bachelor's degree in computer science or engineering.

• Minimum of 12 years of experience in System, platform, and AWS cloud administration.

• Minimum of 5 to 8 years of Database administration and AWS experience using latest AWS technologies.

• AWS EC2, Redshift, VPC, S3, AWS RDS.

• Experience with Java, Python, Redshift, MySQL, or equivalent database tools.

• Experience with Agile software development using JIRA.

• Experience in multiple OS platforms with strong emphasis on Linux and Windows systems.

• Experience with OS-level scripting environment such as KSH shell, PowerShell.

• Experience with version management tools and CICD pipeline.

• In-depth knowledge of the TCP/IP protocol suite, security architecture, securing and hardening Operating Systems, Networks, Databases, and Applications.

• Advanced SQL knowledge and experience working with relational databases, query authoring (SQL), query performance tuning.

• Experience supporting and optimizing data pipelines and data sets.

• Knowledge of the Incident Response life cycle.

• AWS solution architect certifications.

• Strong written and verbal communication skills. \n

Education:

Bachelors Degree