SQL Database Administrator

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

PostgreSQL Database Administrator.

Location: Gdańsk

Work mode: hybrid, 3 days from the office

Skills & Qualifications:

• Strong experience as DBA / PostgreSQL Database Administrator
• Experience in monitoring, managing and maintaining mission-critical 24*7 mission critical databases.
• Good understanding of PostgreSQL Architecture.
• Experience with Installation/Configuration/Administration PostgreSQL on Linux/Windows machines.
• Experience with implementing high-availability solutions.
• Experience in Installation /configuration of Replication, Connection pooling etc.
• Expert in Backup & Recovery including PG dump, setting up WAL archiving.
• Experience on PostgreSQL minor/major version upgrade.

Nice to have:

• MySQL
• Mongo dB
• MSSQL
• Oracle (at least one technology)

Key Responsibilities:

• Understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission critical production PostgreSQL databases.
• Replication using various methods like streaming, cascading and logical.
• HA solution of EDB PostgreSQL using EFM and Load balancer.
• Responsible for all Logical and Physical backup & Recovery even PITR recovery.
• Connection Pooling tools and Auditing of database.
• Regular maintenance of databases (eg. Vacuum, Reindexing, Archiving).
• Experience on community-supported tools like Pgbadger, Slony, PGadmin,Pgpool, Pgbouncer.
• Managing Clusters and upgrading/migrating various PostgreSQL database versions.
• Performance tuning.
• Developing database automation scripts and maintenance.
• Provide technical guidance for integration, testing, design, development, planning of new production systems/databases.
• Contribute to improving and creating DBA policies, procedures