Senior Database Engineer

• Collaborate with developers and product managers to design and modify PostgreSQL database structures..
• Automate database provisioning and lifecycle management using Terraform on the AWS platform..
• Upgrade and patch RDS instances to meet compliance and uptime requirements..
• Possess extensive experience with a variety of data migration and database upgrade tasks across different platforms and technologies..
• Develop DB schema/delta SQL release automation workflows using Jenkins or GitHub Actions-based CI/CD software release pipelines..
• Efficiently perform performance tuning, monitoring, and alert configurations to ensure highly efficient and performant database operations..
• Constantly re-baseline the overall DB landscape to be cost-efficient..
• Propagate changes to the environment rapidly based on findings from the Security Engineering and Operations team..
• Maintain and refine DB data backup, replication, and restore processes..
• Identify and resolve performance bottlenecks in AWS environments..
• Be available for a 24x7 on-call rotation schedule..

Must Have Skills:.

• Overall 7+ years with 4 to 5 years of relevant experience in a Production Database team for a high-traffic e-commerce company..
• 3+ years of expert-level experience in highly available, mission-critical Postgres and MySQL database administration..
• 1+ years of experience in Terraform or Cloud Formation automation to provision and manage RDS on the AWS cloud platform.
• In-depth understanding of PostgreSQL engines with strong performance tuning skills..
• Experience in production system integration, log collection and analysis, builds, and performance monitoring/tuning..
• Ability to work independently and within a team environment..
• Ability to prioritize tasks effectively..
• Experience troubleshooting service outages, including after hours and weekends..
• Experience running production databases in a PCI-compliant environment..
• Experience running containerized databases and DB proxy services on Kubernetes..
• AWS Certification. Preferred.
• Familiarity with one of the following programming languages: Bash, Python, or Golang.

Qualification:.

• Bachelor of Science in Computer Science or equivalent technical training and professional work experience.