- Writing complex data manipulation statements using T-SQL as stored procedures and functions.
- Familiarity and experience with SQL Server Management Studio 2008 - 2019
- Creating, and using, Microsoft SQL Server Integration Services packages 2008+.
- Experience with HL7 v 2.x and FHIR messaging standards
- Normalisation techniques and ER-diagramming to design and create scalable, high-performance databases
- Agile development methodologies such as Scrum
- Azure Dev ops (Team Foundation Server
- TSQLT - Unit Testing SQL Procedures
- Unix/PowerShell Scripting
- Knowledge of High Availability solutions, such as Mirroring, Replication, Clustering, and Always On (Availability Groups)
- Microsoft Power BI
- Experience of Microsoft SQL Server tools, e.g. SQL Server Profiler, Query Analyser to help tune queries & create indexes.
- .NET Core
- XML Web services or Web API