Workato · Posted 3w ago
Senior Infrastructure Engineer (PostgreSQL Database Administrator)
Job relayed by Stapply Data, its source: you apply there.
- Location
- 🇪🇸 Madrid, Spain
- Contract
- Full-time
- Role
- Platform & databases
- Source
- Stapply Data
Stack
- ClickHouse
- Argo
- PostgreSQL
- Redis
- Elasticsearch
- Neo4j
- Python
- Bash
- AWS
- Kubernetes
- Terraform
The posting
Join Workato as a Senior Infrastructure Engineer, specializing in PostgreSQL database administration. You will be responsible for all aspects of the data layer, including index and schema design, query optimization, and database operations. You will work closely with application teams on data-model decisions and drive incident response for database-related issues. This role offers flexible working arrangements, great employee benefits, professional development opportunities, and dedicated wellness and recreation time.
- Assurer la gestion quotidienne des opérations PostgreSQL, y compris la création d'index sur des tables volumineuses, l'analyse des plans de requête, les examens de schéma et les migrations de données. - Collaborer avec les équipes d'application sur les décisions de modèle de données, y compris la conception, la partition, la rétention et la consolidation, et fournir des données pour soutenir les décisions de conception. - Transformer les procédures manuelles en automatisation fiable, y compris les mises à niveau, les basculements, la provisionnement de bases de données et la gestion des droits.
- 5+ years of hands-on operational PostgreSQL experience (DBA / database reliability role) - Experience with cloud infrastructure (AWS preferred); strong incident-management and RCA skills - Working proficiency with Terraform and Infrastructure-as-Code practices; comfortable in Linux - Scripting ability (Bash, Python or GO) and an automation-first mindset - Experience with connection pooling (PgBouncer or similar) in production - Practical experience with logical replication, major-version upgrades, and low-downtime migration techniques - 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 - 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