Job Reference: BBBH43066
Job Duration: 3 Months +
Start date: 10/10/22
Description:
Senior SQL Developer (Band 8A or 8B) (REMOTE)
3 Month Contract (Possibility of Extension)
£267 (8A) - £356 (8B) Per Day
REMOTE
10th October Start Date
Job Description:
* 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 2019) - development, troubleshooting and package deployment.
* MS SQL Server (different versions including 2008 R2and 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 SQLdatabase migration ideally from SQL 2008 R2 to SQL 2019
* 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 handlingand 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 hint-based 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)
Senior SQL Developer (Band 8A or 8B) (REMOTE)
3 Month Contract
£267 (8A) - £356 (8B) Per Day
REMOTE
10th October Start Date
Industry: Public Sector and Government
Salary: £267 - £365 perday
Salary Benefits:
Vacancy Type: Contract
Job Skills: -
Contact Name: Bilal Ramay
Website: -
Direct Application URL: -