Junior Database Administrator

Canopius; Manchester; Hybrid; GBP 30,000 - 40,000; Full time

Job summary

A leading global specialty lines (re)insurer seeks a Junior DBA to manage their SQL Server database estate. The role involves day-to-day support, administration, and collaboration with various teams to ensure high availability and performance of the database infrastructure. The company offers a comprehensive benefits package, including hybrid working and health insurance.

Benefits

Hybrid working

Competitive salary

Non-contributory pension

Discretionary bonus

Health and dental insurance

Qualifications

• Knowledge of recent SQL Server versions and cloud technologies.
• Previous experience in a similar position.
• Understanding of scripting skills in T-SQL and PowerShell.

Responsibilities

• Administering and managing the SQL Server Database estate.
• Ensuring high availability of the database infrastructure.
• Providing database support and advice to other teams.

Skills

SQL Server

T-SQL

PowerShell

Communication

Tools

Azure SQL

SSIS

SSRS

SSAS

Job description

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 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, developers, and end users.

Responsibilities

• Administering and managing the SQL Server Database estate both on-premises and in the cloud (Azure).
• Assisting with day-to-day management of the database architecture covering live and non-live environments.
• Ensuring high availability of the database infrastructure to minimize the duration and impact of outages.
• Maintaining a high level of service delivery for incidents, requests, and changes.
• Providing database support and advice to other Infrastructure teams, developers, and end users.
• Maintaining database security standards across the SQL Server database estate.
• Collaborating with peers in other technology teams to find optimal solutions.
• Participating in on-call support rota.
• Managing day-to-day BAU activities of the DBAs.
• Coordinating with project teams.

Skills and Experience

• Knowledge of recent SQL Server versions and cloud technologies, e.g., Azure SQL.
• Previous experience in a similar position.
• Understanding of scripting skills in T-SQL and PowerShell is desirable.
• Working knowledge of continuous Integration or Configuration Management tools.
• Ability to demonstrate performance diagnosis and tuning techniques across the stack, including database internals, OS, storage, 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, including compression.
• Ability to predict potential issues in database infrastructure and workloads.
• Good communication skills with end users and IT staff.
• Ability to automate builds and repetitive tasks.

About Us

Our Benefits

We offer a comprehensive benefits package focusing on overall wellbeing, including hybrid working, a competitive salary, non-contributory pension, discretionary bonus, health and dental insurance, and other benefits supporting financial, physical, social, and psychological health.

About Canopius

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

We foster a positive culture that encourages employees to bring their whole selves to work, enabling personal and professional growth, and building a profitable, sustainable business.

Based in the City of London, our hybrid working model supports flexibility. We are committed to equal employment opportunities and a work environment free of discrimination and harassment. We welcome applicants from diverse backgrounds and make reasonable adjustments during recruitment and employment. Please inform us if you need accommodations.