Database Administrator

4 weeks ago


Sheffield, South Yorkshire, United Kingdom Sheffield Teaching Hospitals Full time

We are committed to helping our staff balance their work and home lives and ensure they feel supported, valued and appreciated so whilst you care for our patients and clients, we’ll take care of you. We offer many different ways of helping staff including career development opportunities, flexible working, good annual leave and pension schemes , health and wellbeing packages and financial support systems. Joining the Trust also allows you access to a number of saving options via our salary sacrifice schemes and a wide range of discount opportunities with retailers and service providers.

Job overview

An opportunity has arisen for an experienced Database Administrator (DBA), to join the central Information Services team at Sheffield Teaching Hospitals NHS Trust.

The DBA will be responsible for the maintenance and efficiency of the data warehouse. Therefore, you will need to have

• Practical experience utilising MS SQL Server 2018 upwards.

• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.

• Ability to manage and maintain SSAS, SQL scripts, stored procedures, database agent jobs, Windows scheduled tasks.

• Strong knowledge of index management, integrity checks, configuration. How statistics work, how indexes are stored, how they can be created and managed effectively.

• Working knowledge of database shrink operations, DBCC commands.

• Solid understanding of SQL Server Reporting Services (SSRS).

For more details, please refer to the job specification.

Our service hours are between 8:30 am and 5:00 pm. However, we do offer hybrid working (office/home) and flexible working patterns.

Main duties of the job

The primary responsibilities include -

• Monitoring the performance of the server and identifying bottle necks.

• Identifying long running processes and inefficient queries

• Identifying and creating missing indexes

• Identifying and removing unused indexes

• Identifying and removing unused data items

• Building new tables

Working for our organisation

You will be working for an organisation which values and respects all of its staff and the community it serves. The Trust is a leader in the NHS and research sectors and provides excellent benefits for its staff. This includes commitments to professional development but also many policies to support employees in balancing their personal and professional lives.

The Information Service’s role is to -

• Provide information to support the business planning, negotiation and monitoring of the legally binding contract for the Trust.

• Provide information support to the clinical coding service to ensure that the activity undertaken by the Trust is coded completely and accurately to ensure that the Trust secures the income that properly reflects its case mix complexity.

• Provides the necessary high-quality data, information and analysis to enable performance management of the Trust at a local, regional and national level.

• Provides a central resource/support for Clinical Staff/Operational Directors/Deputy Operational Directors/Service Managers/TEG.

• Maintain and manage the cost per case database to ensure the recovery of income.

• Ensures that the Trust complies with the data quality aspects of the Information Governance requirements.

• Detailed job description and main responsibilities

When completing your application please ensure that you clearly demonstrate how you meet the role criteria.

Person specification

Qualifications

Essential criteria

• Educated to Masters Degree level, or significant relevant practical experience as a Database Administrator utilising MS SQL Server

Desirable criteria

• Microsoft SQL Server certification

Experience

Essential criteria

• Strong experience in Database Administration from SQL Server 2018 upwards

• Experience in communications and stakeholder management

• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.

• Experience in Performance Tuning, and Query Optimization including strong knowledge of query plans.

• Expert experience in implementing operational automation

• Manage and maintain SSAS, SQL scripts, stored procedures, database agent jobs, Windows scheduled tasks.

• Experience of working with third party suppliers.

Desirable criteria

• Experience in the Acute Sector

• Previous experience in project management and planning

Knowledge

Essential criteria

• Strong knowledge of indexes, index management, integrity checks, configuration. How statistics work, how indexes are stored, how they can be created and managed effectively.

• Working knowledge of database shrink operations, DBCC commands.

• Solid understanding of SQL Server Reporting Services (SSRS).

Desirable criteria

• A good understanding of the health and social care environment and roles and responsibilities within it

SKills

Essential criteria

• Ability to work alongside IT services to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

• SQL Development - ability to write and troubleshoot SQL Code and design (Stored procs, functions, tables, views, triggers, indexes, constraints).

• Ability to gather, analyse, interpret and report on information and knowledge, related to ideas and concepts in relation to database administration to influence key decisions.

• Develop others knowledge & practice in area of work

• Ability to influence IT and lead others in the development of knowledge, ideas and work practice relating to database technologies.

• Ability to establish and maintain peer review SQL scripts to identify performance issues and rectify or provide support and guidance.

• Ability to configure ODBC links to other data sources.

Other Factors

Essential criteria

• A clear understanding of the Trust PROUD Values.

• Ability to work under pressure and to tight deadlines.

• Proactive and personally motivated

• Excellent team player, positive attitude, tenacious, co-operative, flexible, hard working. Shows initiative. Professional attitude.

• Accurate with attention to detail.

• Commitment to continuing professional development.

• Communicates with individuals and groups about difficult or highly complex matters at all levels and both technical and non-technical audiences



  • Sheffield, South Yorkshire, United Kingdom Sheffield Teaching Hospitals Full time

    We are committed to helping our staff balance their work and home lives and ensure they feel supported, valued and appreciated so whilst you care for our patients and clients, we’ll take care of you. We offer many different ways of helping staff including career development opportunities, flexible working, good annual leave and pension schemes , health and...


  • Sheffield, UK, South Yorkshire, United Kingdom Response Full time

    One of the UK’s largest and foremost law firms is currently looking to recruit a skilled and highly organised Conveyancing Administrator. This is an entry level role and a great pathway into the Residential Conveyancing team,experience in conveyancing is welcome but not essential as full training will be provided. Strong organisational skills and attention...


  • Sheffield, United Kingdom Auxilion Ireland Full time

    Sheffield, Hybrid or remotePrevious commercial SQL DBA experience. (5 yrs. minimum) Expert knowledge of Microsoft SQL Server Database Administration and Support for organisation wide, business critical relational databases of multiple customers of SOC. Previous commercial SQL DBA experience. (5 yrs. minimum) The role of the Database Administrator is to be...


  • Sheffield, Sheffield, United Kingdom NHS Full time

    Database Administrator (Senior Technical Role)An exciting opportunity has arisen for an experienced Database Administrator to join the central Information Services team at Sheffield Teaching Hospitals NHS Foundation Trust.The successful candidate will be responsible for the maintenance and efficiency of the data warehouse, requiring practical experience with...


  • Sheffield, Sheffield, United Kingdom NHS Full time

    Main ResponsibilitiesThe successful candidate will be responsible for the maintenance and efficiency of the data warehouse at Sheffield Teaching Hospitals NHS Foundation Trust.The Database Administrator (Senior) will be responsible for:Monitoring the performance of the server and identifying bottlenecks.Identifying long running processes and inefficient...


  • Sheffield, United Kingdom Sopra Banking Software Full time

    Company details Sopra Banking Software works with more than 1,500 banks, building societies and specialized finance providers across more than 80 countries worldwide. We help them to develop, deliver and operationalise their digital transformation strategies. Using our suite of digital banking products and services enables these organisations to deliver...


  • Sheffield, United Kingdom Sheffield Teaching Hospitals Full time

    About the Role:We are seeking an experienced Database Systems Specialist to join our team at Sheffield Teaching Hospitals. As a key member of our Information Services team, you will be responsible for the maintenance and efficiency of our data warehouse. Your primary focus will be on ensuring the smooth operation of our SQL Server environment, including...

  • Administrator

    4 weeks ago


    Sheffield, Sheffield, United Kingdom Humankind Full time

    About the Role:As an Administrator at Humankind, you will play a vital role in ensuring the smooth and efficient operation of our service on a day-to-day basis. Your responsibilities will include providing administrative support to the clinical team, managing databases and software, and serving as the welcoming face of our service as a receptionist.About...


  • Sheffield, United Kingdom Bruin Full time

    Due to new client wins, a leading Pension Consultancy are looking for a strong Pension Administrator to join their team. The Pension Administrator will be tasked with delivering a professional and efficient administration service to members of the pension schemes and also processing member benefits accurately and within target timescales to provide an...

  • Administrator

    6 months ago


    Sheffield, United Kingdom The Porterbrook Care Home Full time

    The Portebrook Care Home is looking for an Administrator with great organisational, inter-personal and first point of contact skills. Situated in a quiet area in the suburb of Crosspool in Sheffield, we provide residential and dementia care for up to 44 residents. Each day will offer plenty of variety and great administration skills are a pre-requisite for...

  • Sales Administrator

    6 months ago


    Sheffield, United Kingdom AIM Smarter Limited Full time

    We are a leading provider of services and tools in the promotional products industry. With operations in the UK and USA we have over £2 billion in sales volume, we are the largest organisation of independent, experienced, and qualified promotional product distributors in the industry. Our company is built on integrity, innovation, and social conscience, and...

  • Administrator

    5 months ago


    Sheffield, United Kingdom The Porterbrook Care Home Full time

    The Porterbrook Care Home is looking for an Administrator with great organisational, inter-personal and first point of contact skills. Situated in a quiet area in the suburb of Crosspool in Sheffield, we provide residential and dementia care for up to 44 residents. Every day will offer plenty of variety and great administration skills are a pre-requisite...


  • Sheffield, United Kingdom Sheffield Health and Social Care NHS Foundation Trust Full time

    To work with the Medical Staffing Co-ordinator to co-ordinate and administrate the placements of trainee doctors throughout their training placements Provide basic advice and guidance on medical staffing related matters for all trainee medical staff in the To co-ordinate rotations and inductions of trainee doctors ensuring essential administration is...

  • Administrator

    6 months ago


    Sheffield, United Kingdom Travail Employment Group Ltd Full time

    £11.50ph, Monday - Friday, early Friday finish, Temp to perm, Weekly pay, 28 days holiday, Free parking, Sheffield, Immediate start, excellent benefits if role is made permanent. Due to an increase in demand and continued success, a fantastic opportunity has arisen for an experienced Administrator to join a world-renowned business, with very high staff...

  • Administrator

    6 months ago


    Sheffield, United Kingdom TREK GROUP LIMITED Full time

    **Previous applicants need not apply.** Equi-Trek are the leading manufacturers of equestrian and leisure vehicles, supplying to the UK and overseas, based in Stocksbridge, S36. A vacancy has arisen for an **Administrator** to work within our busy Service & Repair team. **Key Job Requirements**: - Supporting the team with a range of administrative...

  • Administrator

    6 months ago


    Sheffield, United Kingdom TREK GROUP LIMITED Full time

    Equi-Trek are the leading manufacturers of equestrian and leisure vehicles, supplying to the UK and overseas, based in Stocksbridge, S36. A vacancy has arisen for an **Administrator** to work within our busy Service & Repair team. **Key Job Requirements**: - Supporting the team with a range of administrative tasks; - Maintain databases and other relevant...

  • Administrator

    6 months ago


    Sheffield, United Kingdom TREK GROUP LIMITED Full time

    Equi-Trek are the leading manufacturers of equestrian and leisure vehicles, supplying to the UK and overseas, based in Stocksbridge, S36. A vacancy has arisen for an **Administrator** to work within our busy Service & Repair team. **Key Job Requirements**: - Supporting the team with a range of administrative tasks; - Maintain databases and other relevant...

  • Administrator

    5 months ago


    Sheffield, United Kingdom Gap Trading Full time

    We are seeking a motivated and detail-oriented individual to join our team as an entry-level Administrator. As an Administrator, you will play a vital role by providing administrative support, handling data entry tasks, and delivering excellent customer service. This position is ideal for someone who possesses strong Excel skills, has a keen eye for...


  • Sheffield, Sheffield, United Kingdom Lift Schools Full time

    About the RoleFirth Park Academy is seeking an experienced administrative assistant to join our school admin team. The ideal candidate will be highly organized, proactive, and possess excellent communication skills.Key ResponsibilitiesAssist the school administration team with daily tasks and duties.Manage and maintain accurate records and databases.Provide...


  • Sheffield, Sheffield, United Kingdom Getting In Limited Full time

    We are looking for a highly organized and efficient individual to fill the role of Office Administration Apprentice. As an apprentice, you will gain valuable experience in various aspects of office administration, including typing, document creation, and data entry.Key ResponsibilitiesMaintaining accurate records and databasesProviding general clerical...


  • Sheffield, Sheffield, United Kingdom Hays Specialist Recruitment Limited Full time

    About this roleThis is an exciting opportunity to support a busy HR team in Sheffield with temporary recruitment administration duties. You will report to the HR/People Advisor and provide administrative support with recruitment activities, including posting advertisements, arranging interviews, and assisting with new starter onboarding. Key...

  • Administrator

    6 months ago


    Sheffield, United Kingdom Templegate Full time

    **TEMPLEGATE RECRUITMENT** **Financial Services Specialist Recruiters** **Job Title**: Administrator **Location**:Barnsley **Salary**: £15,000 - £20,000 Deepening on experience 3 - 4 days a week **About the Company**: Our Client is a well-established small IFA practice who offers advice in investments and Pension management, They are now looking for an...