Senior Database Reliability Engineer

Randstad New Zealand; Wellington; On-site; NZD 120,000 - 160,000; Full time

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.

Skills

PostgreSQL

AWS

SAFe

DevOps

Python

Bash

CI/CD

Cloud technologies

Education

Bachelor Degree

ICT

Tools

CDK

CloudFormation

Terraform

PostGIS

RDS

Aurora

Python

Job description

• 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 environment.
• 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 is maintained through effective backup and recovery strategies.
• Provide production database support and triage, diagnosing and resolving issues raised through support tickets (e.g., access/permission requests, index and query issues).
• 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, occasionally outside standard business hours.

Key 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 environment.
• 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 is maintained through effective backup and recovery strategies.
• Provide production database support and triage, diagnosing and resolving issues raised through support tickets (e.g., access/permission requests, index and query issues).
• 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, occasionally outside standard business hours.

Skills & Experience

• 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.
• Effective communication and collaboration skills.
• Experience with database automation tools and scripting (e.g., Python, Bash).
• Experience triaging and resolving production database incidents/support requests in a timely manner.

Supportive & flexible employer with diverse groups & networks.

At Randstad, we are passionate about providing equal employment opportunities and embracing diversity to the benefit of all. We actively encourage applications from any background.

key responsibilities

• As a Senior with strong experience in PostgreSQL and cloud technologies, you will use your track record of managing, optimising, and securing database environments within a SAFe Agile Framework.

Skills

DevOps, infrastructure engineer, PostgreSQL, cloud, SAFe, AWS Aurora PostgreSQL, CI/CD pipelines

Qualifications

• Bachelor Degree

education

Bachelor Degree&ICT