Job
Role
To provide dedicated data services support to the company, by
designing, creating, maintaining and enhancing database objects, ensuring data
quality, consistency and integrity. Migrating data from various sources to
central SQL 2008 data warehouse will be the primary
function.
Migration of data from bespoke legacy database’s
to SQL 2008 data warehouse.
Understand key business requirements, Liaising
with various aspects of the company.
Create advanced transformations of data, with
focus on data cleansing, redundant data and
duplication.
Creating complex business rules regarding data
services, migration, Integrity and support (Best
Practices).
Experience
·
Minimum 3 year SSIS experience, in a project or BI Development role
and involvement in at least 3 full ETL project life cycles, using the following
methodologies and tools
o
Excellent knowledge of ETL concepts including data migration &
integrity, focusing on SSIS.
o
Extensive experience with SQL 2005 products, SQL 2008
desirable.
o
Working knowledge of SSRS and its integration with other BI
products.
o
Extensive knowledge of T-SQL, stored procedures, triggers
(Table/Database), views, functions in particular coding and
querying.
o
Data cleansing and harmonisation.
o
Understanding and knowledge of indexes, statistics and table
structure.
o
SQL
Agent – Scheduling jobs, optimisation, multiple jobs, DTS.
o
Troubleshoot, diagnose and tune database and physical server
performance.
o
Knowledge and understanding of locking, blocks, table and index
design and SQL configuration.
·
Demonstrable ability to understand and analyse business
processes.
·
Experience in creating business rules on best practices for data
services.
·
Experience in working with, supporting and troubleshooting MS SQL
servers running enterprise applications
·
Proven ability to work well within a team and liaise with other
technical support staff such as networking administrators, system administrators
and support engineers.
·
Ability to create formal documentation, work procedures, and service
level agreements.
·
Ability to communicate technical issues at all levels including to a
non technical audience.
·
Good working knowledge of MS Word, Excel, PowerPoint, Visio and
Project.
Location
Based in Crawley with
possibility of some remote working
Contact me for more
info:
http://sqlblogcasts.com/blogs/blakmk/contact.aspx
