Database Specialist - London, United Kingdom - CNA Hardy

CNA Hardy

Verified Company

London, United Kingdom

1 week ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

Job Profile

Function / Area:
Operations & IT

Reports To:
Application Support Manager

Position Summary

This Database specialist will assist in troubleshooting current SQL server database issues, look at performance improvements, database upgrades, provide support and maintain SSIS and SSRS code.

This is not a production support role but will require excellent knowledge of SQL Server, SSIS and SSRS.

Strong communication skills are required as the Database Specialist works closely with our internal IT team and external teams. External teams include Managed Service Providers, Vendors and Enterprise IT teams.

Key Responsibilities

Work with technical teams to look at improving current database systems and environments.
Evaluate and understand all SSIS packages and look at ways to improve and standardize the code/functions.
Document all SSIS and SSRS environments including how they are accessed.
Suggest ways to improve systems with new SQL features.
Provide level 2 support and guidance to MSP support teams as needed.
Work with external IT teams as part of larger projects.
Able to manage their own individual projects efficiently and to schedule with mínimal oversight.

Skills, Knowledge & Abilities

DBA experience including standard DBA functions such as troubleshooting performance issues, tuning, ensuring that the SQL environment is set up as per best practice
Define a set of standards for databases and ensure that they are rolled out to all systems
Create and execute SQL Queries, Functions and Stored Procs on SQL Server 5+ years' experience
SSIS experience with writing and updating SSIS packages
SSRS experience with updating and creating new reports.
Upgrading SQL Server databases
Design and tune SQL Queries
Profile SQL Statements for any performance issues
Working knowledge of Dev tools like Visual Studio, GIT and Jira
Experience in an Agile environment
Expert Teamwork and cooperation ability to work effectively with business and IT teams to achieve goals
Excellent written and verbal communication skills

Self-Starter

Ability to work independently and take ownership
Detail oriented with strong planning and organization skills
Experience working with Managed Service Providers and external development teams
Problem solving understand issues/problems and provide alternate solutions in a timely manner
Insurance industry experience
Experience with Cloud technologies

Company Description
CNA Hardy is a leading specialist commercial insurance provider for clients within the Lloyd's and company markets. We are part of CNA Financial Corp, the 8th largest U.S. commercial property and casualty insurance company. Established in 1897, CNA has approximately 7,000 employees, serving businesses and professionals in the U.S., Canada and Europe.

We offer a wide range of products and services, providing a superior suite of insurance solutions that any organisation conducting business requires.

CNA is an equal opportunity employer