SQL Database Developer

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

Share this Job

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

You may also be interested in...

An urgent 6 month + contract (Outside ir35) opportunity for an experienced IT Project Manager to join a leading London Market Insurer and ensure the smooth delivery of a vendor transition project.
Salary: £500 to £600 Per Annum Sector: Technology and Change, Project Management Contract Type: Contract Town/City: London City
A leading Lloyd's syndicate has a new and exciting opportunity for an IT Service Operations Manager to work within a hybrid team of in house and outsourced colleagues, collaborating as part of the wider IT team to effectively design, transition, deliver and improve IT Servic...
Salary: £80,000 to £85,000 Per Annum Sector: Technology and Change, Development, Infrastructure Contract Type: Permanent Town/City: London City
A growing Lloyd's international insurer has an exciting new opportunity for a Technical Product Manager to work alongside a Product Owner and manage an offshore team of developers, testers and Business Analysts developing exciting and innovative new products.
Salary: £75,000 to £85,000 Per Annum Sector: Technology and Change, Change & Transformation, Development, Testing Contract Type: Permanent Town/City: London City
An exciting opportunity for an IT Development and Test Manager to join a growing global insurer and be responsible for the day-to-day management and operations of the Development and Test capabilities. Managing a team of FTE and outsourced resources, the individual will ensure th...
Salary: £80,000 to £85,000 Per Annum Sector: Technology and Change, Development, Testing Contract Type: Permanent Town/City: London City
A fantastic opportunity for an IT Governance Analyst to join a growing international insurance business and perform various governance-related activities in order to comply with regulation, satisfy auditors and follow good operational practice.
Salary: £45,000 to £55,000 Per Annum Sector: Analysis, Technology and Change, Business Analyst, MI Analyst, Data & Analytics, Change & Transformation Contract Type: Permanent Town/City: London City