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
Robust 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 ****
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 ****.
We have placed multiple talented contractors in large federal government departments and private agencies.

📌 Senior Postgresql Dba (Canberra)
🏢 ContractRoll
📍 Canberra