East Midlands Ambulance Service NHS Trust

SQL DBA Apprentice

Information:

This job is now closed

Job summary

Job Purpose:

  1. The post-holder will be providing assistance for all areas of the SQL Server estate including ongoing improvement of the existing databases, identifying processing bottlenecks and implementing performance tuning where appropriate, migration from unsupported to supported platforms.
  2. You will also be required to assist in the design and development of replacement databases, promoting a data integration and data warehousing/data lake approach to the Trust's key reporting systems, utilizing industry standard technologies and methodologies.
  3. The role will also require the assistance in creation of SQL databases, SQL coded procedures, DTS and SSIS packages, reporting services and analysis service to provide reporting functionality.

please see job spec for more information

Main duties of the job

Ensuring SQL Server instances are performing, secure, actively managed and monitored. Assist in PowerBI and data cubes. Support wider team members with technical expertise in coding and data location.

To assist the formulation and implementation of policies internal to the department, relating to the support and maintenance of SQL / Azure / Power Bi database and applications.

To assist in all configurations issues relating to SQL / Azure / Power Bi and database options including access, logging, collation, paging and indexing.

This is an apprenticeship and the successful candidate will be provided with level 4 Data Analyst training and are expected to complete course .

please see job spec for more information

About us

Working Conditions

There is a requirement to use a personal computer more or less continuously on most days. Travel around the Trust (East Midlands) may be required occasionally.

  1. The duties and responsibilities of the post will be undertaken in accordance with the policies, procedures and practices of the Trust, which may be amended from time to time.
  2. Patient Safety is a key priority for the Trust. It is your responsibility to ensure that you are fully compliant with EMAS policies and procedures in respect of patient safety, for example Risk Management, Infection Prevention and Control, Safeguarding children and vulnerable adults.
  3. This job description is not intended to be an exhaustive list of duties and responsibilities, but to give an indication of the main areas of activity and involvement.

Details

Date posted

26 August 2022

Pay scheme

Agenda for change

Band

Band 5

Salary

£24,907 to £30,615 a year 24,907 starting with apprenticeship .

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

335-A-0778

Job locations

Home address

anywhere

NG8 6PY


Job description

Job responsibilities

you will also be required tosuccessfully complete the level 4 data analyst apprenticeship

The entry requirements for this programme are as follows

Standard entry:

Level 3 qualification. (Apprenticeship / A level / BTEC etc

Or 2 years work experience in a relevant role

Programme details can be emailed on request.

Job description

Job responsibilities

you will also be required tosuccessfully complete the level 4 data analyst apprenticeship

The entry requirements for this programme are as follows

Standard entry:

Level 3 qualification. (Apprenticeship / A level / BTEC etc

Or 2 years work experience in a relevant role

Programme details can be emailed on request.

Person Specification

SQL and database knowledge

Essential

  • SQL knowledge
  • Database knowledge
Person Specification

SQL and database knowledge

Essential

  • SQL knowledge
  • Database knowledge

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.

Certificate of Sponsorship

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.

Certificate of Sponsorship

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).

Employer details

Employer name

East Midlands Ambulance Service NHS Trust

Address

Home address

anywhere

NG8 6PY


Employer's website

https://www.emas.nhs.uk/ (Opens in a new tab)

Employer details

Employer name

East Midlands Ambulance Service NHS Trust

Address

Home address

anywhere

NG8 6PY


Employer's website

https://www.emas.nhs.uk/ (Opens in a new tab)

Employer contact details

For questions about the job, contact:

Information Manager

Martin Sheehan

martin.sheehan@emas.nhs.uk

07949420092

Details

Date posted

26 August 2022

Pay scheme

Agenda for change

Band

Band 5

Salary

£24,907 to £30,615 a year 24,907 starting with apprenticeship .

Contract

Permanent

Working pattern

Full-time, Flexible working, Home or remote working

Reference number

335-A-0778

Job locations

Home address

anywhere

NG8 6PY


Supporting documents

Privacy notice

East Midlands Ambulance Service NHS Trust's privacy notice (opens in a new tab)