Senior Database Engineer: SQL Server to Aurora Migration AI

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

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