Senior Infrastructure Engineer (PostgreSQL DBA)

Job summary

The PostgreSQL DBA is responsible for managing PostgreSQL operations, including index and schema design, query optimization, and database migrations on Amazon Aurora. Key responsibilities include driving incident response, maintaining database observability, and automating processes using Terraform and Ansible, while collaborating with application teams on data-model decisions.

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