PostgreSQL DBA: HA, Replication & Automation

ALOIS UK; Województwo pomorskie; Hybrid; PLN 180,000 - 240,000; Full time

Job summary

ALOIS UK in Poland is seeking a PostgreSQL Database Administrator for a hybrid role based in Gdańsk to manage mission-critical databases. You will monitor, tune, and implement high-availability strategies across Linux/Windows environments and lead backups and PITR processes.

The ideal candidate has strong PostgreSQL expertise, experience with replication, WAL archiving and community tools, and a proactive approach to maintenance and automation.

Qualifications

• Experience as PostgreSQL DBA and 24x7 mission-critical DB management.
• Strong understanding of PostgreSQL architecture and Linux/Windows admin.
• Experience installing/configuring PostgreSQL and high-availability setups.
• Experience with replication, connection pooling, and WAL archiving for backups.
• Upgrading PostgreSQL minor/major versions.

Responsibilities

• Understand operational requirements for production PostgreSQL databases.
• Replication methods such as streaming, cascading, and logical.
• HA solutions using EDB PostgreSQL with EFM and Load Balancer.
• Backups and PITR recovery management.
• Connection pooling tools and auditing of databases.
• Regular maintenance: vacuum, reindexing, archiving.
• Tools like Pgbadger, Slony, PGAdmin, Pgpool, Pgbouncer usage.
• Cluster management and version upgrades/migrations.
• Performance tuning of databases.
• Automation scripting for maintenance tasks.
• Guidance for integration, testing, design and planning of new production systems.

Skills

PostgreSQL

Monitoring

High availability

Replication

Backup & Recovery

Performance tuning

Linux/Windows

Automation scripting

Tools

Pgbadger

Slony

PGAdmin

Pgpool

Pgbouncer

Job description

ALOIS UK in Poland is seeking a PostgreSQL Database Administrator for a hybrid role based in Gdańsk to manage mission-critical databases. You will monitor, tune, and implement high-availability strategies across Linux/Windows environments and lead backups and PITR processes.

The ideal candidate has strong PostgreSQL expertise, experience with replication, WAL archiving and community tools, and a proactive approach to maintenance and automation.