SQL DBA - Azure - Insurance - Contract - £500-550 per day (Inside IR35)

Cornwallis Elt Ltd; London; On-site; GBP 100,000 - 125,000; Full time

Job summary

A prestigious insurance company is seeking an SQL DBA for a 6-month contract in London. The successful candidate will be involved in creating, managing, and tuning databases primarily within an Azure environment. This role requires in-depth knowledge of SQL Server as well as experience in cloud database management and developing solutions to enhance system performance.

Qualifications

• Experience in managing multiple databases in a cloud environment.
• Proven skills in database development including SQL views, functions, and stored procedures.
• Ability to work collaboratively with development and support teams.

Responsibilities

• Monitor health of databases and proactively tune performance.
• Develop, implement, and monitor database backups and recovery plans.
• Work with teams to remediate database failures and ensure system reliability.

Skills

Database health monitoring

Azure environment management

Database tuning

ETL technologies

SQL development

Tools

SSIS

SSAS

Power BI

Snowflake

Click Replicate

Job description

SQL DBA – Azure – Insurance – Contract - £500-550 per day (Inside IR35)

My client is looking to hire an SQL DBA on an initial 6 month contract to create, manage, tune, development, and remediate their database estate (currently Sql Server)

The role will include:

• Monitor health of databases.
• Develop database DDL and DML code, including by not limited to functions, views, tables, stored procedures.
• Develop, implement, and monitor database backups and recovery within an Azure environment.
• Work with development and support teams to remediate database failures.
• Proactively tune the databases using maintenance plans.
• Liaise with Managed Service provider to deploy changes to the environment.
• Work in concert with and manage data architect role holder.

Additional tasks:

• The DBA will be responsible for the health and performance of Azure based databases. Working closely with the Head of Applications, the application developers, and support teams, the DBA will be involved in all aspects of database creation, development, support and tuning.
• Experience in managing multiple databases and instances in a cloud environment.
• Experience in developing and remediating database views, functions, and stored procedures.
• Experience in ETL and Analytics technologies (SSIS, SSAS, Click Replicate, Snowflake, Power BI)
• Working for a medium size organisation in a period of rapid change.