Redshift Admin

Job Description:

We are hiring a Redshift Admin to join our team. The resource will be responsible for managing key data systems and services, including AWS services such as EC2, RDS, Redshift, S3, ELB, and NLB. The consultant will perform Redshift administration and release management activities. This role requires a highly motivated individual with strong technical expertise, data management capabilities, excellent communication, and collaboration skills. The ability to develop and troubleshoot a diverse range of issues is critical.

Responsibilities:

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

• Understand business objectives and create cloud-based solutions to meet company needs.

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

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

• Hands-on experience with AWS services, database management, and server troubleshooting.

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

• Maintain system performance by installing upgrades, monitoring performance, and troubleshooting issues.

• Manage day-to-day database operations, deployments, and development.

• Experience with Snowflake for data storage and analytics.

• Strong knowledge of SQL and query performance tuning.

• Proficiency in Linux Shell Scripting or Python for automation.

• Migrate systems from one AWS cloud environment to another AWS account.

• Perform system monitoring, analysis, and performance tuning.

• Troubleshoot system hardware, software, and management systems.

• Secure web systems by developing system access, monitoring controls, and evaluation mechanisms.

• Conduct disaster recovery testing, backup management, and maintain documentation.

• Upgrade systems and services, evaluate enhancements, and install new software.

• Collaborate with internal teams such as EIMO, Operations, and Cloud Architects.

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

Qualifications:

• Bachelor s degree in Computer Science or Engineering.

• 8-10 years of experience in System, Platform, and AWS Cloud Administration.

• 5-7 years of experience in Database Administration and AWS technologies (AWS EC2, Redshift, VPC, S3, AWS RDS).

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

• Familiarity with Agile software development using JIRA.

• Expertise in Linux and Windows systems.

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

• Hands-on experience with version management tools and CI/CD pipelines.

• Strong knowledge of TCP/IP protocols, security architecture, and system hardening.

• Advanced SQL knowledge with experience in relational databases and query optimization.

• Experience in supporting and optimizing data pipelines and datasets.

• Knowledge of the Incident Response lifecycle.

• AWS Solution Architect Certification is a plus.

• Strong written and verbal communication skills.

This is an excellent opportunity to work with cutting-edge AWS technologies and contribu