Vacancy -- Senior SQL Developer

Working for the Civil Service

The Welsh Government's recruitment processes are underpinned by the principle of selection for appointment on merit on the basis of fair and open competition as outlined in the Civil Service Commission’s Recruitment Principles.

The Civil Service Code sets out the standards of behaviour expected of civil servants.

Vacancy Details

Education, Social Justice and Welsh Language Group
Digital Solutions Team
SEO - £41,700 - £49,370
£40,100 - A starting salary of up to £44,200 can be offered for exceptional candidates based on their skills and experience. This is in no way guaranteed and remains at the discretion of Welsh Government.
Full time (applications are welcome from people who work part time, as part of a job share or who work full time)
Other location
National - fully remote working available

Purpose of Post:


The Welsh Government is the devolved government for Wales with an annual budget of around £15 billion. It is responsible for key aspects of public life in Wales including health, education, the economy, transport, agriculture and the environment.

Welsh Ministers are supported by a workforce of more than 5,000 civil servants with offices in Wales, London, Brussels and overseas.

Welsh Government priorities are outlined in Taking Wales Forward with an overall ambition to build a Wales which is self-confident, prosperous, healthy nation and a society which is fair to all. The Welsh Government has also set out clear priorities for Wales following the UK’s exit from the European Union.

The Welsh Government is looking to attract people who can provide excellent support and advice, can focus resources and have energy and expertise.  The Well Being and Future Generations Act provides context for our work. 

Digital transformation of public services is vital to delivering the services the people of Wales expect and need. Welsh Government currently delivers a number of digital services to people and business across Wales. We also provide information on our websites. 

Led by our Chief Digital Officer, the Welsh Government is increasingly delivering more services online. The Chief Digital Officer provides a consultancy service of digital and data expertise across Welsh Government.

SHELL are responsible for overseeing higher education, further education and the wider post-16 education, training and skills sector in Wales along with the funding of approved vocational qualifications and  the development of employability policy.  They are also responsible for leading the contribution that the post-16 education and training system makes to developing highly educated and skilled people who are able to gain and retain high quality jobs that pay well and make a contribution to the wider Welsh economy and society.


The Role

As a Senior SQL Developer you will participate as a member of an internal software development team to provide expert development and maintenance for in-house supported applications, databases, packages and reports.

Primary focus will be on SQL development (both Transact-SQL and SSIS packages), data analysis, reporting (SSRS), database development and testing.

You will be expected to transform technical requirements into effective solutions to enable product delivery. You must provide support to delivery teams and assist with solving complex problems.

You will be knowledgeable with all aspects of the agile delivery lifecycle to ensure a continuous provision of services are delivered.

Key tasks:

  • Apply technical knowledge to design, create, test and document new and amended programs from supplied specification in accordance with agreed standards.
  • Manage the design, delivery and support management information functions, including design, development and customisation of complex bespoke reports using multiple data sources.
  • Undertake analysis of business requirements to inform impact assessments, use cases, test scenarios, and use agile methodologies to maintain a strong focus on delivery priorities and swiftly respond to changing requirements.
  • Undertake 1st (where requirements cannot be delivered by service desk) and 2nd line support of critical applications, services, and platforms on issues as they arise within the agreed SLA’s or in conjunction with commercial partners.
  • Provide technical input for the more complex application development activities such as database performance improvement, tuning SQL queries and indexing strategies; and propose technical development protocols and standards
  • Work with stakeholders to identify and manage the adoption of best practice to deliver business change and continuous improvement initiatives in accordance with organisational standards and policies
  • Manage and undertake the unit testing of the application release cycle. Manage the testing lifecycle, in conjunction with partner organisations and policy teams, to ensure developments meet business need
  • Ensure all strands of non-functional requirements e.g. information assurance; web standards are complaint within the system.
  • Apply expert technical knowledge and contribute to the development and continual enhancement of applications, services, procedures and process, including generating and maintaining documentation.
  • Advise senior management and provide support to the Lead Developer around activities such as technical support, stakeholder engagement, delivery of continuous improvements and projects.

Development opportunities:

Your role will form part of Welsh Government’s Digital, Data and Technology (DDaT) profession.  This is a growing profession and you will have the opportunity to be part of shaping and growing it.

We are committed to developing the skills and capability of our staff and encouraging them to use five days of learning a year.  To support this we offer a range of opportunities which could include:

  • Shadowing
  • Mentoring
  • Work based learning
  • Qualifications
  • Coaching
  • Short Term Experience Programme (STEP)

Proactively making links and working with a wide range of Welsh Government teams and external partners including other Governments in the UK. 

Closing Date:

06/01/2023, 16:00


Posts recruited to as part of this recruitment campaign are broadly open to UK nationals, those with right to remain and work in the UK and those that meet the Civil Service Nationality Rules only. Check your eligibility here:

Prior to appointment, all successful applicants will be required to produce original, acceptable documents as part of the pre-employment checks. If it becomes apparent at a later stage in the process that you aren’t eligible to apply, your application will be withdrawn, or offer retracted.

Equality and Diversity

The Welsh Government is committed to providing services which embrace diversity and which promote equality of opportunity. This is underpinned by the Equality Act 2010 and will be adhered to at each stage of the recruitment process. Our goal is to ensure that these commitments are also embedded in our day-to-day working practices with all our customers, colleagues and partners.

We are committed to being an anti-racist organisation and increasing diversity in the Welsh Government by removing barriers and supporting all our staff to reach their potential. We are committed to recruiting Black, Asian and Minority Ethnic people and disabled people who are currently under-represented in Welsh Government.

We welcome applications from everyone regardless of age, marriage and civil partnership (both same sex and opposite sex), impairment or health condition, sex, sexual orientation, pregnancy and maternity, race, religion or belief, gender identity or gender expression.

We are a Stonewall Diversity Champion and a Disability Confident Level 3 (Leader) organisation. Key to supporting this work and providing peer support are five Board sponsored Staff Networks (Disability Awareness and Support (DAAS); Minority Ethnic Support Network (MESN); Mind Matters (Mental health and well-being); PRISM (Lesbian, Gay, Bisexual, Transgender, Intersex +) and Women Together.

Disability Confident

A Great Place to Work for Veterans

This vacancy is part of the Great Place to Work for Veterans initiative.

Welsh Language Requirements

The Welsh Government is a bilingual organisation and Welsh language skills are considered an asset to the organisation. We encourage and support staff to learn, develop and use their Welsh language skills in the workplace. 

The following list of language requirements represents an objective assessment by the line manager on behalf of the Welsh Government of the Welsh language skills required to undertake the duties of this particular post.

Not necessary to undertake the duties of this post

Social Partnership

In Welsh Government, the relationship between the employer and trade unions is based on social partnership. We believe our goals can best be achieved by management and trade unions working together.

Our 3 recognised trade unions are:
•         PCS
•         Prospect
•         FDA

This relationship is underpinned by a partnership agreement. This sets out how our unions work with Welsh Government on issues such as:
•         pay
•         terms and conditions
•         policies and procedures
•         organisational change.

Our Welsh Government trade union colleagues work together to give their members a real say in the workplace. They make sure that the interests of their members are promoted and protected. They also help reduce inequalities and improve terms and conditions.

The Welsh Government has an excellent track record of working in partnership with its trade unions. We encourage staff to get involved. We support you to join a recognised trade union, to ensure your voice is heard in the workplace. and to learn more about trade unions and partnership working.

Competencies / Job Specific Criteria

The following technical skills are ESSENTIAL for success in this role.  Please ensure you attach a CV, no longer than 2 sides of A4, which demonstrates your ability in relation to these skills.

  • Microsoft SQL Server 2016 onwards (management, configuration, encryption, backups, jobs etc.)
  • Developing complex Transact-SQL including Stored Procedures, Views & Functions
  • Database design and administration
  • SQL Server Reporting Services (SSRS) / SQL Server Integration Services (SSIS)
  • Source Control (eg. GIT)
  • Experience with development IDE’s such as Visual Studio.NET (SQL Server Data Tools) and SQL Server Management Studio.
  • Experience working with an Agile framework such as SCRUM
  • Experience working and releasing in multiple environments (Dev, PreProd, Prod)

Assessment Process

Throughout the entire assessment process, candidates will be assessed against Behaviours from the Civil Service Success Profiles and the Digital Data and Technology DDaT Capability Framework. Please ignore any references you might see relating to competencies within our application system. The behaviours which will be assessed through this process are:

  • Communicating and Influencing
  • Making Effective Decisions
  • Changing and Improving
  • Bridging the gap between technical and non-technical
  • Making and guiding decisions
  • Turning business problems into technical design
  • Understanding the whole context


Your application will be assessed in two stages:

  1. An initial sift will be carried out against your CV and the essential job specific skills. As part of your application you will be asked to upload a copy of your CV. This should be no more than 2 sides of A4. Anything above 2 sides of A4 will be discounted and will not be considered as part of the sift. Please remove from your CV your name and address to support us in undertaking a “name free” sift.
  2. Candidates who have passed the initial sift will be invited to participate in a Technical Exercise and an interview.

Further information about these stages will be provided following the sift stage.

Other Information

  • Unless stated otherwise in ‘actual starting salary’, all candidates will start at the minimum of the pay scale being appointed to (this includes existing civil servants).This is not negotiable.
  • Unless stated otherwise in ‘type of opportunity’, this recruitment advert is not open on a Loan or Secondment basis.
  • For more information on the eligibility criteria and terms and conditions for Loan and Secondment positions in Welsh Government, please see external recruitment candidate guidance.
  • Unless stated otherwise in ‘Location of Post’ the role/s recruited to via this campaign can only be worked in the UK, not overseas.

The Welsh Government offers a variety of employee benefits, including:

  • Support for improving or gaining Welsh language skills for all employees
  • Frequent development discussions and the training you need for your role and to grow
  • Annual pay increments, allowing you to progress to the top of your pay scale within 3-4 years
  • 31 days annual leave, (plus 10 public and privilege holidays)
  • Generous parental leave, including 26 weeks at full pay for qualifying employees
  • Generous pension scheme with employer contributions
  • Childcare Vouchers Scheme, saving up to £933/year
  • Cycle to Work Scheme: choose a brand new bike up to £2000, saving at least 32%
  • Advances of Salary: request advances for Christmas, computer equipment or Tenancy Deposits
  • Season Ticket Loans
  • Flexitime policy
  • The latest ICT kit
  • Death in service cover
  • Green Car Scheme

Reserve List

Unsuccessful candidates who have achieved the minimum score across the assessment, will have the opportunity to be held on a WG ‘reserve’ list for 12 months from the date of the outcomes being issued.  If additional roles become available or existing roles become vacant during this time, WG may offer the role to the highest scoring candidate on the reserve list.  If they decline, WG may offer the role to the next highest scoring candidate and so on.

Disability Confident

Welsh Government accepts the social definition of disability, in which it is recognised that barriers in society act to disable people who have impairments or health conditions or who use British Sign Language. We are committed to removing barriers so that all (or potential new staff) can perform at their best. The Equality Act 2010 uses the medical definition of disability (“a physical or mental impairment which has a substantial and long-term impact on a person’s ability to carry out normal day to day activities”).

We guarantee to interview anyone who is disabled whose application meets the minimum criteria for the post. By ‘minimum criteria’ we mean that you must provide us with evidence in your application which demonstrates that you generally meet the level of competence for the role and any qualifications, skills or experience defined as essential. We are committed to the employment and career development of disabled people.

If you have an impairment or health condition, or use British Sign Language and need to discuss reasonable adjustments for any part of this recruitment process, or wish to discuss how we will support you if you were to be successful, please email as soon as possible and a member of the team will contact you to discuss your requirements and any questions you may have.

Welsh Language Requirements

The Welsh Government is a bilingual organisation and Welsh language skills are considered an asset to the organisation. We encourage and support staff to learn, develop and use their Welsh language skills in the workplace. 

Welsh language skills are Desirable in this role as part of growing our culture of bilingualism with Welsh Government – we also believe that technology forms an important pillar in achieving our goal of a million Welsh speakers by 2050. If you would like to improve your Welsh language skills we can offer a supportive and friendly culture to develop them in, backed by opportunities for learners at all levels to learn either alone or with colleagues in informal groups.

Please note this is not an essential requirement for this role and you will not be expected to demonstrate this at assessment.


If you are already employed within the public sector, a secondment from your existing employer can be considered.

Candidates who wish to secure a secondment through this opportunity will move laterally, as such they would be able to remain on the same pay they receive from their employer. It is only in exceptional cases, e.g. where a secondment opportunity would equate to a temporary promotion in terms of pay, that there may be flexibility.

In this situation Welsh Government may be prepared for the Secondee to be paid at the minimum of the Pay Band for the Grade being appointed to, however, the Secondee’s employer would need to be in agreement with the terms of the appointment and the temporary increase in their employees pay for the period of the secondment.


Our Commitment to Equality

Due to current under-representation in the organisation, candidates who declare that they are disabled or from a black or minority ethnic (BAME) background will automatically be put forward to the Assessment Gateway if their application meets the minimum criteria. We can only do this if candidates provide this information in their application. Information on BAME candidates will be taken from the equality monitoring form and it is important that you complete this as part of your application.


Recruitment Adjustments

Welsh Government is committed to the social model of disability and to making reasonable adjustments to remove any barriers in the recruitment process for staff with impairments, health conditions or who use British Sign Language.  We can make adjustments to any part of the recruitment process (the application as well as the assessment centre) and we will ensure that disabled candidates are matched to roles which are compatible with workplace adjustments. We can provide advice to staff who think they do or might need reasonable adjustments but who need to know more about the assessment process and what sort of adjustments we could make to ensure fair assessment. 

If you know you need (or think you might need) any type of reasonable adjustment in order to make an application, please contact the recruiting team via as soon as possible to discuss any required adjustments.

Following the closing date for applications we will contact all candidates with details of how disabled candidates can request and have agreed any adjustments that they may need for the assessment event. This will include the opportunity for 1-1 advice sessions for candidates who are unsure whether or what reasonable adjustments they could or should ask for in order to ensure that they can perform to their best.

In the meantime, disabled candidates may wish to refer to Annex A of the Candidate Guidance (link) for our new Recruitment Adjustments Form which we are piloting. 

Contact point for further information

Mark Hodson - - 07971 765932

How to apply

All applications for this vacancy should be made online via the Welsh Government's online application system.  If you have an impairment which would prevent you from applying on-line, please e-mail to request an application pack in an alternative format, or to request a reasonable adjustment related to an impairment in order to submit your application.

To apply, you'll need to have an account on our online application system.  Click the 'Apply' button below, and you'll be asked to 'Log in' if you already have an account, or 'Register' if you don't yet have an account.  Registration takes just a few minutes to complete.  You'll need an e-mail address to be able to register.  Once you've registered for an account and logged in, you'll be taken to the online application form, which you'll need to fully complete and submit before the deadline on the closing date.  

If you’d like to apply for this vacancy in Welsh, please use the ‘Newid Iaith / Change Language’ link at the top of this page, to take you to the Welsh version of this advert, from which you can apply in Welsh.

For further information regarding the Welsh Government recruitment process, please see the Recruitment Guidance for External Candidates (link).

When evidencing your suitability for the post, it is recommended that you refer to the Civil Service Competency Framework (link)

Grievance and Complaints

Anyone who believes they have been treated unfairly, or has a grievance or complaint, about how the process was conducted should either write to the Head of Resourcing, Welsh Government, Cathays Park 2, Cardiff CF10 3NQ or email  If you are unhappy with the outcome of the complaint raised with the Welsh Government and feel that the principles of appointment on merit through fair and open competition have not been met you have the right to pursue your grievance with the Civil Service Commission.

This vacancy is closed to applications.