SSIS and SQL DBA

  • Job Summary/ Overview

     

    To work as part of the MIS team, designing, implementing, maintaining and on going enhancement to the Microsoft SQL server 2005 Data Warehouse and and SSIS packages.

    The job role is for a highly motivated, self starter to own the Data Warehouse under little or no supervision.

     

    Responsible for : 

     

    • Capacity planning
    • Database tuning (including partitioning and indexing strategies)
    • Performance maintenance, archiving.
    • Definition and Implementation of Backup Strategy and restore.
    • Security
    • Maintenance and developing SSIS packages

     

     

    Reports to :  Data Strategy Manager

     

     

    Principal duties and responsibilities

     

     

    Business Operations

     

    ·         Technical consulting, design, implementation and set up of the Data Warehouse from the test environment onto production.

    ·         Managing Job Schedules

    ·         Setting up and Maintaining Maintenance Plans

    ·         Backup and Restore

    ·          

     

     

    Relationship Management

     

    • Sustaining strong relationships with senior management, peers and colleagues

     

     

    MAIN job requirements

     

     

    Skills Required – MUST

     

    ·         2 years SQL Server 2000 and 2005 RDBMS Services in Cluster Environment

    ·         SQL Server 2005 SSIS (Integration Services)

    ·         SQL Server 2000 DTS

    ·         Data Warehousing Principals

    ·         Handling large Data warehouse databases (+300Gb)

    ·         Indexing Strategies and Query Optimisation

    ·         Partitioning Strategies (Database [RDBMS])

    ·         Experience in SAN environments

     

     

     

    Skills Required – Nice To Have

     

    ·         MS SQL Analysis Services – SSAS (OLAP)

    ·         MS SQL Reporting Services - SSRS

    ·         Partitioning Strategies on Analysis Services [OLAP/SSAS]

    ·         Installation and configuration of SQL 2005 Services (RDBMS, SSIS, SSRS, SSAS) in clustered environment.

    ·         Microsoft Certified

    ·         Designing Star Schemas using Kimball methods

     

     

    Education & Experience

     

    • Educated to degree level
    • MCTS, MCITP, MCDBA

     

    Required Competencies (proficiency levels 1 to 5, with 1 being highest and 5 being lowest)

    Level of Proficiency

    Technical Competence

     

    OLAP

    MDX

    SSRS

    SSIS

     

     

     

     

    2

    1

    2

    1

    Core Competencies

    • Independent thinking 

     

    • Strong problem solving skills

     

    • Personal motivation

     

    • High energy levels

     

    • Strong work ethic

     

    • Ability to work without significant supervision

     

    • High personal integrity

     

    • Great team work orientation

     

    • Strong decision-making skills

     

    • Ability to be focused and organised

     

    • Ability to lead through and manage change

     

    • High adaptability and desire to improve their environment

     

     

    2

     

    1

     

    1

     

    1

     

    1

     

    2

     

    1

     

    1

     

    2

     

    1

     

    1

     

    1

     

    This role is based in Marlow, England and the salary is £33,000 p/a. If anyone is interested please call Tom on 0207 621 2300, or email me a cv to tdefreitas@newmanstone.co.uk . I actually get quite a few SQL Server roles, and I can't believe I didn't know this site existed!

    Please take the above job spec with a pinch of salt - my client is a medium sized business working a niche market within telecomms - they have just signed an exclusive deal with Skype, so this is a very exciting time to be joining them.

     

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply