Senior PostgreSQL DBA — Aurora & Automation Leader

Workato; Sofia (NM); On-site; USD 140,000 - 190,000; Full time

Job summary

Workato is seeking a PostgreSQL DBA to own data-layer operations across production environments. You will design indexes and schemas on large tables, optimize queries for application teams, and manage upgrades and migrations on Aurora PostgreSQL.

You'll split time between on-call rotations and longer-term reliability improvements, building automation with Terraform and Ansible to reduce manual toil and improve observability across clusters.

Qualifications

• 5+ years of hands-on operational PostgreSQL experience (DBA / database reliability role).
• Strong command of query plans, indexing strategy, and performance work on multi-TB tables.
• Production experience with managed PostgreSQL (Aurora or RDS) and a clear-eyed view of its constraints.
• Working proficiency with Terraform and Infrastructure-as-Code practices; comfortable in Linux.
• 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); strong incident-management and RCA skills.

Responsibilities

• Own day-to-day PostgreSQL operations across all production data centers: index creation on large/partitioned tables, query-plan analysis, schema reviews, data migrations.
• Partner with application teams on data-model decisions — design, partitioning, retention, consolidation vs. standalone clusters — and push back with data when a design won't scale.
• Operate and tune Aurora PostgreSQL: parameter groups, replicas, failover behavior, capacity planning.
• Run and evolve our PgBouncer connection-pooling layer.
• Turn manual runbooks into released, repeatable automation: seamless upgrade, switchover, database/user provisioning, grants management (Terraform + Ansible).
• Drive incident response and RCAs for database-related issues, and land the follow-up actions.
• Maintain and improve database observability (postgres_exporter, VictoriaMetrics dashboards and alerts).
• Take part in the team's duty rotation handling developer requests, with protected focus time off-duty.

Skills

PostgreSQL

Aurora PostgreSQL

PgBouncer

Terraform

Linux

Python

Tools

PgBouncer

Kubernetes

Terraform

Job description

Workato is seeking a PostgreSQL DBA to own data-layer operations across production environments. You will design indexes and schemas on large tables, optimize queries for application teams, and manage upgrades and migrations on Aurora PostgreSQL.

You'll split time between on-call rotations and longer-term reliability improvements, building automation with Terraform and Ansible to reduce manual toil and improve observability across clusters.