Senior Infrastructure Engineer (PostgreSQL Database Administrator)

Workato; München; On-site; EUR 90,000 - 130,000; Full time

Benefits offered by this job

Flexible working arrangements

Professional development opportunities

Wellness & recreation time

Job summary

Workato is seeking an experienced PostgreSQL DBA to own data-layer operations across production clusters in a fast-growing environment. You will optimize queries, design indexes on multi-terabyte tables, and manage schema changes while ensuring reliability and automation.

The role involves a mix of support for developer requests and longer-term reliability projects, including tuning Aurora PostgreSQL, running PgBouncer, and implementing IaC with Terraform and Ansible.

Qualifications

• 5+ years of hands-on operational PostgreSQL experience.
• Production experience with managed PostgreSQL (Aurora/RDS).
• Experience with connection pooling (PgBouncer).
• Strong query planning and indexing on multi-TB tables.
• IaC familiarity with Terraform + Ansible; Linux proficiency.

Responsibilities

• Own day-to-day PostgreSQL operations across production data centers, including indexing and schema reviews.
• Analyze query plans and optimize performance for multi-tenant workloads.
• Operate and tune Aurora PostgreSQL, including replicas and failover behavior.
• Manage and evolve PgBouncer connection pooling layer and runbooks (Terraform + Ansible).
• Lead incident response and RCAs for database issues and follow-up actions.
• Collaborate with application teams on data-model decisions and partitioning strategies.

Skills

PostgreSQL

Aurora PostgreSQL

Query optimization

Automation mindset

Tools

PgBouncer

Terraform

Ansible

Linux

Kubernetes (EKS)

GitOps

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.

• Practical experience with logical replication, major-version upgrades, and low-downtime migration techniques
• 5+ years of hands-on operational PostgreSQL experience (DBA / database reliability role)
• Production experience with managed PostgreSQL (Aurora or RDS) and a clear-eyed view of its constraints
• Experience with connection pooling (PgBouncer or similar) in production
• Strong command of query plans, indexing strategy, and performance work on multi-TB tables
• Working proficiency with Terraform and Infrastructure-as-Code practices; comfortable in Linux
• Experience with cloud infrastructure (AWS preferred); strong incident-management and RCA skills
• Scripting ability (Bash, Python or GO) and an automation-first mindset
• Operational exposure to ClickHouse, OpenSearch, or Redis/Valkey, Neo4j
• Kubernetes fundamentals (our poolers, proxies, and exporters run on EKS)
• Experience with Vault, ArgoCD, or GitOps workflows
• Comfort using AI coding assistants to accelerate routine analysis and tooling