Senior Database Engineer – SQL Server

Create your best future and join Westpac as a Senior Database Engineer - SQL Server. What’s the role? The Senior Database Engineer will optimise and safeguard the bank’s mission-critical SQL Server estate across thousands of on-premises and cloud-based instances. The role will lead the adoption of AI in database operations, using analytics and trending to predict issues, accelerate resolution, improve IT serviceability and support data-driven decisions across capacity, performance, cost and risk. The role will partner with technology teams and vendors to offer a highly available, secure and compliant database platform services to our customers. It will also participate in the on-call roster and provide technical support to the during major incidents and events. What do I need? 8+ years of hands-on database engineering experience , supporting enterprise Microsoft SQL Server 2016+ environments, including SSIS, PBIRS, SSAS and large-scale SQL Server implementations. Strong knowledge of SQL Server internals, relational database design and performance engineering , with advanced troubleshooting and root-cause analysis skills using Extended Events, performance data and monitoring telemetry. Strong experience designing, implementing and testing high availability and disaster recovery , including Always-On Availability Groups, Windows Server Failover Clustering and backup and recovery strategies. Strong automation and scripting capability using T-SQL, PowerShell, Json , with experience automating database provisioning, patching, maintenance and operational activities through DevOps and infrastructure-as-code practices. Experience applying AI and AIOps to database engineering and operations, including AI-assisted development and query optimisation, anomaly detection, log and telemetry correlation, and predictive capacity forecasting. Strong data analytics capability using Power BI to develop performance baselines and identify capacity, availability, incident and change trends across database environments. Experience with cloud database platforms , including Azure SQL Database, Azure SQL Managed Instance and/or AWS RDS for SQL Server or other DBMS, including automated tuning and monitoring capabilities. Strong understanding of database security and compliance , including encryption, auditing, least-privilege access and security controls within highly regulated environments. Experience supporting large-scale, mission-critical environments , ideally within banking or financial services, with the ability to translate technical findings into recommendations across capacity, software currency, cloud migration, cost optimisation and risk. Flexibility to participate in an after-hours/weekend on-call roster and provide extended support during major incidents. Highly desirable: Hands-on experience implementing or supporting other database technologies such as PostgreSQL, MongoDB or Neo4j. Desirable: Experience supporting SAP environments and Unix based platforms. Why join us? We’re obsessed with becoming our customers' #1 banking partner for life and we’re looking for people who are passionate about helping us achieve that goal. In return, we’re committed to making Westpac the best place to work in the country. Here are just a few of the ways we’re already doing that: Special offers on banking products and discounts from top brands, including generous employee-only mortgage rates! Flexible work arrangements to help you achieve a greater work/life balance, and a variety of leave options including Culture, Lifestyle and Wellbeing leave. Tailored learning and development opportunities to help your grow your career within the bank. Lots of opportunities to ‘give back’ to the Community by getting involved in our many volunteering initiatives. Create your future today To get started, simply click on the APPLY or APPLY NOW button We’re all about creating a supportive and inclusive community. We welcome everyone – no matter your age, gender, background, or abilities. We also provide additional support to welcome our veterans, Indigenous Australians and neurodiverse community. If you need any adjustments during the recruitment process, you can find more information and contact details on our FAQs and how to contact us page , under the ‘Diversity, sustainability and flexibility’ section. We may close this job advertisement earlier than the advertised closing date if suitable candidates are identified. We encourage you to apply as soon as possible. #LI - Hybrid.