Postgres DBA - Dublin (Remote)

Job Title: Postgres DBA
Location: Dublin (Remote)
Salary/Rate: Up to £409 Per Day
Start Date: Jan 2026
Job Type: 6-month contract

Company Introduction

Experienced Postgres Database Administrator to manage, maintain, and optimise PostgreSQL environments across on-premises and cloud platforms for our client in the healthcare sector. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures.

Required Skills & Qualifications:

• Proven experience as a Postgres Database Administrator in enterprise environments.
• Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes.
• Hands-on experience with repmgr clustering, failover handling, and node recovery.
• Expertise in performance tuning, query optimisation, and troubleshooting.
• Experience with migration strategies from on-premises to cloud platforms.
• Familiarity with Google Cloud or Azure database services.
• Proficiency in backup, recovery, and disaster recovery planning.
• Working knowledge of logical replication and streaming replication.
• Excellent problem-solving and communication skills.

Preferred Qualifications:

• Experience with automation tools (Ansible, Terraform) for database deployments.
• Knowledge of monitoring tools like pgAdmin, Prometheus, or Grafana.
• Scripting skills in Shell, Python, or similar for automation.

Key Responsibilities:

Database Administration:

• Install, configure, and maintain PostgreSQL databases in production and non-production environments.
• Perform database refresh activities between environments as required.
• Execute patching and upgrade activities to ensure databases remain secure, stable, and up to date.

Architecture & Performance:

• Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimisation.
• Handle performance issues by analysing query execution plans, tuning configurations, and implementing best practices.

High Availability & Clustering:

• Implement and manage repmgr cluster technology for high availability and failover.
• Troubleshoot and resolve cluster node failure issues promptly to minimise downtime.

Migration & Cloud Integration:

• Design and execute migration strategies from on-prem to cloud environments.
• Knowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus.

Backup & Recovery:

• Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity.
• Implement logical and physical backup strategies using native PostgreSQL tools and third-party solutions.

Replication:

• Configure and manage logical replication for data synchronisation across environments.

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.