Senior Engineer - Database

Xero; Auckland, Wellington; Hybrid; NZD 140,000 - 210,000; Full time

Job summary

Xero is seeking a senior database engineer in New Zealand or Australia to partner with database engineers and product teams to ensure resilience, quality, and performance of Xero's core database platform. You will guide migrations from SQL Server RDS to Aurora Postgres RDS and drive data architecture modernisation with AI-enabled tooling.

You will work with a collaborative team across ANZ, advising on schema design, query tuning, and observability using AWS tools to scale for millions of

Qualifications

• Deep expertise in SQL Server and SQL Server RDS.
• Experience with Aurora Postgres RDS migrations.
• Ability to identify risks early and implement sustainable solutions.
• Clear communication to translate database complexities for product teams.
• Openness to leveraging AI tools to boost productivity.

Responsibilities

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

Skills

SQL Server

SQL Server RDS

Aurora Postgres RDS

Query tuning

Migration planning

AWS tools

Observability

AI tooling

Communication

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.