22 sep
|
Workato
|
Distrito del Ensanche
22 sep
Workato
Distrito del Ensanche
We are hiring a Senior PostgreSQL DBA to join our Infrastructure Storage team and own the health, performance, and day-to-day operations of the database fleet behind Workato's enterprise automation platform. You will work across dozens of Aurora PostgreSQL clusters in production data centers worldwide – a fleet that is about to double – as part of a small, versátil team of infrastructure specialists. Role Overview 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. Responsibilities 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. Requirem
📌 Senior Postgresql Dba (Distrito del Ensanche)
🏢 Workato
📍 Distrito del Ensanche