Job title: Database Administrator
Job type: Contract
Emp type: Full-time
Pay interval: Daily
Pay rate: GBP £350.00
Location: United Kingdom
Job published: 06-04-2020
Job ID: 38292
Contact name: Chris Bicknell
Phone number: 01676545382
Contact email: Chris.B@ecsgrp.co.uk

Job Description

Data Warehouse DBA

Responsible:

  • Transforming the logical data model to a physical schema for the Data Warehouse.
  • Creation and amendments to the physical database schema for the Data Warehouse
  • Performance tuning of the Data Warehouse as and when required
  • Work closely with the Data Architecture team to understand the logical model
  • Work closely with DevOps teams to support development and operations

 

Requirements:

  • Good experience of creating and developing SQL Server databases
  • Good experience of converting a logical data model into a physical data model
  • Experience of deploying SQL Server database on Azure
  • Good experience of SQL queries and tuning
  • Experience of both 3NF Database schemas (relational) and Kimball schemas (dimensional)
  • A strong understanding of TSQL (Prodecures, functions)
  • Database Design and implementation (this must included an understanding of data modelling in a data warehouse dimension facts along with star and snowflake models