Role:
Salary: Career Graded 9-10, £41,133 – £52,491
Location: Agile, Forth Banks Police Station and homeworking
Hours/Contract: Permanent, 37 hours per week
Working for #TeamNP
Our purpose at Team NP is simple: to keep people safe and to fight crime. But it takes more than officers alone to do the job – and that’s where our 2,000-strong team of police staff and 200 volunteers come in.
As one of the largest police forces in England we have a huge variety of departments and specialisms offering you endless opportunities. From mentoring and coaching schemes and online soft skills courses to leadership development programmes; we’ll give you the support, training and time to carve out the career you always wanted.
As one of the top 50 UK inclusive employers and a disability confident employer, we promote a culture of respect in the workplace so everyone can feel seen, heard and valued. Whether you’re a member of staff or a volunteer, you can also expect first-rate support to manage your health and wellbeing. With year-round events, a 24/7 welfare support hotline and a leading approach to neurodiversity, our initiatives enable you to be at your best. Above all else, here at Team NP, we can offer you a career that is so much more than just a job, it’s a chance to be part of something that really matters.
Learn about our
The role
Here at Northumbria Police, we think our region is amazing! It takes a great deal of people from different backgrounds, with diverse skills and experience to serve our force area effectively, think you have what it takes to help us make a difference? This could be the perfect time for you to join us in our Digital Policing Department as a SQL Server DBA.
To support, monitor and maintain the databases that service all in-house and third party supplied applications as well as designing and developing performant new database solutions that support force data strategies, quality, integrity and security.
We are seeking an SQL Server Database Administrator with extensive knowledge and experience in SQL Server administration in Microsoft Azure and on-premises environments. You will manage all aspects of database administration in a single and clustering environment including and not limited to planning, installation, upgrades, patching, configuration, security configuration, backup and restore, optimisation and monitoring of SQL Server databases.
What you’ll do
1. Manage and develop database implementations to resolve issues and identify potential problems and trends, ensuring that the performance of the systems and support services remain in line with Service Level Agreements to provide a customer focused service that meets the needs of the organisation.
2. Ensure effective and efficient system performance via database performance tuning and optimisation, using monitoring and troubleshooting tools.
3. Maintain enterprise database software, produce test plans, regression and rollback plans and patch timings for business continuity planning
4. Undertake impact assessments in relation to patching, applications releases and deprecated products and features to ensure that the risks of system changes are fully understood by the system owners and Digital Policing support teams.
5. Review database design and schema changes to migrate schema changes from development to production environments.
6. Liaise with internal and external user groups, manufacturers and suppliers to progress work of the section to ensure all parties are providing an effective and efficient service.
7. Support both the planned activity of Programme and Project Managers to deliver new systems and services by assisting in the design and implement of high availability database structures that supports 24/7 mission critical systems and test disaster recovery solutions for database services.
8. Implement the principles of data security by aligning applications and Digital Policing products to reflect Force policy and industry best practice to assist auditing and data management processes.
9. Document data interface protocols that detail how data and information is accessed.
10. Participate in the system of implementation and recovery procedures, taking part in the call-out/stand-by rota, in order to satisfy the needs of system users.