postgresql dba engineer

They are seeking an experienced PostgreSQL DBA with strong automation skills using Ansible. The ideal candidate will be responsible for managing, maintaining, and optimizing their PostgreSQL databases, and ensuring efficient and reliable automation for provisioning and maintenance tasks.

Key Responsibilities

• Administer, maintain, and tune PostgreSQL databases in production and non-production environments.

• Set up and maintain replication, backups, and high-availability configurations (e.g., Repmgr, Patroni, pgBackRest, pgbouncer/pgpool ). extra: TimescaleDB, PG vector flavors.

• Develop and maintain Ansible playbooks for PostgreSQL deployments, updates, and configurations.

• Troubleshoot and resolve database-related performance, capacity, and replication issues.

• Collaborate with DevOps and development teams to ensure database reliability and efficiency.

• Perform database upgrades and patching with minimal downtime.

• Implement security best practices and monitor for vulnerabilities.

• Document database environments, processes, and procedures.

Required Skills

• 4+ years of hands-on experience as a PostgreSQL DBA in a production environment.

• Solid experience with PostgreSQL versions 14 and above.

• Proficiency in writing and maintaining Ansible playbooks and roles.

• Experience with PostgreSQL performance tuning and optimization.

• Deep understanding of PostgreSQL internals, WAL, autovacuum, and indexes.

• Experience with backup/recovery tools (e.g., pgBackRest, Barman, Commvault).

• Familiarity with monitoring tools (e.g., Prometheus, Dynatrace, pg_stat_statements).

• Linux system administration experience (preferably Debian/Ubuntu or RHEL/CentOS).

• Scripting experience (Bash, Python) is a must.

• Decent in System administration (OS-DB tuning, VIP strategies, systemd logic)

Preferred Qualifications:

• Experience with Kubernetes and PostgreSQL Operators.

• Familiarity with CI/CD pipelines and infrastructure-as-code tools like Terraform.

• PostgreSQL certification or relevant coursework.

• Automation mindset. Eye for details, drive to bring structure and improve standards

What They Offer

• 22 annual vacation days, 3 sick days that are not carried to the next year (no medical certificate required)

• A seniority day is added every 3 years in the company

• Private medical insurance

• Monthly meal tickets

• A work culture based on cooperation and development – customized learning paths through external providers as well as special development programs.

• Wellbeing initiatives to encourage a healthy work life balance through webinars, specialized sessions and internal programs, per their colleagues’ input.

• In close cooperation is a value they live by, through moments that matter, like recurring hangout parties, team buildings, team bonding events.