Senior PostgreSQL DBA: Scale, Optimize & Automate DB Layer

Workato; Lisbon (IA); On-site; USD 120,000 - 180,000; Full time

Job summary

Workato is seeking a PostgreSQL DBA to own the data layer, optimize multi-terabyte databases, and drive reliability across production clusters. The role focuses on index design, query plans, and automation to keep critical workloads healthy in a fast-growing environment.

You will collaborate with application teams, manage upgrades and replication, and contribute to observability and incident response. A strong background in Aurora PostgreSQL, PgBouncer, Terraform, and Ansible is required.

Qualifications

• 5+ years of hands-on operational PostgreSQL experience (DBA/reliability).
• Strong query plans, indexing, and performance work on large datasets.
• Experience with managed PostgreSQL (Aurora/RDS) and IaC.

Responsibilities

• Own day-to-day PostgreSQL operations across production data centers.
• Tune Aurora PostgreSQL: parameter groups, replicas, failover, capacity planning.
• Run and evolve PgBouncer connection pooling and automation pipelines.
• Drive incident response and RCAs for database issues; implement follow-ups.
• Maintain database observability with dashboards and alerts.

Skills

PostgreSQL

Performance tuning

Linux/Unix

Incident management

SRE practices

Tools

Terraform

Ansible

PgBouncer

AWS

Kubernetes

Job description

Workato is seeking a PostgreSQL DBA to own the data layer, optimize multi-terabyte databases, and drive reliability across production clusters. The role focuses on index design, query plans, and automation to keep critical workloads healthy in a fast-growing environment.

You will collaborate with application teams, manage upgrades and replication, and contribute to observability and incident response. A strong background in Aurora PostgreSQL, PgBouncer, Terraform, and Ansible is required.