Senior PostgreSQL DBA & Infra Automation Engineer

Workato; Berlin (NH); On-site; USD 140,000 - 200,000; Full time

Job summary

Workato is seeking a seasoned PostgreSQL DBA to own production data-layer operations across multiple data centers. You will design indexes, optimize queries, and manage migrations on Aurora PostgreSQL, while maintaining robust observability and automation.

You will split time between on-call support and longer-term reliability projects. You will collaborate with application teams on data-model decisions, drive capacity planning, and ensure low-downtime upgrades using PgBouncer and IaC tooling.

Qualifications

• 5+ years of hands-on PostgreSQL operations in production environments.
• Production experience with AWS managed PostgreSQL (Aurora/RDS) required.
• Strong IaC skills using Terraform; comfortable with Ansible and Kubernetes.
• Experience with PgBouncer or similar connection pooling in production.
• Practical knowledge of logical replication, major-version upgrades, and low-downtime migrations.
• Scripting ability (Bash, Python or Go) and automation-first mindset.
• Experience with cloud infrastructure (AWS) and robust incident-management skills.

Responsibilities

• Own day-to-day PostgreSQL operations across production data centers.
• Collaborate with application teams on data-model decisions and scale decisions.
• Operate and tune Aurora PostgreSQL for performance and reliability.
• Run and evolve PgBouncer connection-pooling layer.
• Automate runbooks and releases for upgrades, switchover, and provisioning.
• Lead incident response and RCAs, implementing follow-up actions.
• Improve database observability with dashboards and alerts.
• Participate in on-call rotations with focused, off-duty time.

Skills

PostgreSQL

Aurora/RDS

Terraform

Linux

PgBouncer

Replication

Scripting (Bash/Python/Go)

AWS

Incident management

Tools

Terraform

Ansible

Kubernetes

Job description

Workato is seeking a seasoned PostgreSQL DBA to own production data-layer operations across multiple data centers. You will design indexes, optimize queries, and manage migrations on Aurora PostgreSQL, while maintaining robust observability and automation.

You will split time between on-call support and longer-term reliability projects. You will collaborate with application teams on data-model decisions, drive capacity planning, and ensure low-downtime upgrades using PgBouncer and IaC tooling.