Senior Database Engineer
Grade: PO 2
Role code: EIT0041
Status: Police Staff
Main purpose of the role:
Develop and exploit the forces databases, proving technical advice and support with database development and database administration, undertake installation, configuration, upgrade, administration, monitoring and maintenance of physical databases, utilising database management system software and tools to investigate problems, evaluate performance, contingencies and risks, ensuring that databases are supported, resilient and sustainable, so as to satisfy the evolving business and operational needs of Kent Police and/or Essex Police.
- Manage database configurations for the forces IT systems, including installing and upgrading software servers and application tools, consult with database users and suppliers, investigate performance issues and ensure that database problems are correctly diagnosed and resolved, in order to ensure the provision of reliable and effective IT systems and services
- Provide a high quality technical advisory service, utilise database management tools to investigate, diagnose and resolve database problems within service level agreement tolerances, referring to database users, other staff and suppliers as necessary, in order to ensure the provision of effective and efficient IT systems.
- Analyse and evaluate database performance, apply database management systems software and appropriate analysis tools to collect database performance statistics and create reports, consult with users and draft proposals for improvement in order to help achieve optimum performance of IT systems.
- Assist with the development of proposals and documentation for backup and recovery of database information, carry out exercises to prove recovery procedures, monitor and test backup procedures to agreed standards and help implement recovery procedures and restore databases when necessary, to ensure the effective operation of systems following serious disruption
- Provide expert advice and guidance to system users, create complex query definitions as required, in order to extract data on an ad hoc basis and assist in documenting procedures and scripts for all aspects of database administration so as to help support the provision of efficient information systems and an excellent standard of service to users.
- Undertake software testing of all database components, including dynamic testing techniques, static testing, non functional testing and test automation techniques in order to verify that the software satisfies specified requirements and to detect errors in order to help deliver systems that are reliable, resilient and deliver high levels of performance.
- Assist with the management of database resources, including allocation of system storage, plan for future storage requirements, evaluate system security and availability requirements and prepare cases for additional resources where appropriate, in order to ensure that systems databases continue to support the forces operational requirements.
- Monitor trends in database activity, undertake data analysis and database design where appropriate, initiating regular exercises to optimise database performance, to ensure that users are able to achieve efficient access to data in order to support operational policing and business requirements.
Management vetting req.
The Senior Database Engineer will require an appropriate IT professional qualification (ITIL Managers Certificate/NVQ level 5 Information Systems development. They will be expert in database administration and possess a thorough understanding of the forces IT infrastructures, including databases, hardware, operating systems, local area networks etc. Detailed knowledge of ITIL Versions 2 and 3 is essential. SFIA Skills of Database Administration at Level 5, Database / Repository Design at Level 4 and Systems Integration at Level 4 are required. The post holder will possess a thorough knowledge of the policing and business operating environments.
A high level of capability is required with the application of database software enabling the creation, population and manipulation of data structures. A detailed knowledge is required of access control systems and information retrieval utilising automated (software) tools which enable selective access to information held within databases. They will be fully aware of tools and systems which provides access security control, business impact analysis, countermeasures and contingency arrangements relating to the serious disruption of IT services. eg fallback location/services.
The Senior Database Engineer will have a detailed knowledge of database modelling and design tools which assist in modelling a logical entity model, and generating a physical database. The post holder will be expert in the use of database software which enables the user to create, populate and manipulate data structures. They will be an expert in configuration management and the control and management of IT assets or configuration items
The post holder must be able to demonstrate an analytical and systematic approach to problem solving and pay close attention to detail. They must be able to advise managers and working groups within the Force on performance issues, risks, opportunities and future developments. The post holder will need to be able to produce proposals and recommendations for communications based customer service improvements. They will have strong interpersonal, analytical and communication skills both verbal and written.
Analyse Critically (Level 2)
I ensure that the best available evidence from a wide range of sources is taken into account when making decisions. I think about different perspectives and motivations when reviewing information and how this may influence key points. I ask incisive questions to test out facts and assumptions, questioning and challenging the information provided when necessary. I understand when to balance decisive action with due consideration. I recognise patterns, themes and connections between several and diverse sources of information and the best available evidence. I identify when I need to take action on the basis of limited information and think about how to mitigate the risks in doing so. I challenge others to ensure that decisions are made in alignment with our mission, values and the Code of Ethics.
Collaborative (Level 2)
I manage relationships and partnerships for the long term, sharing information and building trust to find the best solutions. I help create joined-up solutions across organisational and geographical boundaries, partner organisations and those the police serve. I understand the local partnership context, helping me to use a range of tailored steps to build support. I work with our partners to decide who is best placed to take the lead on initiatives. I try to anticipate our partners' needs and take action to address these. I do not make assumptions. I check that our partners are getting what they need from the police service. I build commitment from others (including the public) to work together to deliver agreed outcomes.
Deliver, Support and Inspire (Level 2)
I give clear direction and expectations, helping others to understand how their work operates in the wider context. I identify barriers that inhibit performance in my teams and take steps to resolve these, enabling others to perform. I lead the public and / or colleagues, where appropriate, during incidents or through the provision of advice and support. I ensure the efficient use of resources to create the most value and the right impact within my areas. I keep track of changes in the external environment, anticipating both the short and long term potential implications for the Police Service. I motivate and inspire others to achieve their best.
Emotionally Aware (Level 2)
I consider the perspectives of people from a wide range of backgrounds before taking action. I adapt my style and approach according to the needs of the people I am working with, using my own behaviour to achieve the best outcome. I promote a culture that values diversity and encourages challenge. I encourage reflective practice among others and take the time to support others to understand reactions and behaviours. I take responsibility for helping to ensuring the emotional well being of those in my teams. I take the responsibility to deal with any inappropriate behaviours.
Innovative and Open-minded (Level 2)
I explore a number of different sources of information and use a variety of tools when faced with a problem and look for good practice that is not always from policing. I am able to spot opportunities or threats which may influence how I go about my job in the future by using knowledge of trends, new thinking about policing and changing demographics in the population. I am flexible in my approach, changing my plans to make sure that I have the best impact. I encourage others to be creative and take appropriate risks. I share my explorations and understanding of the wider internal and external environment.
Take Ownership (Level 2)
I proactively create a culture of ownership within my areas of work and support others to display personal responsibility. I take responsibility for making improvements to policies, processes and procedures, actively encouraging others to contribute their ideas. I am accountable for the decisions my team make and the activities within our teams. I take personal responsibility for seeing events through to a satisfactory conclusion and for correcting any problems both promptly and openly. I actively encourage and support learning within my teams and colleagues.
I take into account individual needs and requirements in all of my actions. I understand that treating everyone fairly does not mean everyone is treated the same. I always give people an equal opportunity to express their views. I communicate with everyone, making sure the most relevant message is provided to all. I value everyone's views and opinions by actively listening to understand their perspective. I make fair and objective decisions using the best available evidence. I enable everyone to have equal access to services and information, where appropriate.
I always act in line with the values of the police service and the Code of Ethics for the benefit of the public. I demonstrate courage in doing the right thing, even in challenging situations. I enhance the reputation of my organisation and the wider police service through my actions and behaviours. I challenge colleagues whose behaviour, attitude and language falls below the public's and the service's expectations. I am open and responsive to challenge about my actions and words. I declare any conflicts of interest at the earliest opportunity. I am respectful of the authority and influence my position gives me. I use resources effectively and efficiently and not for personal benefit.
Public Service (Accredited)
I act in the interest of the public, first and foremost. I am motivated by serving the public, ensuring that I provide the best service possible at all times. I seek to understand the needs of others to act in their best interests. I adapt to address the needs and concerns of different communities. I tailor my communication to be appropriate and respectful to my audience. I take into consideration how others want to be treated when interacting with them. I treat people respectfully regardless of the circumstances. I share credit with everyone involved in delivering services.
I ensure that my decision-making rationale is clear and considered so that it is easily understood by others. I am clear and comprehensive when communicating with others. I am open and honest about my areas for development and I strive to improve. I give an accurate representation of my actions and records. I recognise the value of feedback and act on it. I give constructive and accurate feedback. I represent the opinions of others accurately and consistently. I am consistent and truthful in my communications. I maintain confidentiality appropriately.
Business Planning (Level 3)
Able to effectively contribute to the business planning process within a Division / Department. Demonstrates a broad understanding of the requirements of Force business planning and value for money. Identifies and recommends local objectives and targets for inclusion in the Division / Department plan. Takes responsibility for monitoring these and ensuring they are achieved.
Data and Systems Security (Level 5)
Demonstrates the skills necessary to carry out assessments of risks for systems within the Force or those under acquisition or development using risk analysis techniques and computer audit software (e.g. CRAMM). Understands the implications of risks and makes informed recommendations to adjust the annual audit plan in light of the results. Able to identify methodologies and approaches for systems under review using recognised audit procedures (e.g. GIAM). Uses these skills to devise Force policy on data and system
Health & Safety (Level 3)
Has a basic understanding of Health and Safety issues affecting the current role and working environment. Takes responsibility for personal safety and the safety of others. Aware of hazards and reports problems identified to line manager. Understands and minimises the physical risk of injury through the use of proper manual handling procedures.
ICT - Systems Implementation (Level 4)
Experienced in systems integration techniques, including implementation, fault diagnosis, implementation tests and handover procedures. Able to work unsupervised on many project tasks. Exhibits a high level of proficiency in more than one related discipline, with a broad knowledge of current technology. Likely to be accredited or working towards Microsoft Certified Systems Engineer status or equivalent, and/or Associate Membership of the BCS.
Internal Consultancy (Level 4)
Demonstrates an in depth knowledge of the relevant specialist area and combines this with high level consultancy skills. Develops collaborative relationships with internal clients and works with them to achieve joint objectives and targets. Maintains an up to date awareness of all developments which may affect Force business and policies and proactively advises clients of all relevant matters.
Know. of Police Environment & Policy (Level 4)
Displays a general appreciation of changes affecting the police service. Understands the inter-relationships between the roles of the various Operational and Support activities, and how organisation structures and police systems work. Possesses a detailed understanding of working procedures, practices and policies relevant to the current role and the roles of subordinates and ensures that these are followed at all times. Is clear about Force goals and effectively contributes to local business plan objectives.
Mgmt of Police Information (MOPI) (Level 4)
Full compliance with Level 3. Has successfully completed all standard relevant Information Management and Security training package(s). Accurate use of Government Security Classification (GSC). Ensures physical and digital records are stored with appropriate security relevant to the sensitivity of the documents and has working understanding of appropriate National Retention Schedules. Is able to quality assure own records management processes as well as those of any staff for whom they have supervisory responsibility. Is aware of where to seek further support in relation to Records management within force when necessary. If nominated as an Information Asset Assistant is familiar with the NPCC Information Asset Owners Handbook.
Risk Management (Level 4)
Able to anticipate risks likely to affect the team's ability to execute their function, in terms of likelihood and impact, and assesses how the challenges facing the wider organisation might affect their team and their objectives. Has an understanding of pathways to alert local managers to flawed or ineffective operational control strategies and provide continuity/recovery options. Has an appreciation that seizing opportunities also generates risks.