10 Nov
|
Trident Group
|
Australia
10 Nov
Trident Group
Australia
# Senior Infrastructure Engineer (PostgreSQL / EDB Database)Job Reference: #10000Federal Government AgencyNV1 RequiredAustralian CitizenServices AustraliaACT, SA, QLD, VIC, NSW, WAContractCloses 21/11/2026PostgreSQLEnterpriseDB (EDB)EDB Failover Manager (EFM)EDB Postgres Enterprise Manager (PEM)AnsibleCI/CDInfrastructure as Code (IaC)Red Hat Enterprise Linux (RHEL)OpenShiftVMwareGitOpsArgo CDGitLabPythonShell ScriptingDisaster RecoveryHigh Availability (HADR)LDAP / Active DirectoryRBACTLS / X.509 CertificatesShare##
About the Role
Role Overview:Database platform engineering: configure and manage HADR replication clusters with EDB Failover Manager (EFM); install, configure and administer EDB Postgres Enterprise Manager (PEM), including agent deployment, database registration, performance monitoring, query analysis, alerting and trend analysis.
Automation: develop and maintain infrastructure-as-code for PostgreSQL deployments; design, deploy and maintain PostgreSQL deployments using Ansible CI/CD pipelines across RHEL, OpenShift and VMware; configure Argo CD deployments integrated with GitLab; automate administration, monitoring, deployment validation and troubleshooting with Python and shell scripting.
Resilience: implement backup and disaster recovery
- automated backup orchestration, point-in-time recovery (PITR), WAL archiving and replication-based recovery
- to defined recovery objectives.
Migration and currency: plan and execute version upgrades and cross-platform migrations using logical and physical replication, WAL log shipping, backup and restore, cloning and server-level migration,
selecting the approach on compatibility, downtime, data integrity, performance, rollback and continuity; manage software installations and upgrades.
Security: configure PostgreSQL authentication with LDAP/Active Directory, centralised identity management, role-based access control, TLS encryption and X.509 certificates, privileged access controls and hardening to enterprise standards.
Team: contribute to capability uplift and maintain documentation; occasional out-of-hours work.
Key Responsibilities
• Senior PostgreSQL database engineer / DBA with at least five years' PostgreSQL administration, working with a high degree of independence.
• EDB stack: HADR replication clusters with EDB Failover Manager (EFM); EDB Postgres Enterprise Manager (PEM) installation, agents, registration and performance monitoring.
• Ansible CI/CD pipelines and infrastructure-as-code for PostgreSQL across RHEL, OpenShift and VMware; GitOps with Argo CD integrated with GitLab.
• High availability, replication, automated backup, PITR, WAL archiving and disaster recovery to defined recovery objectives.
• Version upgrades and cross-platform migrations (logical and physical replication, WAL shipping, backup and restore, cloning), choosing the approach on downtime,
compatibility and data integrity.
• PostgreSQL security: LDAP/Active Directory authentication, RBAC, TLS, X.509 certificates, privileged access and hardening.
• Python and shell scripting to automate administration, monitoring and deployment validation; performance tuning and troubleshooting of database and OS issues.
• MUST HOLD an active NV1 security clearance (Australian citizens only).### About the ClientMajor Australian Federal Government agency delivering government payments and services.## RequirementsEssential Criteria1. Minimum five years' PostgreSQL database administration experience.2. Experience designing, deploying and maintaining PostgreSQL deployments using Ansible CI/CD pipelines in RHEL OpenShift and VMware environments.3. Experience developing and maintaining infrastructure-as-code.4. Experience optimising PostgreSQL database integration and performance.5. Experience implementing PostgreSQL database security controls.
Desirable Criteria
• Minimum five years' experience with RHEL on 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 in RHEL OpenShift and VMware environments.
• Experience optimising PostgreSQL database integration and performance and implementing PostgreSQL database security controls.
Interested in this role? Submit your application today. #J-18808-Ljbffr
📌 Senior Infrastructure Engineer (Australia)
🏢 Trident Group
📍 Australia