Database Administrator Expert

About the role

A federal government client is seeking an experienced PostgreSQL Database Administrator to implement, manage and maintain enterprise database environments supporting critical digital services.

The role focuses on PostgreSQL database administration, high availability, performance optimisation, security, automation and disaster recovery across RHEL, OpenShift and VMware environments.

The successful candidate will have strong technical expertise in PostgreSQL, EDB Postgres Enterprise Manager (PEM), Ansible, CI/CD pipelines and infrastructure-as-code (IaC). The role operates under general direction, with a high degree of independence. Occasional out-of-hours work is required for scheduled activities or complex incidents.

NV1 clearance required

The role is open to QLD, WA, ACT, VIC, NSW, SA candidates

Key responsibilities

• Configure and manage PostgreSQL high availability and replication clusters using EDB Failover Manager (EFM).

• Install, configure and administer EDB Postgres Enterprise Manager (PEM), including agent deployment, database registration, performance monitoring and query analysis.

• Develop and maintain infrastructure-as-code for PostgreSQL deployments.

• Design, deploy and maintain PostgreSQL environments using Ansible CI/CD pipelines across RHEL, OpenShift and VMware.

• Configure ArgoCD deployments and integrate with GitLab to support GitOps workflows.

• Implement automated backup, disaster recovery and point-in-time recovery (PITR) strategies, including WAL archiving and replication-based recovery.

• Plan and execute database migrations, upgrades and cross-platform deployments.

• Configure PostgreSQL authentication and access controls, including LDAP/Active Directory, RBAC, TLS encryption and X.509 certificates.

• Manage database software installations and upgrades to maintain currency and compliance.

• Implement enterprise monitoring and logging, troubleshoot complex database and operating system issues, and maintain database reliability, availability and capacity.

• Contribute to team capability uplift and maintain technical documentation.

Desirable criteria

• Minimum five years’ experience with RHEL, OpenShift and VMware technologies.

• Minimum three years’ experience developing and maintaining infrastructure-as-code.

• Minimum two years’ experience designing, deploying and maintaining PostgreSQL deployments using Ansible CI/CD pipelines across RHEL, OpenShift and VMware environments.

• Experience optimising PostgreSQL database integration and performance.

• Experience implementing PostgreSQL database security controls.

Skills and experience

• Minimum five years’ PostgreSQL database administration experience.

• Strong experience designing, deploying and maintaining PostgreSQL environments using Ansible CI/CD pipelines across RHEL, OpenShift and VMware.

• Experience developing and maintaining infrastructure-as-code and automated PostgreSQL deployment solutions.

• Expertise in EDB Postgres Enterprise Manager (PEM), including performance monitoring, query analysis, resource diagnostics, alerting and historical trend analysis.

• Extensive experience with PostgreSQL high availability, replication, automated backups, PITR and disaster recovery.

• Demonstrated experience in PostgreSQL version upgrades and cross-platform migrations, including logical and physical replication, WAL shipping, backup and restore, database cloning and server migration.

• Strong knowledge of PostgreSQL security and access management, including LDAP/Active Directory, RBAC, TLS encryption, X.509 certificate management and security hardening.

• Experience implementing GitOps workflows using ArgoCD and GitLab.

• Strong Python and Shell scripting skills to automate database administration, deployment, monitoring and troubleshooting.

• Experience managing complex production incidents, performance diagnostics, root-cause analysis and resilient remediation strategies.

• Ability to maintain database reliability, availability, capacity and operational compliance across enterprise production environments.

Benefits

• Opportunity to work with a federal government client on critical digital services.

• Work on enterprise-scale PostgreSQL platforms and infrastructure.

• Exposure to modern technologies across PostgreSQL, RHEL, OpenShift, VMware and DevOps automation.

• Opportunity to contribute to technical capability uplift and continuous improvement within a government environment.

Contact Details

For a confidential chat, please contact Shilpa on 0438 027 836 or via email at shilpa@exclaim-it.com.au and we would be more than happy to provide you with additional information and assist in the application process.

Please note that a National Police Check might be required as part of pre-employment screening.