AWS Redshift Administrator Engineer

Responsibilities

• 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, Git Lab.
• 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.
• 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.

• 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.
• 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, Power Shell.
• 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.
• Strong written and verbal communication skills.