MS ETL Developer / SQL DBA - SQL Server 2016 - SSIS - HA and DR

Experis LTD
£450 per day
13 Nov 2017
15 Nov 2017
Contract Type
Full Time
MS ETL Developer / SQL DBA - SQL Server 2016 - SSIS - HA and DR - RedGate

My client, a leading insurance company are seeking 2 x MS ETL Developers with SQL Server DBA skills to join an existing team working on a large Servers and DBs upgrade project.

The successful candidate will be involved in Servers and DBs upgrade from MS-SQL 2008R2 to MS-SQL 2016 environment, including the SSIS processes affected by the upgrade, AAG, Security roles implementation ensuring that the upgrade projects completes within timeline.

Core Duties:
  • Analyse current environments providing a break-down of the tasks to undertake with accurate estimates for the upgrade, including dependencies and critical path
  • Collaborate with colleagues to deliver the upgrade in an iterative way and highlighting risks and issues as soon as they arise
  • Introduce improvements of standards and automation without affecting delivery timelines
  • Develop an implementation plan to minimise the business disruption

Key Skills
  • MS SQL 2008, 2014, 2016 Standard/Enterprise/SSIS
  • Best practice in configuring SSIS packages and connections
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server
  • Experience in implementing operational automation using scripts
  • Knowledge of indexes, index management, and statistics
  • Familiarity with RedGate tools
  • Good communication and documentation skills

Highly Desired skills:
  • SSIS Deploying packages
  • GIT Code repository, understanding of version controlling process
  • Advise on database design and database optimisation
  • Tuning and performance improvements
  • Able to work closely with architects/system designers to produce highly performant designs

This job was originally posted as