SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS and SQL DBA


SSIS and SQL DBA

Author
Message
Tom de F
Tom de F
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1

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.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search