About the role
Reporting to the GP Training Development Manager, as a Senior DataBase Developer, you’ll be a key contributor to delivering high-quality, scalable database solutions aligned with the RACGP business needs. You’ll collaborate across teams, contributing to architectural decisions and driving continuous improvement.

As our Senior DataBase Developer, you'll also:

• Analyse, design, and optimise complex stored procedures and database coding to improve performance, scalability, and maintainability within an Azure SQL Managed Instance environment.
• Lead initiatives to improve existing table structures and refactor legacy database components based on best practices and performance benchmarks.
• Monitor and troubleshoot high CPU consumption and database performance issues, recommending and implementing solutions such as indexing, partitioning, and query optimisation.
• Leverage Azure Application Insights to monitor application and database behaviour, trace performance bottlenecks, diagnose errors, and correlate telemetry with backend operations.
• Collaborate closely with application developers, solution architects, and business analysts to evaluate data requirements and translate them into stable and scalable database solutions.
• Maintain and manage version control of all database artifacts (schemas, stored procedures, scripts) using Azure DevOps.
• Design and maintain relational data models supporting approximately 400+ custom tables and 1,500+ stored procedures.

Skills & Experience

• Proven experience developing, tuning, and maintaining large-scale relational databases on Azure SQL Managed Instance or Microsoft SQL Server.
• Strong hands-on experience with T-SQL, including performance tuning of stored procedures, query plans, indexing strategies, and transaction management.
• Well-versed in using SQL Profiler and Windows Performance Monitor for identifying performance issues and optimising database performance.
• Hands-on experience interpreting SQL Server execution plans, SQL Server logs, and Windows event logs for root cause analysis and system diagnostics.
• Demonstrated ability to refactor poorly performing stored procedures and normalise data schemas within legacy environments.
• Experience with Azure Application Insights for diagnosing performance issues, tracking queries, and monitoring backend service health.

Benefits of working with us

• Maximise Your Pay: RACGP employees are eligible to access up to $15,900 tax-free for living expenses, plus additional salary packaging options (meals, entertainment, novated leases) thanks to our health promotion charity status and 17.5% Annual Leave loading
• Extra Paid Leave: End of year closure leave and additional special paid leave such as Aboriginal, Community, Cultural and Ceremonial leave, Gender Transition leave and Volunteer Leave
• Work-Life Balance: Enjoy flexible hybrid work opportunities nationally
• Career Growth: Access a contemporary Professional Development Program
• Join a Leader: Be a part of Australia’s largest specialist medical college that stands at the forefront of our world-class healthcare system

About the RACGP
The Royal Australian College of General Practitioners (RACGP) represents GPs across urban and rural Australia, supporting the nation’s health system for over 60 years by setting educational and practice standards and advocating for improved health and wellbeing. We promote the future of general practice through community-based training models, including the Australian General Practice Training Program, ensuring GPs are equipped to deliver quality, whole-person care and facilitating ongoing professional development while connecting GPs with communities nationwide.

How To Apply?
We encourage interested applicants to apply asap as applications will be considered and interviews conducted as suitable candidates apply. Click the ‘Apply’ button and submit your CV and cover letter as one document.

We respectfully will not be accepting any applications from recruitment agencies for this role.

Applicants must have the right to work in Australia.

Applications Close: 11.59PM Sunday June 29, 2025

We value diversity and encourage applications from Aboriginal and Torres Strait Islander people, those with disabilities, and individuals from diverse backgrounds. If you need support or adjustments during the recruitment process, please mention it in your application.

We are a Circle Back Initiative Employer – we commit to respond to every applicant.

The RACGP acknowledges the Traditional Custodians of the land and waterways in which we work and live. We recognise their continuing connection to land, water and culture, and pay our respects to Elders, past, present and emerging.

#LI-Remote