Senior Database Engineer

Job Description

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.