Senior PostgreSQL DBA (Aurora) — Remote & Automation

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

Descripción de la vacante

Workato is seeking a PostgreSQL DBA to own data-layer operations across multiple production data centers. You will optimize queries, manage Aurora PostgreSQL, and run PgBouncer in a fast-growing environment.

You will collaborate with application teams on data-model decisions, implement IaC with Terraform and Ansible, and drive automated upgrades and RCAs with a focus on reliability and observability.

Formación

• 5+ years of hands-on operational PostgreSQL experience (DBA / database reliability).
• 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.
• Scripting ability (Bash, Python or GO) and an automation-first mindset.
• Experience with cloud infrastructure (AWS preferred); strong incident-management and RCA skills.

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 push back when designs won’t scale.
• Operate and tune Aurora PostgreSQL: parameter groups, replicas, failover, capacity planning.
• Run and evolve PgBouncer connection-pooling layer.
• Automate operations: 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).

Conocimientos

PostgreSQL DBA

Query optimization

Automation mindset

Linux

Herramientas

Terraform

Ansible

PgBouncer

VictoriaMetrics

Vault

ArgoCD

Kubernetes

AWS

Descripción del empleo

Workato is seeking a PostgreSQL DBA to own data-layer operations across multiple production data centers. You will optimize queries, manage Aurora PostgreSQL, and run PgBouncer in a fast-growing environment.

You will collaborate with application teams on data-model decisions, implement IaC with Terraform and Ansible, and drive automated upgrades and RCAs with a focus on reliability and observability.