Production Database Administrator

*DO NOT APPLY VIA INDEED. FOR YOUR APPLICATION TO BE CONSIDERED PLEASE APPLY VIA THE POLICE SCOTLAND WEBSITE BELOW*

https://policescotland-spacareers.tal.net/vx/appcentre-PoliceScotlandExternal/brand-3/candidate/so/pm/6/pl/24/opp/1956-Production-Database-Administrator/en-GB

ABOUT THE JOB

To design, develop, administer, programme, support and maintain enterprise database systems and services, in accordance with agreed standards and to assist in providing a strategic co-ordination of these technologies within the general ICT environment across Police Scotland and the SPA.

ABOUT YOU

You should have excellent interpersonal, communication, analytical and problem solving skills. Strong prioritisation and organisational skills, customer focused. Have the ability to work on own initiative with limited supervision. Ability to work under pressure as part of a team and have proven skills related to Team-working.

You will be educated to a degree level in related computer science or software engineering discipline. It would be desirable to have qualification in an enterprise database technology (Oracle or SQL Server.

You will have knowledge and experience of:

o Relational database system management principles and practices.

o Database design (logical and physical) and implementation.

o The development and administration of relational database management systems, including a good working knowledge of SQL.

o Database backup and recovery technology and associated processes.

o Oracle 10g or above.

o Database design (logical and physical) and implementation.

• Data Warehousing and Business Intelligence concepts and best practices.
• Experience administering application servers.
• Knowledge of Microsoft SQL Server.

You should have experience writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata).

Knowledge of data protection legislation, information security protocols and data weeding practices.

• A sound understanding of how existing and developing government legislation affects the storage, use and transfer of data in ICT systems.
• Experience of architecting, designing, developing, and testing ETL solutions.
• Working with customers to elicit and define requirement specifications.
• Proven experience in a technical role related to enterprise database architecture, design, management and the delivery of enterprise data services.

Personal Qualities (Desirable):

• Experienced in working with disparate data systems which are spread across a multi-site physical and operational environment.

Special Aptitudes (Essential):

• Strong analytical skills.
• Capable of communicating effectively with both a Technical and non-Technical audiences.
• Ability to use own initiative and deal with a varied programme of work.

This full time post is permanent and will require Standard Recruitment Vetting. You will work 35 hours a week, Monday to Friday, 09:00 – 17:00.

The following competencies at level 1 will be used for the selection process:

We are emotionally aware

We take ownership

We are collaborative

We deliver, support and inspire

We analyse critically

We are innovative and open minded

BENEFITS

- Competitive salary and guaranteed allowances

- Annual salary increments

- Local Government Pension Scheme

- 28 days annual leave and 6 public holidays on appointment

- Wide range of family friendly policies

- Employee Assistance Programme

- Access to range of staff associations

- Scottish Police Recreation Association

- Scottish Police Credit Union

- Cycle to Work Scheme

INTERVIEW GUARANTEE

The Scottish Police Authority / Police Scotland is committed to positive action in the recruitment and selection of people with disabilities. We guarantee an interview to any applicant who has a disability, as defined under the Equality Act 2010, and who meets the essential criteria for the post. Please regard this as an opportunity to let us help you. Tell us of any aspects which could present difficulties and any suggestions for overcoming these.

RESIDENCY AND ELIGIBILITY TO WORK IN THE UK

Applicants must be a British citizen, a member of the EU or other states in the EEA, a Commonwealth citizen or a foreign national free of restrictions. You should also have been resident in the UK for a minimum of three years immediately prior to application.

TO APPLY

Please visit the Police Scotland Career Site for Job Reference Number – 1956

Job Types: Full-time, Temporary contract
Contract length: 20 months

Salary: £42,636.00-£47,649.00 per year

Benefits:

• Company pension
• Sick pay
• Wellness programme

Schedule:

• Monday to Friday

Work Location: In person

Application deadline: 12/05/2023
Reference ID: 1934