Sr PostgreSQL DBA – Aurora & Automation Lead

Workato; Barcelona; Presencial; EUR 90.000 - 130.000; Jornada completa

Descripción de la vacante

Workato is seeking a Senior PostgreSQL DBA to own the health, performance, and day-to-day operations of the database fleet behind its enterprise automation platform. You will manage dozens of Aurora PostgreSQL clusters across production data centers worldwide, in a compact, flexible team.

You will split time between support for developer requests and longer-cycle reliability and automation projects using Terraform, Ansible, PgBouncer, and Kubernetes.

Formación

• 5+ years of hands-on PostgreSQL operations (DBA / reliability).
• Strong understanding of indexing, query plans, and performance on large tables.
• Experience with managed PostgreSQL (Aurora/RDS) and cloud infra.
• Proficiency with Terraform and IaC; comfortable on Linux.
• Experience with connection pooling (PgBouncer).
• Scripting ability (Bash, Python, or Go) and automation mindset.
• Exposure to cloud infra (AWS) and incident management.

Responsabilidades

• Own day-to-day PostgreSQL operations across all production data centers: index creation, query-plan analysis, schema reviews, data migrations.
• Partner with application teams on data-model decisions and design for scalability.
• Operate and tune Aurora PostgreSQL: parameter groups, replicas, failover, capacity planning.
• Run and evolve PgBouncer connection-pooling layer.
• Automate runbooks: upgrades, switchover, provisioning, grants management (Terraform + Ansible).
• Drive incident response and RCAs for database issues and follow-up actions.
• Maintain and improve database observability (postgres_exporter, VictoriaMetrics dashboards).
• Handle duty rotation with protected focus time off-duty.

Conocimientos

PostgreSQL expertise

Query optimization

Terraform / IaC

PgBouncer

Linux proficiency

Scripting (Bash/Python/Go)

AWS / Cloud

Herramientas

Terraform

Ansible

Kubernetes

VictoriaMetrics

Vault

OpenSearch

Descripción del empleo

Workato is seeking a Senior PostgreSQL DBA to own the health, performance, and day-to-day operations of the database fleet behind its enterprise automation platform. You will manage dozens of Aurora PostgreSQL clusters across production data centers worldwide, in a compact, flexible team.

You will split time between support for developer requests and longer-cycle reliability and automation projects using Terraform, Ansible, PgBouncer, and Kubernetes.