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
Apply with indeed Apply with linkedin
File types (doc, docx, pdf, rtf, png, jpeg, jpg, bmp, jng, ppt, pptx, csv, gif) size up to 5MB
File types (doc, docx, pdf, rtf, png, jpeg, jpg, bmp, jng, ppt, pptx, csv, gif) size up to 5MB