Senior PostgreSQL DBA
We are seeking a Senior PostgreSQL DBA to lead advanced engineering, architecture, and performance initiatives for enterprise-scale PostgreSQL environments.
This role offers the opportunity to drive modernization, automation, and strategic collaboration across development, product, cloud, and infrastructure teams.
The role follows regular business hours. Weekend on-call support may be required. On-call duty typically occurs once per month, with a maximum of two occurrences per month.
Responsibilities
- Architect, configure, and manage complex PostgreSQL deployments including clustering, replication, and distributed environments
- Lead major version upgrades, migrations between On-Prem and Cloud, consolidation, and patch cycles
- Design and implement HA/DR solutions such as streaming replication, logical replication, and failover tools
- Perform advanced performance tuning using EXPLAIN ANALYZE, query plan tuning, index optimization, and parameter tuning
- Design and optimize backup and restore strategies using pgBackRest or enterprise tools
- Analyze transaction bottlenecks, locks, vacuum overhead, WAL tuning, and large-scale performance issues
- Plan and execute capacity forecasting and scalability improvements
- Ensure database security, encryption, credential rotations, and audit readiness
- Partner with development teams on schema design, stored procedures, functions, and data model optimization
- Review and validate database deployment plans, participate in CAB meetings, and ensure smooth releases
- Develop and maintain architecture diagrams, best practices, standards, and documentation
- Lead automation initiatives using scripting, configuration management, and DevOps practices
- Mentor L2 DBAs and provide technical leadership during major incidents
Requirements
- 6–12 years of strong PostgreSQL DBA experience including enterprise-level operations
- Deep understanding of PostgreSQL internals, WAL behaviour, vacuum/autovacuum tuning, MVCC, indexing strategies, and partitioning
- Strong expertise with replication (streaming, logical, cascading), failover management, and DR architectures
- Advanced performance tuning skills using logs, perf views, system stats, and query plan analysis
- Strong experience with pgBackRest, PITR, restore troubleshooting, and recovery scenarios
- Proficiency in Linux administration and scripting with Shell or Python
- Solid experience leading major incidents, migrations, and architectural discussions
- Working knowledge of at least one other RDBMS: Oracle, MS SQL, MySQL, or MongoDB
- Strong communication and cross-functional collaboration skills
Nice to have
- Experience with cloud-native PostgreSQL platforms such as AWS Aurora, RDS PostgreSQL, GCP Cloud SQL, or Azure
- Knowledge of extensions including PostGIS, pg_partman, TimescaleDB, or pg_stat_statements
- Experience with HA tools such as Patroni, repmgr, or Pacemaker/Corosync
- Familiarity with CI/CD pipelines for DB deployments
- Experience with large-scale OLTP or OLAP PostgreSQL systems
