Senior Engineer - Database

Xero; Manurewa; Hybrid; NZD 140,000 - 190,000; Full time

Benefits offered by this job

Flexible working

Office access

Job summary

Xero is seeking a Senior Database Engineer to partner with database engineers and product teams to ensure resilience, quality, and performance of our core database platform. You will guide migrations from SQL Server RDS to Aurora Postgres RDS and apply AI tooling to optimise day-to-day operations while proactively managing risks and releases.

Based in New Zealand or Australia, you will join a collaborative team working across ANZ with flexible working arrangements and opportunities to contribute

Qualifications

• Deep expertise in SQL Server and SQL Server RDS with a focus on query analysis and performance tuning.
• Hands-on experience with Aurora Postgres RDS and performing end-to-end migrations.
• A pragmatic owner of technical deliverables, able to identify risks early and implement sustainable solutions.
• Clear communication to translate database complexities for product teams and collaborate across disciplines.
• Curiosity to leverage AI tooling to streamline engineering workflows.

Responsibilities

• Manage and optimise day-to-day operations across SQL Server and SQL Server RDS fleets.
• Plan and execute end-to-end migrations from SQL Server to Aurora Postgres RDS.
• Integrate AI tools into engineering workflows to boost efficiency in query analysis and maintenance.
• Partner with product teams to advise on schema design, query tuning, and observability using AWS tools.

Skills

SQL Server

SQL Server RDS

Aurora Postgres RDS

Query performance tuning

Database migrations

AI tooling

AWS tools

Schema design

Observability

Cross-team collaboration

Tools

AWS tools

RDS management

Job description

The role / impact

You will partner with database engineers and product development teams to ensure the resilience, quality, and performance of Xero’s core database platform. By combining technical due diligence with modern AI tooling, you will help optimise day-to-day operations across our SQL Server fleet while proactively managing database risks, changes, and releases.

In this role, you will play a central part in modernising our data architecture as we migrate services from SQL Server RDS to Aurora Postgres RDS. You will provide strategic guidance on query performance and database design, supporting product teams with deep technical insights to build sustainable, scalable infrastructure for millions of customers.

The team / how they connect

You will join a supportive and collaborative team of senior database engineers spread across Australia and New Zealand. The team works closely with internal product squads, acting as trusted advisers to solve complex database challenges through open communication and shared problem-solving. Through daily standups and regular technical collaboration, team members learn from one another while supporting continuous delivery across our database platforms.

The team is currently working on / Initially, you will focus on

• Managing and optimising day-to-day operations across our extensive SQL Server and SQL Server RDS database fleet.
• Planning and executing end-to-end database migrations from SQL Server to Aurora Postgres RDS.
• Integrating AI tools into engineering workflows to increase efficiency in query analysis, risk identification, and proactive maintenance.
• Partnering with product development teams to consult on schema design, query tuning, and database observability using AWS tools.

Where and how you can work

This role is open to applicants based in New Zealand or Australia. We offer flexible working arrangements with no formal day-to-day in-office requirement, though you will have access to our local office spaces and will be invited to gather in person for key team events and connection days throughout the year.

Here are some of the things we are looking for

• Deep expertise in SQL Server and SQL Server RDS, with a strong emphasis on query analysis and performance tuning.
• Practical experience or familiarity with Aurora Postgres RDS, alongside a desire to contribute to active database migration projects.
• A pragmatic approach to technical ownership, with the capability to identify risks early and implement sustainable solutions.
• Clear communication skills that enable you to translate database complexities for product teams and collaborate effectively across disciplines.
• Curiosity and openness to leveraging AI tools to streamline routine tasks and enhance engineering productivity.