Senior PostgreSQL & Database Infrastructure Engineer (Hybrid)

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

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.