Job Description

The Role

This is a role for a Junior DBA with database administration knowledge and exposure to join a team of skilled DBAs who are responsible for managing the SQL Server database estate.

The team is responsible for the day-to-day support and administration of the full SQL Server technology stack including engineering and all SQL Server database related projects. The role involves working closely with other Infrastructure teams as well as developers and end users.

Responsibilities

Administering and managing the SQL Server Database estate both on-prem and in cloud (Azure)
Assist with day-to-day management of the database architecture covering live and non-live environments.
Ensuring high availability of the database Infrastructure to minimise the duration and impact of any outages.
Maintaining a consistently high level of service delivery for incidents, requests, and changes.
Providing database support and advice to other Infrastructure teams as well as developers and end users.
Maintain database security standards across the SQL Server database estate.
Working with peers in the other technology teams to find the best solutions.
Participate in on-call support rota.
Day to day BAU of the DBAs
Coordinate with project teams

Skills and Experience:

Knowledge of SQL Server recent version and cloud technologies e.g. Azure SQL.
Previous experience in similar position
Understanding of scripting skills in (T-SQL, PowerShell) also desirable
Working knowledge of continuous Integration or Configuration Management tools
Experience and ability to demonstrate performance diagnosis and tuning techniques in the whole working stack, Database internals, OS, Storage and Networks and SQL Server’s Query Processor Fundamentals
Expertise in the support lifecycle of SQL Server SSIS, SSRS and SSAS infrastructure
Experience in managing and migrating large volumes of data. Compression.
Predict potential issues both in the Database infrastructure and workload.
Good communication skills with end users and fellow IT staff members.
Ability to automate builds and repetitive tasks

About Us

Our benefits

We offer all employees a comprehensive benefits package that focuses on their whole wellbeing. This includes hybrid working, a competitive base salary, non-contributory pension, discretionary bonus, insurances including health (family) and dental cover, and many other benefits to enhance financial, physical, social and psychological health.

About Canopius

Canopius is a global specialty lines (re)insurer. We are one of the leading insurers in the Lloyd’s of London insurance market with offices in the UK, US, Singapore, Australia and Bermuda.

At Canopius we foster a distinctive, positive culture which enables us to bring our whole selves to work to flourish as people, and build a business which delivers profitable, sustainable results.

Based in incredible new offices in the heart of the City of London, Canopius operates a flexible, hybrid working model and is committed to providing an environment that challenges employees to be their best and where everyone's unique contributions are recognised, valued and respected.

We are fully committed to equal employment opportunities for all applicants and providing employees with a work environment free of discrimination and harassment. All employment decisions are made regardless of age, sex, gender identity, ethnicity, disability, sexual orientation, socio-economic background, religion or beliefs, marital or caring status, or any other status protected by the laws or regulations in the locations where we operate. We encourage and welcome applicants from all diverse backgrounds.

We make reasonable adjustments throughout the recruitment process and during employment. Please let us know if you require any information in an alternate format or any other reasonable adjustments.

Insurance Systems Jobs jobs

Junior Database Administrator