PostgreSQL Database Administrator
EPAM Systems
⚲ Poland (Remote)
Wymagania
- PostgreSQL
- Shell
- MVCC
- pgBackRest
- Linux
- WAL
- Oracle SQL
- Python
- PITR
- DR Architectures
Opis stanowiska
We are looking for a PostgreSQL Database Administrator to support the engineering, configuration, and optimization of PostgreSQL environments at scale. This role focuses on maintaining high availability, performance, and security while collaborating with cross-functional teams on database initiatives. Responsibilities • Configure and manage PostgreSQL deployments including replication and distributed environments • Support version upgrades, migrations between on-premises and cloud, consolidation, and patch cycles • Assist in designing and implementing HA/DR solutions such as streaming replication and failover tools • Perform performance tuning using EXPLAIN ANALYZE, query plan tuning, and index optimization • Contribute to backup and restore strategies using pgBackRest or enterprise tools • Investigate transaction bottlenecks, locks, vacuum overhead, and WAL tuning • Participate in capacity forecasting and scalability improvements • Follow database security, encryption, credential rotations, and audit requirements • Collaborate with development teams on schema design, stored procedures, and data model optimization • Review database deployment plans and support release processes • Maintain documentation and best practices for database operations • Use scripting and configuration management for automation tasks Requirements • 3+ years of PostgreSQL DBA experience in enterprise or large-scale environments • Understanding of PostgreSQL internals, WAL behaviour, vacuum/autovacuum tuning, MVCC, indexing strategies, and partitioning • Skills in replication, failover management, and DR architectures • Experience with performance tuning using logs, perf views, and query plan analysis • Knowledge of pgBackRest, PITR, restore troubleshooting, and recovery scenarios • Proficiency in Linux administration and scripting with Shell or Python • Experience with migrations and database operations • Background in at least one other RDBMS such as Oracle, MS SQL, MySQL, or MongoDB • Communication and collaboration skills for cross-functional teamwork Nice to have • Experience with cloud-native PostgreSQL platforms such as AWS Aurora, RDS PostgreSQL, GCP Cloud SQL, or Azure • Knowledge of extensions including PostGIS, pg_partman, TimescaleDB, or pg_stat_statements • Experience with HA tools such as Patroni, repmgr, Pacemaker, or Corosync • Familiarity with CI/CD pipelines for DB deployments • Experience with large-scale OLTP or OLAP PostgreSQL systems We offer/Benefits We gather like-minded people: • Engineering community of industry professionals • Friendly team and enjoyable working environment • Flexible schedule and opportunity to work remotely within Poland • Chance to work abroad for up to 60 days annually • Business-driven relocation opportunities We provide growth opportunities: • Outstanding career roadmap • Leadership development, career advising, soft skills, and well-being programs • Certification (GCP, Azure, AWS) • Unlimited access to LinkedIn Learning, Get Abstract, Cloud Guru • English classes We cover it all: • Stable income (Employment Contract or B2B) • Participation in the Employee Stock Purchase Plan • Benefits package (health insurance, multisport, shopping vouchers) • Strategically located offices featuring entertainment and relaxation zones, table tennis and football, free snacks, fantastic coffee, and more • Referral bonuses • Corporate, social and well-being events Please, note: • The set of bonuses might vary based on the role you apply for – specifics will be discussed with our recruiter during the general interview. • We will reach out to selected candidates exclusively. EPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our customers, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.