We are seeking a highly skilled Senior System Engineer - PostgreSQL DBA to join our team.
This role offers the opportunity to work on mission-critical database environments and contribute to the evolution of our data infrastructure. You will collaborate with experts across multiple disciplines to deliver reliable and scalable solutions.
Responsibilities
- Architect, configure, and manage complex PostgreSQL environments, including clustering, replication, and distributed setups
- Lead major version upgrades, migrations between on-premises and cloud platforms, consolidation efforts, and patch management
- Design and implement high-availability and disaster recovery solutions using streaming replication, logical replication, and failover technologies
- Perform advanced performance tuning through EXPLAIN ANALYZE, query plan optimization, index management, and parameter adjustments
- Develop and refine backup and restore strategies using pgBackRest or enterprise-grade tools
- Analyze transaction bottlenecks, lock contention, vacuum overhead, WAL tuning, and address large-scale performance challenges
- Plan and execute capacity forecasting and recommend scalability improvements
- Ensure database security, encryption, credential rotation, and audit compliance
- Collaborate with development teams on schema design, stored procedures, functions, and data model optimization
- Review and validate database deployment plans, participate in Change Advisory Board meetings, and support smooth release processes
- Create and maintain architecture diagrams, best practices, standards, and technical documentation
- Lead automation initiatives using scripting, configuration management, and DevOps methodologies
- Mentor L2 DBAs and provide technical leadership during major incidents
Requirements
- 6 to 10 years of hands-on experience as a PostgreSQL DBA in enterprise environments
- Comprehensive understanding of PostgreSQL internals, including WAL behavior, vacuum and autovacuum tuning, MVCC, indexing strategies, and partitioning
- Expertise in replication technologies such as streaming, logical, and cascading replication, as well as failover management and disaster recovery architectures
- Advanced performance tuning abilities using logs, performance views, system statistics, and query plan analysis
- Extensive experience with pgBackRest, point-in-time recovery (PITR), troubleshooting restores, and managing recovery scenarios
- Proficiency in Linux administration and scripting with Shell or Python for automation and operational tasks
- Proven track record in leading major incidents, migrations, and architectural discussions
- Working knowledge of at least one other RDBMS, such as Oracle, MS SQL, MySQL, or MongoDB
- Strong communication skills and ability to collaborate effectively across cross-functional teams
- Fluent English skills (written and spoken) at a B2+ level or higher
Nice to have
- Experience with cloud-native PostgreSQL platforms, including AWS Aurora, RDS PostgreSQL, GCP Cloud SQL, or Azure
- Knowledge of PostgreSQL extensions such as PostGIS, pg_partman, TimescaleDB, or pg_stat_statements
- Hands-on experience with high-availability tools like Patroni, repmgr, Pacemaker, or Corosync
- Familiarity with CI/CD pipelines for database deployments
- Background in managing large-scale OLTP or OLAP PostgreSQL systems
- PostgreSQL or EDB certifications
