Address
Where you’ll be working
You will be working with a diverse and dynamic team within the System Performance Support Branch (SPS), System Sustainability and Performance Division based at 1 Reserve Road, St Leonards, NSW 2065. The System Performance Support Branch is leading the technical stream of a program of work to design, test, build and rollout a new Dynamic State Patient Allocation Matrix across the state in both metropolitan and rural areas over a 24-month period. A new Dynamic State Patient Allocation Matrix provides NSW with a unique opportunity to change the way we distribute patients to emergency departments and other appropriate care destinations, via NSW Ambulance.
This exciting opportunity will allow you to work across many areas of the NSW Health system, including the Ministry of Health, NSW Ambulance, Local Health Districts/Specialty Health Networks and other partner agencies, to deliver a transformative change for our patients, carers and staff.
For more information go to www.health.nsw.gov.au
About the Role
The SQL Developer is responsible for the development of key enterprise solutions for NSW Health including and not limited to:
- Dynamic Statewide Ambulance Matrix
- Electronic Recommendation for Admission (eRFA) Portal
- Elective Surgery Demand and Capacity Dashboard
- Patient Flow Portal
- Patient Flow Dashboard
- Community Care Modules
- Clinician Billing Portal
- Revenue Portal
- All other State ODS Program initiatives as commissioned by NSW Health
These applications consume large amounts of real-time data from numerous source systems used by over 25,000 staff from the Local Health Districts, Ministry of Health, Ambulance NSW, Health Share, eHealth, the Pillars and interstate jurisdictions (ACT Health and Network with Victoria).
The SQL Developer will be highly proficient in Microsoft SQL Server, SQL development best practices, database design and development, database performance optimisation and monitoring database server performance.
How to apply
Your application to be considered should include:
- Responses by addressing the selection criteria below.
- An up-to-date resume of no more than five (5) pages which clearly details your skills and experience as relevant to this role.
- 2x referees will need to be supplied prior to an offer being made.
- Application must be lodged electronically. Please go to https://jobs.health.nsw.gov.au/ and search Job Reference Number REQ472388 to submit your application.
Selection Criteria
- Experience (>2 years) working as a Microsoft SQL Server developer.
- Experience (>2 years) with database technologies and highly proficient in the use of SQL AlwaysOn Availability Groups and SQL Enterprise Editions.
- Experience (>2 years) working independently when required as well as in a Team based environment.
- Experience (>2 years) working in both project and production support environments.
- Experience (>1 years) working with source control, GIT and RedGate SQL Source Control.
- Excellent problem solving skills with the ability to complete root cause analysis to identify the cause of issues and implement solutions.
- Excellent verbal and written communication skills with the ability to articulate issues and solutions in a simple manner.
- Relevant educational background including current Microsoft SQL certifications with preference for MCSE Data Management and Analytics, MCSA SQL 2016 Database Development and a Bachelor degree or Diploma in Information Technology (or equivalent).
Need more information?
1) Click here for the Position Description
2) Find out more about applying for this position
For role related queries or questions contact Namita Kumar on ************@health.nsw.gov.au.
Our commitment to Diversity and Inclusion
At the NSW Health we are committed to creating a diverse, inclusive and flexible environment which reflects the community and customers we serve. We actively promote the employment of women, people with a disability, Aboriginal and Torres Strait Islander peoples, LGBTIQ+ community and people from culturally and linguistically diverse backgrounds.
If you identify as Aboriginal or Torres Strait Islander and would like assistance with your application or to obtain more information on how to apply please visit The Stepping Up Initiative.
To be eligible for employment in these roles you must be an Australian citizen, or a permanent resident of Australia, or a New Zealand citizen with a current New Zealand Passport, or hold a valid visa with permission to work in Australia.
COVID-19 Vaccination Compliancy
All NSW Health workers are required to have completed a primary course (2 doses) of a Therapeutic Goods Administration (TGA) approved or recognised COVID-19 vaccine (except for the Janssen COVID-19 vaccine which is approved by the TGA as a single dose primary course). New applicants must have completed the vaccination course prior to commencement with NSW Health, or provide an Australian Immunisation Register (AIR) Immunisation History Statement certifying the worker cannot have any approved COVID-19 vaccines available in NSW.
Acceptable proof of vaccination is the Australian Immunisation Register (AIR) Immunisation History Statement or AIR COVID-19 Digital Certificate. Booster doses are highly recommended for all health care workers who have completed the primary course of COVID-19 vaccinations.
Additional information
- This is a temporary role up to 24 months.
- Please note the selection process will include a range of comparative assessment techniques to assist in determining your suitability for the role.
- If you are Current NSW Health, NSW Ministry of Health and NSW Government staff and are looking for opportunity of Secondment, you must have your manager’s approval prior to expressing interest.
For more information about working at the NSW Health, please visit our career portal.
Applications Close: 10 March 2024 (11:59PM)
