In this role you will own the data-layer for a large PostgreSQL-based system on Amazon Aurora, ensuring high performance and reliability at enterprise scale. You will balance day-to-day operations with longer automation projects, shaping data models and deployment practices for cross-functional teams. You’ll drive incident responses, improve observability, and turn manual procedures into repeatable automation. This role supports Workato’s mission to orchestrate AI-powered business processes with trust and scale.
Responsabilidades
- Own day-to-day PostgreSQL operations across production data centers (indexing, query-plan analysis, schema reviews, migrations)
- Collaborate with application teams on data-model decisions and scaling concerns
- Tune and operate Aurora PostgreSQL (parameter groups, replicas, failover, capacity planning)
- Maintain and evolve PgBouncer connection pooling
- Automate deployments and maintenance (Terraform + Ansible) for upgrades, switchover, and provisioning
- Lead incident response and RCAs for database issues, tracking follow-up actions
- Enhance database observability (postgres_exporter, VictoriaMetrics dashboards/alerts)
- Participate in duty rotation with focused off-duty time for deep work
Requisitos principales
- 5+ years of hands-on operational PostgreSQL experience (DBA / reliability)
- Strong experience with multi-TB table performance tuning and indexing
- Production experience with Aurora or RDS; awareness of its constraints
- Terraform and Infrastructure-as-Code proficiency; Linux comfort
- Experience with connection pooling (PgBouncer) in production
- Practical experience with logical replication, major-version upgrades, low-downtime migrations
- Scripting ability (Bash, Python or Go); automation-first mindset
- Cloud experience (AWS) with solid incident-management and RCA skills
- collaboration with cross-functional teams
- data-driven decision making
- problem-solving under pressure
- PostgreSQL (Aurora), multi-TB performance
- PgBouncer
- Terraform