← Все вакансии/Senior
SeniorRemoteSpain, Bulgaria, Portugal

PostgreSQL DBA

Уровень
Senior
Формат
Remote
О роли

Описание вакансии

About the company
  • A global B2B product company developing a powerful Integration Platform as a Service (iPaaS) that uses AI and machine learning to enable organizations to seamlessly connect data sources, cloud applications, and enterprise systems through low-code/no-code automation.
  • The platform is trusted by more than 400,000 customers worldwide, including leading companies such as Visa, Goldman Sachs, Cisco, Amazon, HubSpot, and L’Oréal.
  • The engineering culture emphasizes technical excellence, strong ownership, and close collaboration across globally distributed, remote-first teams.
Responsibilities
  • Keeping the Aurora PostgreSQL fleet healthy across all data centers: building indexes on large and partitioned tables without downtime, analyzing plans, and moving data.
  • Handling Aurora configuration (parameters, replicas, failover, capacity) and cost work: rightsizing, merging low-activity databases, and evaluating serverless.
  • Taking ownership of the PgBouncer layer, which currently needs an owner and a roadmap.
  • Reviewing schemas and data models with product teams, and advising on partitioning, retention, and shared vs. dedicated clusters, backing recommendations with data.
  • Working on the performance of the main application and the search queries behind AI features, including research toward a 10,000 jobs/second target.
  • Packaging the team's existing zero-downtime upgrade and switchover procedures into versioned, released automation, along with provisioning of databases and users, grants, and schema sync across data centers (Terraform, Ansible, GitOps).
  • Deploying tooling for monitoring and managing the PostgreSQL fleet in Kubernetes, and developing monitoring and alerting (exporters, VictoriaMetrics).
  • Handling database incidents end-to-end, including root-cause analysis and follow-up fixes, and taking part in resilience projects: a cross-region DR pilot, application reconnect after failover, and CDC pipelines that survive upgrades and failovers.
  • Contributing to time-boxed evaluations of new database technologies that end with a decision on what the company adopts.
  • Participating in the on-call rotation, with off-rotation time going to uninterrupted project work.
Requirements
  • 5+ years of experience operating PostgreSQL in production (DBA, DBRE, or SRE with a database focus) on databases under real load.
  • Deep experience with database schemas: design, debugging, and troubleshooting performance issues in production.
  • SQL proficiency, query plans, indexing strategy, and performance work on multi-TB tables.
  • Expertise in the ecosystem around PostgreSQL, not only the database itself: streaming and logical replication, HA and failover setups (Patroni or equivalent), connection poolers (PgBouncer), major-version upgrades and migrations with minimal downtime.
  • Linux fundamentals: processes and memory, OOM behavior, networking basics.
  • Scripting skills (Bash, Python, or Go) and an automation-first attitude: you prefer to script a repeated manual task when possible.
  • Readiness to work actively with Kubernetes: deploying tooling for monitoring and managing the PostgreSQL fleet.
  • Strong RCA and incident management skills.
  • Good level of English — at least Upper-intermediate (B2).
Nice-to-Haves
  • Experience with Infrastructure as Code (Terraform) and cloud infrastructure.
Conditions
  • Locations: Spain, Bulgaria, or Portugal ONLY (relocation assistance may be provided).
  • Full-Time employment.
Стек и навыки

С чем работаем