> Markdown version of [/jobs/ext/3109032-infrastructure-engineer-postgresql-dba](https://www.wearedevelopers.com/jobs/ext/3109032-infrastructure-engineer-postgresql-dba). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Infrastructure Engineer (PostgreSQL DBA) - **Company:** Workato - **Location:** Madrid, Spain (Remote available) - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Bash Shell, Cloud Computing, Databases, Linux, Python (Programming Language), PostgreSQL, Neo4j, Operational Databases, Query Optimization, Redis, User Provisioning Software, Scripting, Kubernetes, Infrastructure Automation Frameworks, Vertica, Terraform - **Published:** September 27, 2026 - **Apply:** https://www.adzuna.es/contact-us.html ## About the Role + 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 ## 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. In this role, you 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. ## Related Videos - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [Putting the Graph In GraphQL With The Neo4j GraphQL Library](https://www.wearedevelopers.com/videos/257-putting-the-graph-in-graphql-with-the-neo4j-graphql-library) - [Reducing LLM Calls with Vector Search Patterns - Raphael De Lio (Redis)](https://www.wearedevelopers.com/videos/1714-reducing-llm-calls-with-vector-search-patterns-raphael-de-lio-redis) - [Postgres in the Age of AI (and Devin)](https://www.wearedevelopers.com/videos/1042-postgres-in-the-age-of-ai-and-devin) - [Discover the open source trio you didn’t expect: .NET and PostgreSQL on Linux](https://www.wearedevelopers.com/videos/2042-discover-the-open-source-trio-you-didn-t-expect-net-and-postgresql-on-linux) - [Docker exec without Docker](https://www.wearedevelopers.com/videos/1094-docker-exec-without-docker) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)