SQL Developer
6-month contract
£160 per day
Inside IR35 via Umbrella company
Remote role with some onsite work in Cardiff
Building on recent digital investment, our client have been leading on a number of national health programmes. These are large-scale developments that will make a significant difference to the people of Wales.
Duties and Responsibilities:
-
Work as part of a well-structured Scrum team under the guidance of experienced team leads.
-
Take responsibility for delivering individual software components.
-
Engage in all aspects of the .NET development stack or MS SQL, depending on your experience.
-
Write complex data manipulation statements using T-SQL as stored procedures and functions.
-
Review and refactor T-SQL stored procedures and functions for performance.
-
Utilise SQL Server Management Studio (SSMS) versions (Apply online only).
-
Create and use Microsoft SQL Server Integration Services (SSIS) packages (2008+).
-
Apply normalisation techniques and ER-diagramming to design and create scalable, high-performance databases.
Skills:
-
Writing complex data manipulation statements using T-SQL as stored procedures and functions.
-
SQL Server Management Studio (SSMS) versions (Apply online only).
-
Creating and using Microsoft SQL Server Integration Services (SSIS) packages (2008+).
Familiarity with:
-
Agile development methodologies such as Scrum.
-
Azure DevOps (Team Foundation Server).
-
Understanding and implementing SOLID principles.
-
HL7 v 2.x and FHIR messaging standards.
-
Redgate SQL developer tools.
-
Requirements analysis.
-
TSQLT – Unit Testing SQL Procedures.
-
Unix/PowerShell scripting.
-
High Availability solutions, such as Mirroring, Replication, Clustering, and Always On (Availability Groups).
-
Microsoft Power BI.
-
Microsoft SQL Server tools, e.g., SQL Server Profiler, Query Analyzer for query tuning and index creation.
-
.NET Core.
-
XML Web services or Web API.
Contract Details:
This is an inside IR35 contract role, offering competitive remuneration of approximately £160 per day via an Umbrella company for 6 months with a view to extend.
This role is fully remote but the client may request some office visits maximum once a month