Senior Infrastructure Engineer (PostgreSQL DBA)

Workato; Berlin; Vor Ort; EUR 90.000 - 130.000; Vollzeit

Zusammenfassung

Workato is seeking a seasoned PostgreSQL DBA to own data-layer operations across production centers. You will optimize multi-TB queries, manage Aurora/PostgreSQL, tune replication and connection pools, and automate procedures with Terraform + Ansible.

Lead incident responses, improve observability, and collaborate with application teams on scalable data-model decisions in a fast-paced, enterprise AI environment.

Qualifikationen

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

Aufgaben

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

Kenntnisse

PostgreSQL

Query optimization

Aurora/RDS

Terraform

Ansible

PgBouncer

Linux

Scripting (Bash/Python/Go)

AWS

Incident management

Tools

PgBouncer

Kubernetes (EKS)

VictoriaMetrics

Vault

ArgoCD

Terraform

Ansible

ClickHouse

OpenSearch

Jobbeschreibung

About Workato

Workato is the leading Control and Execution Platform for Enterprise AI - the neutral platform enterprises trust to put AI to work across their business. Workato unifies data, applications, and processes into a single platform so AI can reliably orchestrate business processes in production at enterprise scale. Built on more than a decade of running mission-critical processes for over half the Fortune 500 - including Nasdaq, Amazon, Cisco, Vodafone, Atlassian, and Lucid Motors - Workato turns over 14,000 enterprise systems AI needs to act on into one governed execution layer. For more information, visit workato.com .

Why join us?

Ultimately, Workato believes in fostering a flexible, trust-oriented culture that empowers everyone to take full ownership of their roles . We are driven by innovation and looking for team players who want to actively build our company.

But, we also believe in balancing productivity with self-care . That's why we offer all of our employees a vibrant and dynamic work environment along with a multitude of benefits they can enjoy inside and outside of their work lives.

Also, feel free to check out why:

• Business Insider named us an "enterprise startup to bet your career on"
• Forbes' Cloud 100 recognized us as one of the top 100 private cloud companies in the world
• Deloitte Tech Fast 500 ranked us as the 17th fastest growing tech company in the Bay Area, and 96th in North America
• Quartz ranked us the #1 best company for remote workers

Responsibilities

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.

In this role, y ou will also be responsible to:

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

Requirements

Qualifications / Experience / Technical Skills

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

Nice to Haves

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

Tech Stack

• AWS - Aurora PostgreSQL - Kubernetes - PgBouncer - Terraform - Ansible - VictoriaMetrics - Vault - Linux