Database Engineer (PostgreSQL SRE)

Description

Minimum Qualifications

• MS in Computer Science / Engineering or Equivalent.
• 8 - 12 years of experience supporting PostgreSQL databases in a high-volume, customer-facing environment
• In-depth understanding of PostgreSQL architecture and the internal workings of the PostgreSQL engine
• Strong experience in PostgreSQL optimization and performance tuning, including drill-down analysis and execution plan awareness
• Deep understanding of MVCC and how it is implemented in PostgreSQL
• Ability to perform major and minor version upgrades and migrations with near-zero downtime, while selecting the right approach for each situation
• Strong awareness of various types of maintenance operations, including when and how to perform them
• Hands-on experience configuring and supporting replication (logical, physical, active-active)
• Able to perform PostgreSQL installation via source code or RPM
• Strong knowledge of PostgreSQL parameters and tune those parameters and configurations to optimize performance, throughput, and resource utilization
• Manage day-to-day operations and issues, and extend expertise to provide the required support to the on-call/L2 team, including finding detailed RCAs for outages
• Experience implementing PostgreSQL security best practices
• Background in building and administering large-scale infrastructure supporting high transaction volumes in a mission-critical environment

Preferred Qualifications

• Able to manage user administration, permissions, and role-based access grants
• Able to implement standard backup methodologies (pg_dump/restore, online backups, Incremental backups, Differential backups )
• Proficient in SQL and at least one scripting language (Shell, Python)
• Strong communication skills and the ability to collaborate effectively across business and technical teams
• Ability to thrive in a fast-paced environment with tight delivery timelines
• Aptitude for independently learning and implementing new technologies for maximum benefit
• Strong hands-on experience with AWS (RDS/EC2), GCP (GKE), and AliCloud-related services
• Creative, out-of-the-box thinker, able to devise multiple solutions to the same problem
• Responsible for administering production, QA, and development database infrastructure
• Provides database architecture and design solutions
• Handles database infrastructure setup, configuration, upgrades/patching, monitoring, and troubleshooting
• Builds automation scripts for database infrastructure
• Measures and optimizes system performance, including capacity planning and forecasting
• Participates in evaluation, design, and development of new technologies, extensions, and features for highly scalable distributed databases
• Able to perform performance benchmarking between different versions of the same database technology, or between different database technologies, using pgbench or other open-source tools
• Able to manage databases deployed across cloud infrastructure, including AWS, GCP, AliCloud, and Kubernetes
• May require participation in a 12*7 FTE/L3 on-call support rotation with other team members
• Awareness of AI tolling and MCP servers.
• Deep expertise into the Oracle to PostgreSQL migration and associated challenges and solutions.
• Experience with CI/CD pipelines and Infrastructure as Code (Terraform, Ansible) is a plus
• Certified Kubernetes Administrator (CKA)
• AWS Certified Solutions Architect Associate