AWS Database Engineer (RedShift & RDS)
About The Position
The AWS Database Engineer will work as an AWS DevOps Engineer with a database focus, designing, administering, and supporting AWS cloud infrastructure, Amazon Redshift and RDS databases, and DevOps automation for a financial services client. The role includes managing and optimizing AWS services, database administration, deployment and infrastructure automation, and troubleshooting production issues to support system reliability and availability. As an Infrastructure Consultant 2, the position also contributes to infrastructure assessment and solution design, deployment coordination, system performance and capacity planning, security and recovery activities, process automation, and technical knowledge management. The role involves collaboration with client, internal, onsite, offshore, and vendor teams. Relocation and/or travel to a work or project location may be required.
Requirements
- Ability to manage and optimize AWS services, including Amazon Redshift and RDS.
- Database administration experience or capability covering performance tuning, backup, recovery, and monitoring.
- Ability to automate deployments, infrastructure provisioning, and operational processes.
- Ability to troubleshoot production issues and support system reliability and availability.
- Bachelor’s degree or foreign equivalent from an accredited institution; three years of progressive specialty experience may be considered in lieu of each year of education.
- Applicants must be authorized to work in the United States.
Nice To Haves
- AWS Certified Database – Specialty certification.
- AWS Certified Solutions Architect or DevOps Engineer certification.
- Python or Bash automation experience.
- Experience with Aurora or PostgreSQL.
- Database migration experience using AWS DMS.
- Experience building and maintaining CI/CD pipelines using GitLab.
- Understanding of developing and managing Infrastructure as Code using Terraform.
Responsibilities
- Collaborate with internal and client teams to resolve complex incidents, conduct root cause analyses, and document findings and preventive recommendations.
- Evaluate client IT infrastructure, prepare assessment reports, and support due diligence to document infrastructure maturity and improvement opportunities.
- Contribute to scalable, cost-effective IT infrastructure solution design; review reusable components; and develop technical documentation for deployed systems.
- Align release schedules and environment readiness, execute deployments according to protocols, perform post-deployment testing, and manage version control.
- Coordinate maintenance schedules, emergency fixes, and technology upgrades while maintaining integration with existing systems and processes.
- Analyze performance data, coordinate insights on system behavior, and support capacity planning to optimize performance.
- Conduct security checks, recovery drills, and compliance audits; implement security measures; and coordinate continuity plans.
- Identify automation opportunities, analyze infrastructure processes, and propose efficiency improvements.
- Coordinate with onsite, offshore, and vendor teams to document project requirements and support collaboration.
- Develop a centralized repository of technical and procedural knowledge, using insights from other projects to improve efficiency and retain organizational expertise.
- Design, administer, and support AWS cloud infrastructure, Amazon Redshift and RDS databases, and DevOps automation.
- Manage and optimize AWS services, including Amazon Redshift and RDS.
- Administer databases, including performance tuning, backup, recovery, and monitoring.
- Automate deployments, infrastructure provisioning, and operational processes.
- Troubleshoot production issues and support system reliability and availability.
Benefits
- Medical, dental, vision, and life insurance.
- Long-term and short-term disability insurance.
- Health and dependent care reimbursement accounts.
- Accident, critical illness, hospital indemnity, and legal insurance.
- 401(k) plan, with contributions dependent on salary level.
- Paid holidays and paid time off.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
