Job summary
This post is fixed term/secondment for 6 months.
If you are interested in applying for the secondment position, you must obtain permission from your current line manager prior to applying for this post.
As part of its national work programme, DHCW is introducing ever more sophisticated IT systems to improve patient care, ensuring that they are joined togetherto allow the safe, appropriate sharing of information between clinical systems. This will ensure a patient's medical records are available at the point of need, regardless of where they are held in Wales.
Much of this sharing of information takes place across NHS Wales' Messaging Fabric, a key part of the national infrastructure which currently uses Fiorano. DHCW is beginning an extensive program of migration, modernisation and expansion and we wish to recruit a new developer to join the Integration Team.
Depending on experience we may offer the post as a Band 5 Software Developer. If appointed as a Software Developer, progression to the next pay band is dependent on meeting an agreed set of competency criteria managed through Personal Development Review (PDR). Once those criteria are met you will automatically progress to Band 6.
Main duties of the job
You will be developing and tuning SQL queries of various complexity to create stored procedures, functions and views using specialist tools. You will also maintain and update accompanying documentation.
What skills do you need?
- Understanding of SQL databases; tables and indexes with a strong knowledge of T-SQL.
- Create stored procedures, functions and views
- Familiarity and experience with SQL Server Management Studio 2008 - 2019
- Normalisation techniques and ER-diagramming to design and create scalable, high-performance databases
Familiarity in any of the following areas will also be advantageous:
- Agile methodologies such as SCRUM
- Importing of data from a variety of data sources (e.g. XML, JSON)
- Knowledge of HL7 v 2.x and FHIR messaging standards
- Redgate SQL developer tools
- User Requirements analysis
- Service Broker
- tSQLt - Database Unit Testing for SQL Server
- Creating, and using, Microsoft SQL Server Reporting Services (SSRS) 2008+.
- Creating, and using, Microsoft SQL Server Integration Services (SSIS) packages 2008+
- PowerShell Scripting
- Knowledge of High Availability solutions, such as Mirroring, Replication, Clustering, and Always On (Availability Groups)
About us
Digital Health and Care Wales (DHCW) is part of the NHS Wales family and has an important role in changing the way health and care services are delivered through technology and data. The organisation supports frontline staff with modern systems and access to important information about their patients, while empowering the people of Wales to manage their own health through digital NHS Wales services.
Working for DHCW offers lots of employee benefits, including flexible working, a competitive salary, 28 days of annual leave plus Bank Holidays and opportunities for career development. We are committed to recognising and celebrating our staff as the most valuable part of our organisation.
Join our game changing, life-saving team and start making a real difference to health and care services in Wales.
The ability to speak Welsh is desirable for this post; English and/or Welsh speakers are equally welcome to apply.
Job description
Job responsibilities
This is an exciting opportunity to be involved in our organisation. We'll support you in your training, we love being agile, undertaking research, and other activities that will improve the overall service that we provide. We support each other and work together on common goals, providing opportunities so that people can excel and really enjoy what they do.
In the role you will:
- Work independently to design, document and develop solution based on given requirements.
- Write complex data manipulation statements using T-SQL as stored procedures and functions.
- Mentor junior software developers on development best practices and provide support for their learning and progress.
- Use version control software such as GIT and SVN to manage development work properly
- Attend regular sprint meetings and other project meetings to represent INSE team if required.
- Keep business and technical skills up-to-date by attending training courses and seminars.
You will be able to find a full Job description and Person Specification attached within the supporting documents or please click Apply now to view in Trac.
Job description
Job responsibilities
This is an exciting opportunity to be involved in our organisation. We'll support you in your training, we love being agile, undertaking research, and other activities that will improve the overall service that we provide. We support each other and work together on common goals, providing opportunities so that people can excel and really enjoy what they do.
In the role you will:
- Work independently to design, document and develop solution based on given requirements.
- Write complex data manipulation statements using T-SQL as stored procedures and functions.
- Mentor junior software developers on development best practices and provide support for their learning and progress.
- Use version control software such as GIT and SVN to manage development work properly
- Attend regular sprint meetings and other project meetings to represent INSE team if required.
- Keep business and technical skills up-to-date by attending training courses and seminars.
You will be able to find a full Job description and Person Specification attached within the supporting documents or please click Apply now to view in Trac.
Person Specification
Qualifications and/or Knowledge
Essential
- Bachelor's degree in Software Development or equivalent qualifications, knowledge or experience.
Desirable
- Foundation qualification in an agile development methodology (for example the BCS Foundation Agile).
- Advanced qualification in an agile development methodology (for example the Professional Scrum master).
Experience
Essential
- Proven experience of software development role in a formal development environment.
- Evidence of experience with Windows PC and server operating systems.
Desirable
- Experience developing software for Clinical Information or Healthcare systems.
- Experience of working in an Agile Development environment (e.g. Scrum).
- Good working knowledge of relational database systems and associated database administration activities.
Skills and Attributes
Essential
- Able to learn new technologies and IT systems quickly through both self-study and professional courses.
- Determined, patient and self-motivated.
- Highly professional and flexible attitude to work.
Desirable
- Understands the Data Protection Act and its implications for the holding of patient information NHS Information flows / services.
- Welsh Language Skills are desirable levels 1 to 5 in understanding, speaking, reading, and writing in Welsh.
Person Specification
Qualifications and/or Knowledge
Essential
- Bachelor's degree in Software Development or equivalent qualifications, knowledge or experience.
Desirable
- Foundation qualification in an agile development methodology (for example the BCS Foundation Agile).
- Advanced qualification in an agile development methodology (for example the Professional Scrum master).
Experience
Essential
- Proven experience of software development role in a formal development environment.
- Evidence of experience with Windows PC and server operating systems.
Desirable
- Experience developing software for Clinical Information or Healthcare systems.
- Experience of working in an Agile Development environment (e.g. Scrum).
- Good working knowledge of relational database systems and associated database administration activities.
Skills and Attributes
Essential
- Able to learn new technologies and IT systems quickly through both self-study and professional courses.
- Determined, patient and self-motivated.
- Highly professional and flexible attitude to work.
Desirable
- Understands the Data Protection Act and its implications for the holding of patient information NHS Information flows / services.
- Welsh Language Skills are desirable levels 1 to 5 in understanding, speaking, reading, and writing in Welsh.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
