Middle/Senior DBA (PostgreSQL)
We are seeking an experienced and driven Middle/Senior DBA specializing in PostgreSQL to join our team. This role is pivotal in ensuring the availability, performance and security of our database systems in a dynamic production environment.
Responsibilities
- Administer PostgreSQL databases, focusing on configuration, tuning and optimization
- Design and implement high-availability architectures with replication and failover setups
- Configure load balancing mechanisms to ensure cluster fault tolerance
- Optimize database connection pooling performance for application services
- Monitor SQL query performance and system resource utilization to identify bottlenecks
- Analyze and enhance database structures, indexes, queries and transactions for efficiency
- Ensure data integrity, consistency and proper management of transactions and locks
- Develop backup, archiving and recovery policies while conducting routine recovery tests
- Support transaction log archiving and implement reliable recovery mechanisms
- Manage Linux-based servers in production database environments
- Document database configurations, operational activities and procedures
Requirements
- At least 5 years of experience with PostgreSQL database administration
- Background in designing and maintaining high-availability PostgreSQL clusters
- Expertise in configuring replication, failover mechanisms and disaster recovery solutions
- Proficiency in connection pooling systems for PostgreSQL
- Competency in SQL query performance tuning and optimization techniques
- Experience with backup strategies, WAL archiving and recovery processes
- Understanding of Linux-based server environments in database operations
- Strong written and verbal English communication skills (B2+)
Nice to have
- Background in containerization technologies like Docker and Kubernetes
- Experience with database monitoring and observability tools
- Understanding of microservices architecture and its database integration patterns
