15 Nov
|
Montagu Group
|
Canberra
15 Nov
Montagu Group
Canberra
This prospect is for a Senior Infrastructure Engineer (PostgreSQL / EDB) to support a major federal government agency in delivering secure, highly available database platforms for critical digital services. The role focuses on designing, automating and operating enterprise-scale PostgreSQL and EDB environments across RHEL, OpenShift and VMware, using IaC, CI/CD and GitOps practices. Success in the role will mean resilient, performant and secure database services, robust backup and disaster recovery capabilities, and streamlined deployment and migration processes that meet demanding government standards.
Key Responsibilities:
- Configure and manage PostgreSQL and EDB high availability and disaster recovery (HADR) clusters using EDB Failover Manager (EFM) to ensure continuous service availability.
- Install, configure and administer EDB Postgres Enterprise Manager (PEM), including agents, database registration, performance monitoring, alerting and historical analysis.
- Design, develop and maintain Infrastructure-as-Code (IaC) and Ansible-based CI/CD pipelines for consistent PostgreSQL deployments across RHEL, OpenShift and VMware environments.
- Implement and maintain backup, restore and disaster recovery strategies, including automated backup orchestration, PITR, WAL archiving and replication-based recovery, aligned to agreed RPO/RTO targets.
- Lead and execute PostgreSQL migrations and upgrades using appropriate methodologies such as logical/physical replication, WAL shipping, database cloning and cross-platform server migration.
- Configure and harden PostgreSQL security, including LDAP/Active Directory integration, RBAC, TLS encryption,
X.509 certificate management and privileged access controls in line with enterprise security standards.
- Automate routine database administration tasks and operational processes using Python and shell scripting, and implement robust monitoring and logging to ensure reliability, availability and capacity management.
- Collaborate with other engineers and stakeholders, contribute to team capability uplift, and maintain comprehensive technical documentation, runbooks and standard operating procedures.
Requirements:
- Minimum five years’ experience as a PostgreSQL database administrator in complex, enterprise or government environments.
- Demonstrated experience designing, deploying and maintaining PostgreSQL deployments using Ansible-based CI/CD pipelines across RHEL, OpenShift and VMware platforms.
- Proven experience developing and maintaining Infrastructure-as-Code solutions (e.g., Ansible, Terraform or similar) for database provisioning, configuration and lifecycle management.
- Strong expertise in PostgreSQL performance tuning and optimisation, including query tuning, indexing strategies, configuration tuning and capacity planning.
- Demonstrated experience implementing PostgreSQL security controls,
including LDAP/Active Directory authentication, RBAC, encryption, auditing and compliance with security policies.
- Advanced knowledge of PostgreSQL and EDB high availability, replication, backup, PITR and disaster recovery solutions, including design and operational support.
- Solid scripting skills in Python and shell for automation, monitoring, deployment validation and troubleshooting of PostgreSQL environments.
- Ability to obtain and maintain an Australian Government NV1 security clearance, including meeting citizenship and background screening requirements.
Nice to Have:
- At least five years’ experience working with RHEL on OpenShift and VMware technologies in large-scale, mission-critical environments.
- At least three years’ experience building and maintaining Infrastructure-as-Code solutions for complex, multi-environment database platforms.
- At least two years’ hands-on experience designing, deploying and maintaining PostgreSQL environments specifically using Ansible CI/CD pipelines across RHEL, OpenShift and VMware.
- Prior experience in a federal government or highly regulated environment, with a strong track record in optimising PostgreSQL performance and implementing advanced database security controls.
This role will require you to submit your resume and well as a short Pitch to showcase your skills and experience to this role.
If you are interested and you have the skills and experience requires, I would love to have a chat. Please send your resume to facilitate a detailed conversation.
I look forward to hearing from you.
Suki
📌 Senior Infrastructure Engineer – PostgreSQL / EDB (Canberra)
🏢 Montagu Group
📍 Canberra