Postgresql dba iPaaS

The company operates a global automation platform that processes billions of events daily.

• Keep approximately 180 Aurora PostgreSQL clusters healthy, including managing indexes on large partitioned tables without downtime, query plans, and data migrations
• Handle Aurora configuration, including parameters, replicas, failover, and capacity, and optimize costs
• Own the PgBouncer layer and develop its roadmap
• Review schemas and data models with product teams, advising on partitioning, retention, and shared versus dedicated clusters
• Improve performance across the main application and search queries behind AI features, and research a 10,000 jobs/second target
• Package existing zero-downtime upgrade and switchover procedures into versioned, released automation
• Develop and deploy tooling for monitoring and managing the fleet in Kubernetes
• Handle incidents end-to-end, including root-cause analysis and follow-up fixes
• Contribute to resilience projects, including a cross-region DR pilot, application reconnect after failover, and CDC pipelines that survive upgrades
• Take part in time-boxed evaluations of new database technologies and make real decisions based on them

• 5+ Years operating PostgreSQL in production under real load
• Deep experience with schema design, debugging, and production performance troubleshooting
• Proficiency in SQL, query plans, indexing strategy, and performance work on multi-TB tables
• Expertise in the PostgreSQL ecosystem, including logical and streaming replication, HA and failover (Patroni), connection poolers (PgBouncer), major-version upgrades, and migrations with minimal downtime
• Linux fundamentals, including processes, memory, OOM behavior, and networking basics
• Scripting experience with Bash, Python, or Go, and an automation-first attitude
• Readiness to work actively with Kubernetes
• Strong RCA and incident management skills
• English at Upper-intermediate level (B2)

• Fully remote work with flexible hours from Spain, Bulgaria, or Portugal
• Relocation assistance to Spain or Bulgaria
• Benefits include health and life insurance, flexible vacation, education budget, and equipment