JustJoin.IT Praca zdalna Senior New

PostgreSQL Database Administrator (Fully Remote in Poland)

DCV Technologies

⚲ Poland (Remote)

Wymagania

  • PostgreSQL
  • backup & recovery
  • Automation Tools

Opis stanowiska

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