PostgreSQL Database Administrator (Fully Remote in Poland)

PostgreSQL Database Administrator (Fully Remote in Poland)

We are looking for a skilled PostgreSQL Database Administrator to join our team.

Key Responsibilities:

• Understand operational requirements, including hardware, architecture, configuration, integration, and maintenance of mission-critical production PostgreSQL databases.

• Implement replication using various methods: streaming, cascading, and logical.

• Build HA solutions for EDB PostgreSQL using EFM and a load balancer.

• Handle all logical and physical backups and recovery, including Point-In-Time Recovery (PITR).

• Manage connection pooling tools and perform database auditing.

• Conduct regular database maintenance (e.g., VACUUM, reindexing, archiving).

• Work with community-supported tools such as Pgbadger, Slony, pgAdmin, Pgpool, and Pgbouncer.

• Manage clusters and upgrade/migrate various PostgreSQL database versions.

• Perform performance tuning.

• Develop database automation scripts and handle ongoing maintenance.

• Provide technical guidance for integration, testing, design, development, and planning of new production systems/databases.

• Contribute to improving and creating DBA policies, procedures, and standards.

Skills & Qualifications:

• Strong experience as a DBA / PostgreSQL Database Administrator.

• Experience in monitoring, managing, and maintaining mission-critical 24×7 databases.

• Good understanding of PostgreSQL architecture.

• Experience with installation, configuration, and administration of PostgreSQL on Linux/Windows.

• Experience implementing high-availability solutions.

• Experience installing/configuring replication, connection pooling, etc.

• Expert in backup and recovery, including pg_dump and setting up WAL archiving.

• Experience with PostgreSQL minor and major version upgrades.

Nice to have (at least one):

• MySQL

• MongoDB

• MSSQL

• Oracle