Senior Postgresql Dba

Contractroll Pty Ltd

Canberra

Hybrid

AUD 165,000 - 248,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

ContractRoll Pty Ltd is seeking a senior PostgreSQL specialist to own the build, automation and operation of its enterprise PostgreSQL estate.

You will design, implement and run high availability, backups, and migrations across RHEL, OpenShift and VMware, delivering PostgreSQL as code through Ansible, CI/CD and GitOps pipelines.

Qualifications

  • Five+ years of hands-on PostgreSQL administration in production.
  • Experience deploying PostgreSQL with Ansible CI/CD pipelines on RHEL/OpenShift/VMware.
  • Infrastructure-as-code development experience.

Responsibilities

  • Configure and manage HADR replication clusters with EFM.
  • Install and administer PEM: agents, registration, monitoring, alerts.
  • Deploy PostgreSQL via Ansible CI/CD across RHEL/OpenShift/VMware.
  • Develop IaC for PostgreSQL deployments.
  • Configure Argo CD with GitLab pipelines.
  • Automate backup, PITR, WAL archiving and DR processes.
  • Plan migrations, version upgrades and server migrations.
  • Enforce LDAP/AD, TLS, X.509 and RBAC security controls.
  • Perform DB installs, upgrades and currency; document and share knowledge.

Skills

PostgreSQL
Ansible
CI/CD
GitLab
Python
Shell scripting
OpenShift
VMware
HADR
PITR
LDAP/AD
TLS/X.509
RBAC
Argo CD
GitOps

Tools

EDB Postgres Enterprise Manager (PEM)
EFM (Failover Manager)
Argo CD
GitLab CI/CD
RHEL
OpenShift
VMware
Ansible

Job description

Open to candidates across ACT, NSW, VIC, QLD, SA and WA. A major federal government agency needs a senior PostgreSQL specialist to own the build, automation and operation of its enterprise PostgreSQL estate on EDB Postgres. You will design and run high availability, backup and disaster recovery, and migrations, and you will deliver PostgreSQL as code through Ansible, CI/CD and GitOps pipelines across RHEL, OpenShift and VMware. This is hands‑on database platform engineering, not application development or data engineering.

Key responsibilities
  • Configuring and managing HADR replication clusters using EDB Failover Manager (EFM)
  • Installing, configuring and administering EDB Postgres Enterprise Manager (PEM): agent deployment, database registration, performance monitoring and alerting
  • Designing, deploying and maintaining PostgreSQL through Ansible CI/CD pipelines across RHEL, OpenShift and VMware
  • Developing and maintaining infrastructure-as-code for PostgreSQL deployments
  • Configuring Argo CD deployments integrated with GitLab
  • Backup and disaster recovery: automated backup orchestration, point-in-time recovery (PITR), WAL archiving and replication-based recovery
  • Planning and executing migrations and version upgrades: logical and physical replication, WAL shipping, backup and restore, cloning and server-level migration
  • Securing PostgreSQL with LDAP/Active Directory authentication, role‑based access control (RBAC), TLS encryption, X.509 certificates and hardening to enterprise standards
  • Database software installs, upgrades and currency
  • Documentation, team capability uplift and knowledge transfer
About you
  • At least five years of hands‑on PostgreSQL database administration in production environments
  • Proven experience deploying and maintaining PostgreSQL with Ansible CI/CD pipelines on RHEL, OpenShift and VMware
  • Experience developing and maintaining infrastructure-as-code
  • Strong PostgreSQL performance tuning and integration optimisation
  • Experience implementing PostgreSQL security controls (LDAP/AD, RBAC, TLS, X.509, privileged access)
  • Strong Python and Shell scripting for automation, monitoring and troubleshooting
  • Able to work independently under general direction, with occasional out‑of‑hours work for scheduled changes or incidents
  • Australian citizenship and the ability to obtain and maintain an NV1 (Negative Vetting Level 1) clearance
Nice to have
  • Five or more years with RHEL on OpenShift and VMware
  • Three or more years of infrastructure-as-code
  • Two or more years of PostgreSQL deployments through Ansible CI/CD pipelines
  • EDB Postgres, EFM and PEM experience in an enterprise or government environment
  • GitOps experience with Argo CD and GitLab
Security clearance

You must have NV1 (Negative Vetting Level 1) clearance. If you already hold a clearance, please tell us the level and whether it is active.

12-month initial contract with extension options

Starting January 2027

Canberra preferred; Sydney, Melbourne, Brisbane, Adelaide and Perth considered

Hybrid. Working from home is considered, provided you live within reasonable travel of the office for onsite attendance when needed

Competitive hourly rate

About us

ContractRoll Pty Ltd is a Canberra‑based boutique labour hire firm, trading since 2019. We have placed multiple talented contractors in large federal government departments and private agencies.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Infrastructure Engineer (Postgresql Dba)
Senior Infrastructure Engineer (Postgresql Dba)

Hunter Professional • Canberra

Hybrid
AUD 140,000 - 180,000
Senior Infrastructure Engineer (Postgresql Dba)
Senior Infrastructure Engineer (Postgresql Dba)

Hunter Professional • Melbourne

Hybrid
AUD 180,000 - 240,000
Hybrid work model
Database Administrator Experts
Database Administrator Experts

Exclaim IT • Canberra

On-site
AUD 120,000 - 165,000
Senior Infrastructure Engineer (PostgreSQL / EDB Database)
Senior Infrastructure Engineer (PostgreSQL / EDB Database)

Axiom Data Pty Ltd. • Canberra

Hybrid
AUD 110,000 - 150,000
Senior Infrastructure Engineer (Postgresql Dba)
Senior Infrastructure Engineer (Postgresql Dba)

Hunter Professional • Canberra, Brisbane, Melbourne, Sydney

Hybrid
AUD 150,000 - 210,000
Senior Infrastructure Engineer
Senior Infrastructure Engineer

ASJ Tech Pty Ltd • Canberra

Hybrid
AUD 120,000 - 150,000
Postgresql Database Administrator
Postgresql Database Administrator

People Connect Ict Solutions • Melbourne

Hybrid
AUD 140,000 - 200,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Vertical Scope Group • Canberra

On-site
AUD 140,000 - 200,000
$1,000 referral program
Senior Infrastructure Engineer (Database Administrator Expert – Postgresql Dba)-Canberra, Brisbane, Perth, Melbourne, Sydney And Adelaide
Senior Infrastructure Engineer (Database Administrator Expert – Postgresql Dba)-Canberra, Brisbane, Perth, Melbourne, Sydney And Adelaide

It Alliance Australia • Canberra

On-site
AUD 150,000 - 190,000
Database Administrator Experts
Database Administrator Experts

Exclaim IT • New South Wales

On-site
AUD 120,000 - 180,000
Work on enterprise-scale PostgreSQL
Exposure to modern DevOps tooling
Top locations