About Workato
Workato provides a Control and Execution Platform for Enterprise AI. It unifies data, applications, and processes so AI can orchestrate business processes in production at enterprise scale.
Responsibilities
•Own day-to-day PostgreSQL operations across production data centers, including index creation on large or partitioned tables, query-plan analysis, schema reviews, and data migrations
•Partner with application teams on data-model decisions, including design, partitioning, retention, and cluster consolidation, and challenge designs that will not scale
•Operate and tune Aurora PostgreSQL, including parameter groups, replicas, failover behavior, and capacity planning
•Run and evolve the PgBouncer connection-pooling layer
•Turn manual runbooks into repeatable automation for upgrades, switchovers, database and user provisioning, and grants management using Terraform and Ansible
•Drive incident response and root cause analyses for database-related issues, and implement follow-up actions
•Maintain and improve database observability using postgres_exporter, VictoriaMetrics dashboards, and alerts
•Participate in the team's duty rotation handling developer requests, with protected focus time off-duty
•Support incoming developer requests and deliver longer-cycle reliability and automation projects
Requirements
•5+ years of hands-on operational PostgreSQL experience in a DBA or database reliability role
•Strong command of query plans, indexing strategy, and performance work on multi-TB tables
•Production experience with managed PostgreSQL (Aurora or RDS) and understanding of its constraints
•Working proficiency with Terraform and Infrastructure-as-Code practices; comfortable in Linux
•Production experience with connection pooling (PgBouncer or similar)
•Practical experience with logical replication, major-version upgrades, and low-downtime migration techniques
•Scripting ability in Bash, Python, or GO, and an automation-first mindset
•Experience with cloud infrastructure (AWS preferred), incident management, and root cause analysis
Nice to have
•Operational exposure to ClickHouse, OpenSearch, Redis/Valkey, or Neo4j
•Kubernetes fundamentals
•Experience with Vault, ArgoCD, or GitOps workflows
•Comfort using AI coding assistants for routine analysis and tooling
