Design, implement, and operate highly available PostgreSQL clusters (physical/logical replication, sharding, partitioning, failover automation)
Optimize query performance and indexing strategies
Perform capacity planning, growth forecasting, and workload modeling
Own high-availability strategies, including automatic failover, multi-region deployments, disaster recovery
Build and maintain automation for provisioning, configuration, backups, failovers, vacuum tuning, schema management
Use tools such as Terraform, Ansible/SaltStack, Bash, Python
Develop monitoring and alerting systems for PostgreSQL clusters
Lead response during database incidents
Conduct root-cause analysis and implement long-term fixes
Partner with software engineers to review SQL queries, optimize schemas, ensure effective use of PostgreSQL features

Requirements

7+ years of hands-on PostgreSQL experience in large-scale, high-volume production environments
Strong expertise in PostgreSQL internals: WAL, MVCC, vacuum tuning, query planner, indexing, logical replication
Advanced SQL and strong schema design and query optimization skills
Solid experience with Linux systems and networking fundamentals
Experience building automation using Go or Python
Experience with monitoring tools such as: Prometheus, Grafana, Datadog, PMM, pg_stat_statements

Benefits

fair compensation
generous benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PostgreSQLquery optimizationschema designphysical replicationlogical replicationshardingpartitioningfailover automationcapacity planningworkload modeling

Soft Skills

leadershipincident responseroot-cause analysiscollaboration