Ver1 - KAL

Job Role: / IT Database Analyst
Department: / IT
Supported by: / IT Support Manager

Job Purpose

To take ownership and lead in the design, delivery and ongoing maintenance of technology environments that meets and/or exceeds requirements as part of an exciting and critical programme of work.

The outcome of this programme will be a refresh of the core Policy Administration & Billing systems and creation of a Data Warehouse. The purpose of this role is to take ownership and lead the creation and maintenance of the required databases for our new Data warehouse.

Main Duties

The main duty of this role is to work with IT delivery and support teams to ensure new products and technologies are integrated/configured/optimised in line with IT architectural principles, policies and best practice relating to new and existing environments within the Admiral Technology estate. You will be working with all roles within IT to ensure this occurs in a controlled and timely manner.

In addition to this you will also proactively manage and address any risk issues relating to your assigned duties. You will be expected to complete your duties whilst conforming to any project timelines or service level agreements that are in place.

Other duties include:

·  Design, configure and maintain enterprise technology environments.

·  Recommending & enforcing coding standards for best practise.

·  Provide timely and accurate estimates for assigned tasks.

·  Research new technologies and function as a subject matter expert.

·  Diligently share knowledge with others through teaching and/or mentoring.

·  Act as a point of technical referral or provide 3rd Line Technical Support, where appropriate.

·  Maintain a good working relationship with customers and technical partners including Project teams.

·  Produce or contribute to detailed documentation for existing or new configurations.

·  Provide project briefings for Management.

This is not a full definition of the role but covers the main aspects and drivers for success.
Experience and Qualifications Required

Essential:

·  Practical experience using Teradata:

o  Workload management and throttling using TASM, physical node behaviour, and amp distribution, session management, Viewpoint

o  Indexing strategy (PIs, NUPIs, partitioning etc.)

o  Physical design and system configuration best practises

o  Understand TPT and the use cases for each of the following utilities: Mload, FastLoad, Multiload, Tpump

o  User and Database hierarchies and security

o  BTEQ scripts

·  Professional experience working on a multi-terabyte, high volume enterprise data warehouse implementation.

·  A deep and practical level of experience in the following DBA areas:

o  Solid database design and SQL experience

o  Working with logical and physical data models

o  Maintaining and scheduling backup and archiving (BAR) processes

o  Designing and implementing indexing, archiving and partitioning strategies

o  Updating statistics and performance optimisation of long running queries

o  Operational maintenance e.g. patching and failovers

o  Implement policies and procedures for ensuring the security and integrity of the corporate data warehouse

·  Familiarity with data warehousing and Business Intelligence concepts such as slowly changing dimensions, star schema, OLAP and ETL/ELT.

·  Able to work with structured frameworks, methodologies and best practices.

·  An ability to learn from, and adapt to, a changing technical environment.

·  Demonstrable analytical skills.

·  Strong interpersonal and communication skills.

·  Significant and proven creative problem solving skills.

·  Ability to work independently and in a team (co-located or dispersed).

·  Technical competence and aptitude to learn new things quickly.

·  Excellent organisational skills.

Desirable:

·  Practical experience using Oracle 11g 12g:

o  RAC

o  Dataguard

o  RMAN

·  Platforms e.g. x86-64, Windows, Linux (Redhat, CentOS), AIX, VMWare, OS security.

·  Informatica, SAS, Microstrategy, SVN, Erwin, Visio.

·  Familiarity with Agile/Scrum.

·  Familiarity with a Support Environment.

·  Previous experience of working in the Insurance Sector.

·  Experience of Confluence & JIRA.

Data Base Administrator IT November 2014