SQL Database Administrator

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

Job summary

ALOIS UK in Poland is seeking a seasoned PostgreSQL DBA to manage and optimize production databases in a hybrid work setup.

You will implement replication, high-availability solutions, backups, and version upgrades, while tuning performance and building automation for reliable data services.

Qualifications

• Strong experience as a PostgreSQL Database Administrator.
• Experience in monitoring, managing and maintaining mission-critical 24x7 databases.
• Good understanding of PostgreSQL architecture.
• Experience with installation/configuration/administration PostgreSQL on Linux/Windows.
• Experience with implementing high-availability solutions.
• Experience with installation/configuration of replication and connection pooling.

Responsibilities

• Understanding operational requirements including hardware, architecture, configuration, integration and maintenance of production PostgreSQL databases.
• Setup and manage replication using streaming, cascading and logical methods.
• Implement and maintain HA solutions for PostgreSQL (e.g., EDB, EFM, load balancer).
• Handle logical and physical backup & recovery, including PITR.
• Manage connection pooling tools and database auditing.
• Regular maintenance tasks: vacuum, reindexing, archiving.
• Utilize community tools like PgBadger, Slony, PgAdmin, PgPool, Pgbouncer.
• Manage clusters and upgrade/migrate PostgreSQL versions.
• Performance tuning and database automation scripting.
• Provide technical guidance for integration, testing, design, development, and deployment of new systems.

Skills

PostgreSQL DBA

Database monitoring

PostgreSQL architecture

Linux/Windows Admin

High Availability

Replication & pooling

Backup & Recovery

Version upgrades

MySQL

MSSQL

Oracle

Tools

PgAdmin

Pgbadger

Slony

Pgpool

Pgbouncer

Job description

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
• 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