Senior Infrastructure Engineer (PostgreSQL Database Administrator)

Workato; Madrid; Hybrid; EUR 60,000 - 90,000; Full time

Benefits offered by this job

Flexible Working Arrangements

Professional Development Opportunities

Wellness & Recreation Time

Job summary

Workato is seeking a PostgreSQL DBA to own data-layer design, query optimization, and reliable automation across multi-terabyte deployments on AWS Aurora. You will balance developer support with long-cycle reliability projects and drive incident response and RCAs.

The role requires hands-on ops experience with PostgreSQL, Terraform/Ansible automation, and strong knowledge of connection-pooling (PgBouncer) and Kubernetes for EKS-based tooling.

Qualifications

• 5+ years of hands-on operational PostgreSQL experience (DBA / database reliability role).
• Experience with cloud infrastructure (AWS preferred).
• Strong incident-management and RCA skills.
• Terraform and Infrastructure-as-Code practices; Linux proficiency.
• Scripting ability (Bash, Python or Go) and automation-first mindset.
• Experience with connection pooling (PgBouncer) in production.
• Experience with logical replication, upgrades with minimal downtime.
• Production experience with managed PostgreSQL (Aurora or RDS).
• Exposure to ClickHouse, OpenSearch, Redis/Valkey, Neo4j.
• Kubernetes fundamentals (EKS) for poolers, proxies, exporters.
• Vault, ArgoCD or GitOps workflows.
• Comfort using AI coding assistants to accelerate routine analysis.

Responsibilities

• Own day-to-day PostgreSQL operations across production data centers.
• Design indexes and schema on multi-terabyte tables; optimize queries for apps.
• Maintain and tune Aurora PostgreSQL: parameter groups, replicas, failover, capacity planning.
• Run PgBouncer and manage the connection-pooling layer.
• Automate runbooks into released, repeatable processes (Terraform + Ansible).
• Drive incident response and RCAs with follow-up actions.
• Improve database observability with exporters and dashboards.
• Split time between support for developer requests and long-cycle reliability projects.
• Partner with application teams on data-model decisions and scalable designs.
• Participate in duty rotation and protect focus time off-duty.

Skills

Hands-on PostgreSQL

Query optimization

Incident management

Terraform

Ansible

Bash

Python

Go

PgBouncer

Aurora PostgreSQL

Linux

CI/CD

Kubernetes

GitOps

AI coding assistants

Tools

AWS

Terraform

Ansible

PgBouncer

Aurora

Linux

ClickHouse

OpenSearch

Redis/Valkey

Neo4j

Kubernetes

Vault

ArgoCD

Job description

• As our PostgreSQL DBA, you will be the go-to engineer for everything data-layer: index and schema design on multi-terabyte tables, query optimization for application teams, connection pooling, upgrades, and migrations


• Our PostgreSQL runs on Amazon Aurora — operating a large, fast-growing fleet consistently: turning one-off procedures into reliable automation, keeping dozens of clusters healthy at once, and helping developers use the database well


• You’ll split your time between a support rotation for incoming developer requests and longer-cycle reliability and automation projects


• 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

Benefits

• Flexible Working Arrangements: We want to empower our employees to give us their 110%, and still be able to fully live their personal lives beyond what they do at Workato.


• Great Employee Benefits: Our employee benefits are designed not just to help everyone at Workato fulfill their basic and tangible needs, but also feel appreciated for their contributions to the company.


• Professional Development Opportunities: We are invested in the long-term professional development of our people, beyond what they bring to the table on their first day at work.

We support individual career ambitions, and set aside training programs and budgets they can tap on to upgrade both soft and hard skills.

• Dedicated Wellness & Recreation Time: We make it a point to dedicate time to pause, recharge and get to know each other better.

From virtual game nights to fitness sessions, there’s always time for a little fun on the calendars.

5+ years of hands-on operational PostgreSQL experience (DBA / database reliability role)Experience with cloud infrastructure (AWS preferred); strong incident-management and RCA skillsWorking proficiency with Terraform and Infrastructure-as-Code practices; comfortable in LinuxScripting ability (Bash, Python or GO) and an automation-first mindsetExperience with connection pooling (PgBouncer or similar) in productionPractical experience with logical replication, major-version upgrades, and low-downtime migration techniquesStrong command of query plans, indexing strategy, and performance work on multi-TB tablesProduction experience with managed PostgreSQL (Aurora or RDS) and a clear-eyed view of its constraintsOperational exposure to ClickHouse, OpenSearch, or Redis/Valkey, Neo4jKubernetes fundamentals (our poolers, proxies, and exporters run on EKS)Experience with Vault, ArgoCD, or GitOps workflowsComfort using AI coding assistants to accelerate routine analysis and tooling