Senior Data Engineer

Senior Data Engineer | SQL Server DBA

Melbourne’s Eastern Suburbs | $180K–$200K package including super | Hybrid – 3 days onsite

Are you an experienced SQL Server DBA who enjoys taking ownership of business-critical database environments, solving complex performance challenges and delivering database improvements?

We are partnering with an established organisation in the healthcare sector seeking a hands-on Senior Data Engineer with strong Microsoft SQL Server Database Administration expertise.

The Opportunity

Working closely with the CIO and stakeholders across the business, you will be responsible for the administration, performance, security and ongoing development of the organisation's SQL Server databases, enterprise data warehouse and reporting environment.

Key Responsibilities

• Own the day-to-day administration, maintenance, monitoring and optimisation of Microsoft SQL Server environments.
• Manage database performance, troubleshooting, indexing, query tuning, backup/recovery, security and production support.
• Develop and optimise complex T-SQL queries, stored procedures, functions and database objects.
• Maintain and enhance enterprise data warehouse solutions, dimensional models and data marts.
• Develop and support ETL/ELT processes, including SSIS and SQL Server Agent automation.
• Plan and support the upgrade from SQL Server 2019 to SQL Server 2025, including testing, migration, cutover and rollback planning.
• Maintain data quality, governance, security and operational documentation.
• Support Power BI reporting and collaborate with business stakeholders to deliver reliable data solutions.
• Contribute to future data platform modernisation initiatives, including potential Microsoft Fabric adoption.

What We're Looking For

• Strong Microsoft SQL Server Administration: Extensive hands-on experience with installation, configuration, maintenance, patching, production support and end-to-end database ownership.
• Advanced Database Performance Tuning: Proven ability to troubleshoot performance issues using execution plans, indexing strategies, Query Store, DMVs and performance monitoring tools.
• Database Design & Data Warehousing: Strong understanding of Kimball methodologies, star schemas, fact and dimension modelling, with a focus on scalability, security and performance.
• Advanced T-SQL Development: Expertise in developing and optimising complex stored procedures, functions and queries using CTEs, window functions, partitioning and dynamic SQL.
• Database Migration & Modernisation: Experience delivering SQL Server upgrades and migrations, including planning, testing, cutover, risk management and rollback strategies.
• Automation & Monitoring: Hands-on experience with SQL Server Agent, PowerShell, SSIS, proactive monitoring, alerting and database maintenance automation to improve operational efficiency.
• Confident communication skills and the ability to work collaboratively with technical and non-technical stakeholders.

What's on Offer

• $180K–$200K total package including super, depending on experience.
• Permanent, long-term opportunity with ownership of a business-critical data environment.
• Hybrid working arrangement: Monday, Wednesday and Thursday in office, with two days working from home.
• Collaborative environment with direct exposure to senior leadership and stakeholders across the organisation.

If you're a hands-on SQL Server specialist who enjoys database ownership, performance optimisation and delivering reliable data solutions, we'd love to hear from you.

Apply now for a confidential discussion.