Company

CanopiusSee more

addressAddressManchester, Greater Manchester
salary SalaryFull-time
CategoryIT

Job description

Role Overview

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

Our benefits

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

Core Responsibilities

  • 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.
  • Administering and managing the SQL Server Database estate both on prem and in the 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.
  • Day to day BAU of the DBAs
  • Coordinate with project teams

Skills & Experience

  • Good technical knowledge of SQL Server 2012 to 2022 and cloud technologies e.g. Azure SQL.
  • Previous experience in a similar position
  • Good scripting skills in (T-SQL, PowerShell) also desirable
  • Good understanding of Data warehousing setup and support.
  • 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, partitioning and ETL
  • Predict potential issues both in the Database infrastructure and workload.
  • Beneficial not essential,
  • Experience within Finance / Insurance industry and tols like RMS, Remetrica etc.
  • Good understanding of Storage and virtualisation technologies

Personal Qualities

  • Willingness and ability to innovate.
  • Good communication skills with end users and fellow IT staff members.
  • Proven ability to automate builds and repetitive tasks
  • Flexibility to broaden and develop skills in any area as required.
  • The ability to prioritise projects and tasks.
  • Show a willingness to learn about latest technologies in the database space.
  • Workload management.

Please note this role will require being on call during weekday evenings and weekends on a rotated basis.

About Canopius

Canopius is a global speciality (re)insurer with underwriting operations in Australia, Bermuda, Singapore, the UK and US. We are privately owned and one of the leading insurers in the Lloyd’s of London insurance market.

With a growing demand for data, analytics and research, we are investing in a new global Canopius Tech and Data Hub in Manchester. Underpinning our growth and expansion ambitions are our technology capabilities, with increased investment into insuretech, analytics and research. We are recruiting a diverse group of data and technology talent across all levels of experience.

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. 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.

Refer code: 2610869. Canopius - The previous day - 2024-01-24 19:42

Canopius

Manchester, Greater Manchester
Popular Junior jobs in top cities
Jobs feed

Key Stage 2 Teaching Assistant

Exclusive Education

Sefton, Merseyside

£86 - £90/day

EYFS Class Teacher

Gsl Education - Leicester

Leicester, Leicestershire

Year 6 Teacher

Wayman Education

Humberstone, Leicestershire

£30,000 - £46,525/annum

Primary Class Teacher

Vetro Recruitment

Cardiff, Wales

£157 - £170/day

SEN Class Teacher

Positive Futures Recruitment

Pilning, Gloucestershire

£30,000 - £44,870/annum

Qualified Teacher

Twenty 4 Seven

Cardiff, Wales

£150 - £175/day

CNC Machinist/Programmer (Training into Instructor/Teacher)

Rise Technical Recruitment

Bristol, England

£30,000 - £36,000/annum Training + Progression + Holidays

Fluent Welsh Teachers

Teacheractive

Rhondda Cynon Taf

£157/day

Primary Teacher

Educated Recruitment

Broomhill, Bristol

£100 - £180/day

KS1 Class Teacher

Smile Education Recruitment

Coleshill, Warwickshire

£150 - £180/day

Share jobs with friends

Related jobs

Junior Dba

Junior Production Planner

Westwood Recruitment Ltd

£26,000 - £30,000/annum

Bredbury, Greater Manchester

just now - seen

Junior Auto Electrician

Microlise

Manchester, Greater Manchester

13 hours ago - seen

Junior Protection advisor

Merje

£27,000 - £55,000/annum

Sale, Greater Manchester

2 days ago - seen

Clinical Negligence Junior Associate

Sacco Mann

£40000 - £46000 per annum

Manchester, Greater Manchester

2 weeks ago - seen

Graduate / Junior Research & Development Engineer

Torque Consulting

£27,500 - £32,000/annum

Astley, Greater Manchester

2 weeks ago - seen

Junior Graphic Designer

Morson Talent

£23,000 - £26,000/annum

Salford, Greater Manchester

3 weeks ago - seen

Junior Mechanical Engineer

Chevron Recruitment

£12/day

Broadheath, Greater Manchester

3 weeks ago - seen

Junior Service Engineer, Medical X-Ray Systems

Trs Consulting

Manchester, Greater Manchester

3 weeks ago - seen

Junior Data Governance Manager

Kingdom People

Manchester, Greater Manchester

3 weeks ago - seen

Junior Business Support Officer

Office Angels

£23,000 - £25,000/annum

Manchester, Greater Manchester

3 weeks ago - seen

Junior Azure Architect

Canopius

Manchester, Greater Manchester

3 weeks ago - seen

Junior Pig Farm Stockperson

Roadhogs Recruitment Ltd

£25,000 per year

Wigan, Greater Manchester

4 weeks ago - seen

Junior Business Support Officer

Office Angels

£23,000 - £25,000 Annual

Manchester, Greater Manchester

4 weeks ago - seen

Junior Account Manager

The Portfolio Group

Competitive

Manchester, Greater Manchester

4 weeks ago - seen

Junior Quantity Surveyor

Time Recruitment Solutions Ltd

£25,000 - £30,000/annum plus car allowance and benefits

Oldham, Greater Manchester

a month ago - seen

Admin Officer

Lowton Junior And Infant School

£18,588 a year

Wigan, Greater Manchester

a month ago - seen

Junior PA - Legal

Gibson Hollyhomes

£23,000 - £26,000 Annual

Manchester, Greater Manchester

a month ago - seen

Junior Clinical Fellow - Cardiology | Bolton NHS Foundation Trust

Bolton Nhs Foundation Trust

Not specified

Farnworth, Greater Manchester

a month ago - seen