Data Warehouse Developer - Westcliff-on-Sea, United Kingdom - Roc Search Limited

Roc Search Limited

Verified Company

Westcliff-on-Sea, United Kingdom

3 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

I am currently recruiting for a SQL Specialist to join a NHS Trust based in Essex, paying £257 per day, inside IR35 for an initial 6-month contract.

Job Details Below

Excellent understanding of T-SQL
Familiar with stored procedures, functions, indexes, constrains, CTE, views, temp tables, table variables, linked servers, openquery, dynamic SQL etc.
Query Performance tuning
SQL Automation using SQL Agent
SSIS (different versions including 2008 and development, troubleshooting and package deployment.
MS SQL Server (different versions including 2008 R2 and 2019)
Query Optimization
Understanding of SQL Server security, access, permissions etc.
Excellent communication, analytical, interpersonal and project management skills (actions, escalations, deadlines)

Experience:

Involved in SQL database migration ideally from SQL 2008 R2 to SQL 201
Worked with different versions of MS Visual Studio (including BIDS 2008, VS 2019)
Experience with upgrading SSIS packages (including dts) from Package Deployment Model to Project Deployment Model, familiar with SSIS catalogue.
Experience in creating, maintaining, and troubleshooting ETL processes
Error handling and debugging (ETL, SSIS and SQL coding issues)
Possible experience with "Query Tuning Assistance" tool available from SSMS 18.0 used for guidance on recommended compatibility level upgrade process suggests hintbased improvements that can be deployed for individual queries.
Created IT technical documentation, hand over documentation, user guides etc.

Desirable:

C#, VB.NET (there are script tasks using those programming languages within SSIS packages that we might need to rework)
Use of versioning tool (any, dev ops, team foundation, git hub)

Please send across your updated CV and I will be in touch to discuss further.