Senior Database Administrator (PostgreSQL)
Primary stack
Nice to have's
Job description
About the Position
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
We Offer
- Opportunity to work with a leading company in the tech industry
- Competitive compensation package
- Flexible working hours and remote work options
About the Company
EPAM Systems is a global software engineering and product development company. We partner with the world's leading brands to deliver innovative digital solutions and drive digital transformation.
© EPAM. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.
EPAM helps organizations innovate their business processes and rethink the way they manage their businesses so they can remain competitive in this new digital age.