Senior AWS Aurora PostgreSQL Reliability Engineer

Randstad New Zealand

Wellington

On-site

NZD 120,000 - 160,000

Full time

5 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

Randstad New Zealand in Wellington is seeking an experienced Database Administrator focused on PostgreSQL and AWS Aurora. You will manage, optimise, and secure database environments, implement global Aurora PostgreSQL databases using CDK and CI/CD pipelines, and collaborate with developers, DevOps, and Product Owners to support database initiatives.

You will administer PostGIS and extensions, automate deployments with CDK/CloudFormation/Terraform, design disaster recovery, monitor performance,

Qualifications

Proven experience as a Database Administrator with a focus on PostgreSQL.
Strong understanding of AWS technologies and experience with AWS database services (e.g., RDS, Aurora).
Experience with spatial databases and geospatial data, particularly PostGIS.
Experience working in an Agile environment, with familiarity or certification in SAFe.
Excellent problem-solving skills and the ability to work independently and as part of a team.

Responsibilities

Manage, maintain, and optimise AWS Aurora PostgreSQL databases to ensure high availability and security.
Design and implement database solutions in AWS Aurora PostgreSQL global databases using CDK and CI/CD pipelines.
Collaborate with cross-functional teams, including developers, DevOps, and Product Owners, to support database-related needs and initiatives.
Administer PostGIS and other extensions in AWS Aurora PostgreSQL.
Maintain Postgres trusted language extensions (TLE) scripts and configurations.
Have experience managing AWS resources using CDK/CloudFormation/Terraform in production environments.
Design, implement, and maintain disaster recovery orchestration, including automated DR testing and reporting.
Monitor and benchmark database performance, building tooling to surface cluster-wide optimisation opportunities.
Ensure data integrity and resilience through effective backup and recovery strategies.
Provide production database support and triage, diagnosing and resolving issues raised through support tickets.
Support legacy system and database migrations, including engine version compatibility checks and data integrity validation during restores.
Support cutover and go-live activities, including migration rehearsals/dry-runs, execution, and rollback contingency planning.