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