Reference
SQL3572
Sector
Development, Technology and Change
Salary
£50,000 to £60,000 Per Annum
Benefits
Bonus + Excellent Benefits
Town/City
London City
Contract Type
Permanent
An exciting opportunity for a SQL Database Developer to join an agile and growing IT team within a leading Lloyd’s syndicate.
Essential Skills / Experience
3 to 5 years of commercial experienceExpertise in database design and development using OLTP and OLAP systems using MS SQL Server 2016 or higher including experience of SSIS and SSAS.Create and maintain database objects such as Tables, Views, Stored Procedures & UDFs to support new functionality and optimize existing ones for performance.Follow SDLC standards, source-code management, and release-management procedures.Design and implement ETL processing (SSIS preferred).Make datasets available for reporting purposes.Positive proactive attitude, willing to turn their hand to any problem, and willing to work things out when they fall outside their area of direct expertise.Query tuning to improve performance, reduce complexity & increase maintainability.Insurance market experience preferable but not essential
Nice to have Skills
Datawarehousing / Star-schema development.Microsoft SQL MDS installation, configuration & ETL.Low level SQL optimisations such as implementing partitioning schemes, and implementing column store indexes.Experience with deploying SQL changes in a repeatable & reliable manner (CI/CD experience a big plus)Experience working with source control, deployment, backlog and task management.PowerShell knowledge.SSRS experience - especially diagnosing & fixing performance bottlenecks.Experience working with Microsoft Azure SQL & related technologies.BIML scriptingExperience working in AGILE teams