Senior Database Administrator with PostgreSQL
We are seeking a Senior Database Administrator with expertise in PostgreSQL to join our dynamic team. This role involves managing and optimizing PostgreSQL databases, implementing high-availability solutions and ensuring system efficiency for a robust production environment.
Responsibilities
- Administer and support PostgreSQL databases, addressing configuration, tuning and optimization needs
- Design and implement high-availability architectures including replication and disaster recovery strategies
- Configure load balancing to ensure system fault tolerance and reliability
- Develop and manage connection pooling solutions to optimize performance
- Monitor database health, resource utilization and SQL query efficiency; identify and resolve issues that impact performance
- Analyze and improve database structures, indexes, queries and transactions to maximize system effectiveness
- Ensure data integrity and manage locking mechanisms for stable transaction handling
- Implement and maintain backup and recovery policies with regular validation of recovery procedures
- Maintain transaction log archiving and support recovery processes
- Operate and monitor Linux server environments in production database settings
- Document database configurations and operational activities to streamline processes
Requirements
- At least 5 years of experience working as a PostgreSQL database administrator
- Background in building and maintaining high-availability PostgreSQL clusters
- Competency in configuring replication, failover and disaster recovery mechanisms
- Proficiency in managing connection pooling systems for PostgreSQL
- Expertise in SQL with a focus on query optimization and performance tuning
- Knowledge of backup strategies, archiving with WAL and database recovery procedures
- Experience operating Linux servers in production database environments
Nice to have
- Showcase of skills in containerized environments like Docker and orchestration systems such as Kubernetes
- Familiarity with database monitoring and observability tools
- Understanding of microservices architecture and its integration with databases
