Senior Infrastructure Engineer (PostgreSQL DBA)

Job summary

The PostgreSQL DBA is responsible for managing PostgreSQL operations across production data centers, focusing on index creation, query optimization, and data migrations. Key responsibilities include operating and tuning Aurora PostgreSQL, automating processes with Terraform and Ansible, and maintaining database observability using tools like postgres_exporter and VictoriaMetrics.

Qualifications

• 5+ years of hands-on operational PostgreSQL experience
• Strong command of query plans, indexing strategy, and performance work on multi-TB tables
• Production experience with managed PostgreSQL (Aurora or RDS)
• Working proficiency with Terraform and Infrastructure-as-Code practices
• Experience with connection pooling (PgBouncer or similar) in production
• Practical experience with logical replication, major-version upgrades, and low-downtime migration techniques
• Scripting ability (Bash, Python or GO) and an automation-first mindset
• Experience with cloud infrastructure (AWS preferred)

Responsibilities

• Own day-to-day PostgreSQL operations across all production data centers
• Partner with application teams on data-model decisions
• Operate and tune Aurora PostgreSQL
• Run and evolve PgBouncer connection-pooling layer
• Turn manual runbooks into released, repeatable automation
• Drive incident response and RCAs for database-related issues
• Maintain and improve database observability

Skills

Relocation