Senior Database Engineer

Roles and Responsibilities:

• 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.