Senior PostgreSQL Database Administrator - Government

APG Workforce; Sydney; Hybrid; AUD 152,000 - 207,000; Full time

Job summary

APG Workforce is seeking a Senior PostgreSQL Database Administrator – Infrastructure Engineer to design, implement, optimise and maintain enterprise PostgreSQL infrastructure supporting government digital services. You will work independently, contribute to database modernisation, automation, DR planning and continuous improvement initiatives.

The role involves high availability configurations, IaC development, and scripting in Python and Shell.

Qualifications

• Minimum 5 years' experience in PostgreSQL database administration.
• 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.

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 PITR, WAL archiving and replication-based recovery.
• Plan and execute PostgreSQL upgrades and 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.

Skills

PostgreSQL

Ansible

CI/CD pipelines

IaC

Performance tuning

Security controls

Independent work

Tools

RHEL

OpenShift

VMware

EDB Failover Manager (EFM)

EDB Postgres Enterprise Manager (PEM)

Argo CD

GitLab

Python

Shell scripting

Job description

The Role

• Location: QLD, WA, ACT, VIC, NSW or SA
• Pay Rate:$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

The Role

• Location: QLD, WA, ACT, VIC, NSW or SA
• Pay Rate:$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

Senior PostgreSQL Database Administrator – Infrastructure Engineer

About the Role

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.

Essential Skills and Experience

• 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.

Highly Desirable

• 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.