Senior PostgreSQL DBA & Infra Reliability Engineer

Workato; Madrid; Presencial; EUR 60.000 - 90.000; Jornada completa

Descripción de la vacante

Workato, Madrid-based, seeks an experienced PostgreSQL DBA to own data-layer operations for multi-terabyte environments. You will optimize queries, manage Aurora PostgreSQL, and ensure reliable automation with Terraform and Ansible.

The role balances production support with longer-term reliability projects in a fast-paced enterprise setting. Ideal candidates have extensive PostgreSQL experience, AWS familiarity, and strong scripting skills.

Formación

• 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.

Responsabilidades

• Own day-to-day PostgreSQL operations across all production data centers: index creation on large/partitioned tables, query-plan analysis, schema reviews, data migrations.
• Partner with application teams on data-model decisions - design, partitioning, retention, consolidation vs. standalone clusters - and push back with data when a design won't scale.
• Operate and tune Aurora PostgreSQL: parameter groups, replicas, failover behavior, capacity planning.
• Run and evolve our PgBouncer connection-pooling layer.
• Turn manual runbooks into released, repeatable automation: seamless upgrade, switchover, database/user provisioning, grants management (Terraform + Ansible).
• Drive incident response and RCAs for database-related issues, and land the follow-up actions.
• Maintain and improve database observability (postgres_exporter, VictoriaMetrics dashboards and alerts).
• Take part in the team's duty rotation handling developer requests, with protected focus time off-duty.

Conocimientos

PostgreSQL

Query optimization

Aurora PostgreSQL

Terraform

Linux

PgBouncer

Scripting (Bash/Python/Go)

AWS

Incident management

Herramientas

Terraform

Ansible

Kubernetes

PgBouncer

VictoriaMetrics

Vault

Linux

OpenSearch

Descripción del empleo

Workato, Madrid-based, seeks an experienced PostgreSQL DBA to own data-layer operations for multi-terabyte environments. You will optimize queries, manage Aurora PostgreSQL, and ensure reliable automation with Terraform and Ansible.

The role balances production support with longer-term reliability projects in a fast-paced enterprise setting. Ideal candidates have extensive PostgreSQL experience, AWS familiarity, and strong scripting skills.