Job Title:
Postgres DBA
Location:
Dublin (Remote)
Salary/Rate:
Up to £409 Per Day
Start Date:
Jan ****
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.
#J-*****-Ljbffr