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.
How to Apply:
Click the APPLY button and include your resume and cover letter or for further information please contact Helen or email helen.avery@randstaddigital.co.nz
*Please note, we can only consider applicants that are legally entitled to work in New Zealand at the time of application.
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.