Principal DBA - JRN 14308
 

Salary: £55,000 (Base salary of £41,904 to £45,873 plus Market Forces Supplement of 17%)

***Please note this is a 12 Months Fixed Term opportunity***

Ever wondered what it’s like working behind the scenes for one of the UK’s largest Police Forces? Here at Northumbria Police, we are extremely excited to be able to offer an amazing opportunity to come and join us in our Digital Policing team.

Digital Policing offers a wide range of diverse and exciting technologies that support both front line operational policing and back-office support functions to successfully serve our communities.

The Digital Policing Data & Information Team are looking for an enthusiastic Principal DBA with strong Oracle skills and experience to lead and deliver critical DBA services for the Force’s strategic transformation programme.

This role is a one-year fixed term post to cover maternity leave and offers a flexible mix of home and office-based working, as necessary, as well as offering agile working patterns where working arrangements will be available as agreed with the vacancy manager and in line with the requirements of the role.

What do I need?

  • A degree, HND or equivalent qualification, and/or have significant relevant experience
  • Excellent Oracle skills
  • Experience of high availability and disaster recovery options
  • Experience of backup and recovery procedures
  • Experience of installing, upgrading and patching
  • Experience of monitoring, tuning and securing databases
  • Good knowledge and application of principles of safe data management
  • Experience of developing and maintaining ETL processes
  • Experience of Database Migration
  • Excellent ability to prioritise and plan
  • Strong estimating skills and experience

The Role:

The successful candidate will manage, design, implement and improve complex relational database technologies and multi-tier application services as well as managing systems performance to prevent a business affecting problem from arising. 

You will provide consultative support and guidance to the DBA team whilst ensuring quality of delivery and design for Force databases and delivering good quality data migration through effective use of ETL processes.  

You will also be expected to aid in problem solving and carry out any required investigations to meet the strategic objectives of the Force.   

What will I be doing?

  • You will maintain application and database software including Oracle E-Business Suite, Enterprise Application Services, Oracle Database, Directory Services and Business Intelligence products, producing test and regression plans and performance tuning to aid business continuity planning.
  • Develop and support data migration through effective ETL processing
  • Manage 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
  • Approve all production database design and schema changes and control the migration of schema changes from development to production environments
  • Provide professional and expert advice on the importance of good data management practises
  • Accurately forecast future application and database growth over the short, medium and long term by undertaking capacity planning to ensure that applications and databases make best use of the storage available
  • Line Manage at least one direct line report, supporting their performance, training and development needs to improve the quality of service and contribute to the development of the individual.

It takes a great deal of people from different backgrounds, with diverse skills and experience to service the Northumbria Police Force area effectively.  Think you have what it takes to make a difference?  This could be the perfect time to join us!

For further information please see the role definition: Role Definition.docx

Vacancy Contact

Interested to learn more? To discuss the position in more detail please the Talent Acquisition Team by email at careers@northumbria.police.uk.   

Terms and Conditions

Vetting Level - Recruitment Vetting (MV)

Applicants must be a resident of the UK for a minimum period of 5 years to ensure vetting checks can be successfully performed.  A job offer will be dependent upon vetting clearance, medical information and references.

Benefits

In return for your dedication and experience, we offer 24 days’ leave, excluding bank holidays, increasing to 29 days for 5 years+ service.  We support our people inside and out of work – offering a very competitive pension scheme, and discounts on shopping and eating out thanks to the Blue Light Card. Also, to take care of your physical and mental well-being, we’ve invested in extensive paid sick leave, trained mental health first aiders on-site, an employee advice service and access to gyms in some stations.

Diversity, Equality and Inclusion

At Northumbria Police we are all different and that’s our greatest strength. We draw on the differences in who we are, what we’ve experienced and how we think. We protect and serve everyone and therefore believe in including everyone. We welcome applications from suitably qualified people from all areas of the community as appointments are based solely on merit.

Important Information

Northumbria Police are currently undertaking a role and reward project in respect of all police staff posts.

All staff including those appointed on fixed term contracts must successfully complete their probationary period before they are eligible to apply for a Northumbria Police vacancy.

If you have any queries with regard to the application process please contact the Talent Acquisition Team by email at careers@northumbria.police.uk

We reserve the right to close this vacancy early if we receive sufficient applications for the role. Therefore, if you are interested, please submit your application as early as possible.

Vacancy Type
Police Staff
Rank/Grade
Grade J
Area Command/Department
Digital Policing
Location
Forcewide
Hours
Full Time
Salary Range
No Salary Detailed
Vacancy Description
 

Salary: £55,000 (Base salary of £41,904 to £45,873 plus Market Forces Supplement of 17%)

***Please note this is a 12 Months Fixed Term opportunity***

Ever wondered what it’s like working behind the scenes for one of the UK’s largest Police Forces? Here at Northumbria Police, we are extremely excited to be able to offer an amazing opportunity to come and join us in our Digital Policing team.

Digital Policing offers a wide range of diverse and exciting technologies that support both front line operational policing and back-office support functions to successfully serve our communities.

The Digital Policing Data & Information Team are looking for an enthusiastic Principal DBA with strong Oracle skills and experience to lead and deliver critical DBA services for the Force’s strategic transformation programme.

This role is a one-year fixed term post to cover maternity leave and offers a flexible mix of home and office-based working, as necessary, as well as offering agile working patterns where working arrangements will be available as agreed with the vacancy manager and in line with the requirements of the role.

What do I need?

  • A degree, HND or equivalent qualification, and/or have significant relevant experience
  • Excellent Oracle skills
  • Experience of high availability and disaster recovery options
  • Experience of backup and recovery procedures
  • Experience of installing, upgrading and patching
  • Experience of monitoring, tuning and securing databases
  • Good knowledge and application of principles of safe data management
  • Experience of developing and maintaining ETL processes
  • Experience of Database Migration
  • Excellent ability to prioritise and plan
  • Strong estimating skills and experience

The Role:

The successful candidate will manage, design, implement and improve complex relational database technologies and multi-tier application services as well as managing systems performance to prevent a business affecting problem from arising. 

You will provide consultative support and guidance to the DBA team whilst ensuring quality of delivery and design for Force databases and delivering good quality data migration through effective use of ETL processes.  

You will also be expected to aid in problem solving and carry out any required investigations to meet the strategic objectives of the Force.   

What will I be doing?

  • You will maintain application and database software including Oracle E-Business Suite, Enterprise Application Services, Oracle Database, Directory Services and Business Intelligence products, producing test and regression plans and performance tuning to aid business continuity planning.
  • Develop and support data migration through effective ETL processing
  • Manage 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
  • Approve all production database design and schema changes and control the migration of schema changes from development to production environments
  • Provide professional and expert advice on the importance of good data management practises
  • Accurately forecast future application and database growth over the short, medium and long term by undertaking capacity planning to ensure that applications and databases make best use of the storage available
  • Line Manage at least one direct line report, supporting their performance, training and development needs to improve the quality of service and contribute to the development of the individual.

It takes a great deal of people from different backgrounds, with diverse skills and experience to service the Northumbria Police Force area effectively.  Think you have what it takes to make a difference?  This could be the perfect time to join us!

For further information please see the role definition: Role Definition.docx

Vacancy Contact

Interested to learn more? To discuss the position in more detail please the Talent Acquisition Team by email at careers@northumbria.police.uk.   

Terms and Conditions

Vetting Level - Recruitment Vetting (MV)

Applicants must be a resident of the UK for a minimum period of 5 years to ensure vetting checks can be successfully performed.  A job offer will be dependent upon vetting clearance, medical information and references.

Benefits

In return for your dedication and experience, we offer 24 days’ leave, excluding bank holidays, increasing to 29 days for 5 years+ service.  We support our people inside and out of work – offering a very competitive pension scheme, and discounts on shopping and eating out thanks to the Blue Light Card. Also, to take care of your physical and mental well-being, we’ve invested in extensive paid sick leave, trained mental health first aiders on-site, an employee advice service and access to gyms in some stations.

Diversity, Equality and Inclusion

At Northumbria Police we are all different and that’s our greatest strength. We draw on the differences in who we are, what we’ve experienced and how we think. We protect and serve everyone and therefore believe in including everyone. We welcome applications from suitably qualified people from all areas of the community as appointments are based solely on merit.

Important Information

Northumbria Police are currently undertaking a role and reward project in respect of all police staff posts.

All staff including those appointed on fixed term contracts must successfully complete their probationary period before they are eligible to apply for a Northumbria Police vacancy.

If you have any queries with regard to the application process please contact the Talent Acquisition Team by email at careers@northumbria.police.uk

We reserve the right to close this vacancy early if we receive sufficient applications for the role. Therefore, if you are interested, please submit your application as early as possible.