Senior PostgreSQL DBA & Automation Engineer (Aurora)

Workato; United States; Remote; USD 120,000 - 150,000; Full time

Job summary

Workato is seeking a PostgreSQL DBA to own the data-layer across production data centers, designing indexes and schemas on multi-terabyte tables, and optimizing queries in an AWS-based Aurora PostgreSQL environment.

You will split time between handling developer requests and longer-term reliability projects, collaborating with application teams to ensure scalable data models, high availability, and automated deployments.

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.
• Analyze query plans, indexing, and schema reviews for large tables.
• Manage data migrations and partitioning strategies.
• Operate and tune Aurora PostgreSQL: replicas, failover, capacity planning.
• Run and evolve PgBouncer connection pooling.
• Automate runbooks with IaC tools (Terraform + Ansible).
• Drive incident response and RCAs for database issues.
• Maintain observability with postgres_exporter and VictoriaMetrics dashboards.

Skills

PostgreSQL

Query optimization

Terraform

Linux

PgBouncer

Bash

Python

Go

AWS

Incident management

Replication

Tools

Ansible

Terraform

PgBouncer

VictoriaMetrics

Vault

Kubernetes

EKS

ArgoCD

Job description

Workato is seeking a PostgreSQL DBA to own the data-layer across production data centers, designing indexes and schemas on multi-terabyte tables, and optimizing queries in an AWS-based Aurora PostgreSQL environment.

You will split time between handling developer requests and longer-term reliability projects, collaborating with application teams to ensure scalable data models, high availability, and automated deployments.