Senior PostgreSQL Database Administrator - Government
Posted Updated
Summary
12-month contract (hybrid, extensions to 24 months) for a Senior PostgreSQL DBA to design, automate and maintain enterprise PostgreSQL infrastructure for government digital services: HA/DR with EDB tools, IaC with Ansible/CI-CD on RHEL, OpenShift and VMware, GitOps via Argo CD and GitLab, plus security, backups and upgrades. Pays $110-130/hour + super.
Salary: $110 - $130 per hour + Super
Senior PostgreSQL Database Administrator – Infrastructure EngineerThe Role
- Location: QLD, WA, ACT, VIC, NSW or SA
- Pay Rate: $110–$130 per hour + Super
- Estimated Start Date: 1 January 2027
- Initial Contract Duration: 12 months
- Extension Options: Up to a maximum of 24 months
- Work Arrangement: Hybrid
As a Senior PostgreSQL Database Administrator, you will be responsible for designing, implementing, optimising and maintaining critical enterprise database infrastructure supporting government digital services.
Working with a high degree of independence, you will contribute to database modernisation, infrastructure automation, disaster recovery planning and continuous improvement initiatives.
Occasional out-of-hours work may be required for scheduled maintenance or complex incident resolution.
Key Responsibilities
- Design, deploy, administer and optimise enterprise PostgreSQL database environments.
- Configure and manage high availability and disaster recovery (HADR) replication clusters using EDB Failover Manager (EFM).
- Install, configure and administer EDB Postgres Enterprise Manager (PEM), including performance monitoring, query analysis, alerting and diagnostics.
- Develop and maintain Infrastructure-as-Code (IaC) solutions for PostgreSQL deployments.
- Implement and maintain PostgreSQL deployments using Ansible and CI/CD pipelines across RHEL, OpenShift and VMware environments.
- Configure Argo CD deployments and integrate GitOps workflows with GitLab.
- Develop Python and Shell scripts to automate database administration and operational processes.
- Implement backup and disaster recovery strategies, including point-in-time recovery (PITR), WAL archiving and replication-based recovery.
- Plan and execute PostgreSQL upgrades and database migrations while minimising downtime and ensuring data integrity.
- Configure database security controls, including LDAP/Active Directory authentication, RBAC, TLS encryption and X.509 certificates.
- Troubleshoot complex database and operating system issues to maintain performance, availability and reliability.
- Maintain technical documentation and contribute to team capability development.
- Minimum 5 years' experience in PostgreSQL database administration.
- Demonstrated experience designing, deploying and maintaining PostgreSQL environments using Ansible CI/CD pipelines across RHEL, OpenShift and VMware.
- Experience developing and maintaining Infrastructure-as-Code (IaC).
- Strong capability in PostgreSQL database integration, performance tuning and optimisation.
- Experience implementing PostgreSQL security controls and enterprise access management.
- Strong technical problem-solving skills and the ability to work independently.
- Minimum 5 years' experience with RHEL, OpenShift and VMware technologies.
- Minimum 3 years' experience developing and maintaining Infrastructure-as-Code solutions.
- Minimum 2 years' experience implementing PostgreSQL deployments using Ansible and CI/CD pipelines.
- Experience with EDB Failover Manager (EFM) and EDB Postgres Enterprise Manager (PEM).
- Experience implementing GitOps workflows using Argo CD and GitLab.
- Strong Python and Shell scripting capabilities.
- Advanced knowledge of PostgreSQL migrations, disaster recovery, performance optimisation and database security.
Apply Now If you are an experienced PostgreSQL Database Administrator with strong infrastructure automation and DevOps capabilities, we encourage you to apply.
Apply today through APG Workforce to be considered for this government sector opportunity.