Senior Database Administrator (Senior Data Engineer) West Midlands
Job description
Details
Reference number
Salary
Job grade
Contract type
Business area
Type of role
Information Technology
Working pattern
Number of jobs available
Contents
Location
About the job
Benefits
Things you need to know
Apply and further information
Location
About the job
Job summary
Diverse perspectives and experiences are critical to our success and we welcome applications from all people from all backgrounds with the experience and skills needed to perform this role. We look forward to receiving your application
The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.
Keeping people safe and healthy matters and that’s what we do at the Health and Safety Executive. Every day, everyone on the team contributes to protecting lives and we apply our expertise to help influence change in mindsets about health and safety throughout industry. We undertake world-class science to build our knowledge about safe working practices, and then apply that understanding to the workplace, guiding every part of the economy to function safely. And when accidents happen, we investigate and hold those at fault to account whilst ensuring that lessons are learnt across industries. We are a modern, independent, data drive Regulator and we are proud to have made Great Britain one of the safest places to work in the world.
Technology, data, and digital services underpins everything that HSE does. We are a knowledge organisation, with a wealth of experience in keeping people safe. It is the responsibility of the Information, Technology and Facilities Division to ensure that everyone in the organisation can access our data and information, to share it and to use it to make effective decisions. We support over 3000 colleagues working in a hybrid style at home and in 26 offices across Great Britain. Our services keep inspectors functioning effectively and efficiently on industrial sites nationwide, from oil platforms in the North Sea to our deepest mines and quarries.
We strive to constantly improve the technologies and services supporting the organisation. Our end user computing devices are leading edge, and we are making significant progress in delivering new cloud-based services. Our service management and information management services are very highly regarded within the organisation and pride themselves on excellent customer service. Our commercial team has built strong relationships with suppliers and our project management team is embedded in our corporate change programme, transforming the older legacy systems that have underpinned the organisation for a long time.
We are a learning team, and everyone is encouraged to undertake training, development and courses that will keep them and the team current and excited by new opportunities. The team works well because everyone’s contributions and ideas are listened to and valued, and we can only grow and improve if there is an enthusiasm to explore our disciplines and try new ways of working.
Job description
You will manage the HSE’s data estate, ensuring that data remains confidential, integral, available (CIA), and relevant to business requirements. Monitoring all data flows and the use/re-use of data across the organisation to ensure that systems, business analytics and business intelligence are appropriately supported.
You will ensure databases remain secure, preventing unauthorised access, data exchange and data loss, and seek to improve all current system databases. Resolving database issues before they impact the user/customer, identifying root causes, developing work arounds and fixes in priority order to ensure databases and applications remain operational, at N or N-1 states, and performant to SLAs/OLAs, implementing upgrades and patches to databases, coordinating change activity, engaging with users, and ensuring that upgrades are understood and appropriate. You will document all databases, data interfaces and data flow diagrams, maintaining the accuracy of documentation to reflect changes and fixes, ensuring data quality is high.
This role will engage with users, supporting their needs and ensuring that a high-quality customer focused service is delivered. Your day-to-day duties will include (but are not limited to):
- Deputising for the Lead Application Operations Engineer
- Supporting the Data Architect in designing and implementing a Data Strategy and data architectures to deliver business priorities and objectives
- Continuously monitoring databases and applications ensuring applications remain available, performant to SLAs/OLAs, and deliver a good user and customer experience
- Leading the delivery of database Incident Management (Corrective Maintenance), Problem Management (Preventative Maintenance) and Change Management (Adaptive and Perfective Maintenance).
- Documenting all databases, data interfaces and data flow diagrams, maintaining the accuracy of documentation to reflect changes and fixes.
- Maintaining a secure configuration management database with an accurate record of database assets.
At HSE, we are proud to be able to offer our people the opportunity to work in a hybrid way which combines working in from home and the office. This is a voluntary, non-contractual arrangement and your allocated office will be your contractual place of work. There will be a requirement to travel to the office for various activities e.g., collaborative working, supporting, and training colleagues. If hybrid working is suitable for you and your role, the arrangements will be determined primarily by business need, but personal circumstance and other relevant circumstance will also be considered. Therefore, we would encourage candidates to consider if the commute from home to an office us a feasible distance to travel before making an application.
Please note that if you are successful, hybrid working will be discussed prior to taking up the post.
The post can be based in any HSE location excluding London. For further information about HSE locations please click here. Occasional travel to our Bootle HQ will be required for team events and collaborative activities.
Person specification
Essential:
- A solid background in database administration, with a proven track record in both supporting and building SQL databases within a professional environment.
- Experience of leading database engineering teams
- Windows Clustering and other HADR technologies.
- A clear support focus with evidence of time spent performing Tier 2/3 support for SQL Databases.
- Experience working within ITIL framework delivering Incident/Problem/Change Management.
- Effective communication skills.
- Working knowledge of Microsoft Office.
Desirable:
- Database certification (e.g., MCSA, MCSE).
- Experience with Oracle & Ingres.
- Experience of working within a virtualised environment, including virtualised SQL servers using VMWare.
- Experience with ODS, Data Marts, Data Warehouses and Data Lakes.
- Experience with SSIS, SSAS.
- Familiarity with QlikView and PowerBI.
- Programming knowledge (PowerShell, Python, R, JSON, XML).
Behaviours
We'll assess you against these behaviours during the selection process:
- Delivering at Pace
- Managing a Quality Service
- Making Effective Decisions
Benefits
- Learning and development tailored to your role.
- An environment with flexible working options.
- A culture encouraging inclusion and diversity.
- Competitive rates of pay.
- Access to the highly competitive Civil Service Pension Scheme to which HSE contributes 27.1%, far more than the private sector.
- Carer friendly policies and working hours to help balance your home life and career.
- 25 days annual holiday increasing to 30 days after 5 years’ service, plus bank holidays and 1-day Civil Service privilege day.
- Competitive Parental leave benefits.
Things you need to know
Selection process details
Application Information
Within your application, you will be asked to complete an anonymised CV. Please ensure you complete your career history, your experience, and qualifications.
You will also be asked to complete a personal statement, of no more than 500 words, that demonstrates how you meet the skills and experience required for this role.
For guidance on how to apply and how to complete an application, please visit Civil Service Careers (opens in a new window).
Sift information
A sift will take place week commencing 27th February 2023 when you will be assessed on your CV and personal statement.
Interview information
Interviews will take place via Microsoft Teams during week commencing 20th March 2023 when you will be assessed on your technical knowledge, experience, and the advertised behaviours.
Please note that dependent on numbers of applications received these dates could be subject to change.
Further Information
Please note that due to the nature of security checks undertaken, applicants must have 3 years continuous residency in the UK up to the date of application and Home Office approval for indefinite leave to remain within the UK.
Please note that a reserve list will be held for a period of 12 months.
You will be required to be part of an On Call Rota.
It is the candidate’s responsibility to ensure they are aware of the terms and conditions they will adopt should they be successful in their application. For a summary of HSE terms and conditions as part of Civil Service Reform, please see the attached document.
Any move across the Civil Service on or after 4 October 2018 may have implications on an employee’s ability to carry on claiming childcare vouchers.
If you have a disability and you need an application form in an alternative format or you would like to know more about our recruitment process, please contact: [email protected].
Allowances
This post is eligible for Excess Fares Allowance. A successful internal candidate currently based at another office may be entitled to Excess Fares Allowance in line with HSE policy (http://intranet/finance/expenses/excess-fares-allowance-policy.htm).
Feedback will only be provided if you attend an interview or assessment.
Security
See our vetting charter (opens in a new window).
Nationality requirements
This job is broadly open to the following groups:
- UK nationals
- nationals of Commonwealth countries who have the right to work in the UK
- nationals of the Republic of Ireland
- nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of the European Union Settlement Scheme (EUSS) (opens in a new window)
- relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
- relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
- certain family members of the relevant EU, EEA, Swiss or Turkish nationals
Working for the Civil Service
We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).
Apply and further information
Contact point for applicants
Job contact :
Recruitment team :
Further information
