Data Integration Data Base Administrator

ABOUT THE JOB

To design, develop, programme, administer, support and maintain enterprise data systems, providing data integration services through the development and implementation of an integrated data architecture using data Extract/Transform/Load (ETL) tools/techniques, in accordance with agree 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 will hold a degree in related computer science or software engineering discipline.

You will have an understanding of relational database system management principles, Data Warehousing and Business Intelligence concepts and best practices; extensive knowledge of transforming, replicating and cleansing data; of Extract/Transform/Load (ETL) solutions for Business Intelligence; and of the development and administration of relational database management systems, including a good working knowledge of SQL.

You will have extensive experience of 24x7 high availability environments, installing and configuring new databases and troubleshooting, performance monitoring, tuning and script development in a database environment; proven experience in a technical role related to enterprise data integration using ETL techniques and technologies; and extensive experience of working with RDBMS in a heterogeneous environment one or more of Oracle 10g or above Microsoft SQL Server.

There are three vacancies for this role:

• x1 Permanent
• x1 Temporary for up to 18 months,
• x1 Temporary for up to 24 months.

All posts are full time and will require Management Level + Security Clearance Vetting. You will work 35 hours a week, Monday to Friday, 09:00 – 17:00.

The following competencies at level 2 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 five years immediately prior to application.

TO APPLY

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