Senior Database Administrator (PostgreSQL)
We are seeking a Senior Database Administrator (PostgreSQL) to manage and optimize complex PostgreSQL environments in a dynamic global support structure.
This role requires deep technical expertise, leadership capabilities, and a passion for ensuring database reliability and performance across enterprise-level systems.
Responsibilities
- Architect, configure, and manage complex PostgreSQL deployments including clustering, replication, and distributed environments
- Lead major version upgrades, migrations (On-Prem ↔ Cloud), consolidation and patch cycles
- Design and implement HA/DR solutions including streaming replication, logical replication and failover tools
- Perform advanced performance tuning using EXPLAIN ANALYZE, query plan tuning, index optimization and parameter adjustments
- Design backup and restore strategies with tools such as pgBackRest or enterprise solutions
- Analyze transaction bottlenecks, locks, vacuum overhead, WAL tuning and large-scale performance issues
- Plan capacity forecasting and scalability improvements for production environments
- Ensure database security, encryption, credential rotations and audit compliance
- Collaborate with development teams on schema design, stored procedures, functions and data model optimization
- Review database deployment plans, participate in CAB meetings and oversee release processes
- Develop architecture diagrams, documentation, best practices and database standards
- Lead automation efforts using scripting, configuration management tools and DevOps methodologies
- Mentor L2 DBAs and provide technical direction in high-impact incidents
Requirements
- 3+ years of PostgreSQL DBA experience focusing on enterprise-level operations
- Deep understanding of PostgreSQL internals such as WAL behavior, vacuum/autovacuum tuning, MVCC, indexing and partitioning strategies
- Expertise in replication (streaming, logical, cascading), failover management and DR architectures
- Advanced performance tuning skills including query plan analysis, logs, system statistics and performance views
- Experience with pgBackRest, PITR and troubleshooting restoration/recovery
- Proficiency in Linux administration and scripting languages such as Shell or Python
- Working knowledge of additional RDBMS such as Oracle, MS SQL, MySQL or MongoDB
- Strong communication skills for cross-functional teamwork and incident management
- English proficiency at B2 level or higher
Nice to have
- Experience with cloud-native PostgreSQL platforms on AWS Aurora, RDS PostgreSQL, GCP Cloud SQL or Azure
- Knowledge of extensions like PostGIS, pg_partman, TimescaleDB and pg_stat_statements
- Familiarity with HA tools such as Patroni, repmgr or Pacemaker/Corosync
- Background in CI/CD pipeline implementation for database deployments
- Expertise in large-scale OLTP/OLAP PostgreSQL systems
- PostgreSQL or EDB certifications
