We are seeking a skilled and experienced Senior Database Administrator to manage, optimize and ensure the availability of our PostgreSQL database systems. This role will focus on implementing robust solutions for high performance, scalability and reliability in a production environment.
Please note that for positions in Ukraine, we only consider candidates who are currently based in Ukraine or plan to return in the near future. Remote work is available only from Ukraine.
Responsibilities
- Administer and support PostgreSQL databases, including configuration, tuning and optimization
- Design and implement high-availability database architectures, including replication and disaster recovery mechanisms
- Configure load balancing and ensure fault tolerance of PostgreSQL clusters
- Implement and manage connection pooling solutions, optimizing connection performance
- Monitor database health, query performance and system resource usage; identify and resolve performance bottlenecks
- Analyze and optimize database structures, indexes and transactions for maximum efficiency
- Ensure data integrity and consistency through effective transaction and locking mechanisms
- Develop and maintain backup, archiving and recovery policies with regular testing of recovery processes
- Manage transaction logs and archiving to support robust recovery processes
- Operate and maintain PostgreSQL databases on Linux-based production servers
- Document database configurations, procedures and operational activities
Requirements
- At least 3 years of experience administering PostgreSQL databases
- Experience building and supporting high-availability PostgreSQL clusters, including replication and failover mechanisms
- Experience configuring and managing disaster recovery solutions for PostgreSQL
- Knowledge of connection pooling systems and optimization for PostgreSQL
- Proficiency in SQL query optimization and performance tuning
- Expertise in implementing backup, archiving (WAL) and recovery policies
- Background in managing PostgreSQL instances on Linux servers
- Fluent English communication skills at a B2+ level
Nice to have
- Experience with containerized environments like Docker and orchestration tools such as Kubernetes
- Familiarity with database monitoring and observability solutions
- Understanding of microservices architecture and its database integration patterns