Junior DBA

Canopius; Manchester; On-site; GBP 30,000 - 50,000; Full time

Job summary

An established industry player is seeking a Junior DBA to join their skilled team. In this role, you will manage SQL Server databases both on-premises and in the cloud, ensuring high availability and performance. You'll collaborate with infrastructure teams and developers, handle daily management tasks, and support users with database-related queries. This is a fantastic opportunity for someone eager to develop their DBA skills and innovate in a supportive environment. If you're passionate about database technologies and ready to take the next step in your career, this role is for you!

Qualifications

• Knowledge of recent SQL Server versions and cloud technologies like Azure SQL.
• Experience in a similar DBA role with a focus on SQL Server.

Responsibilities

• Administer and manage SQL Server databases on-premises and in Azure.
• Ensure high availability and performance of database infrastructure.

Skills

SQL Server Administration

Azure SQL

T-SQL Scripting

PowerShell

CI/CD Tools

Performance Tuning

Database Security

Data Migration

Job description

Job Description

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.

Responsibilities

The team handles the day-to-day support and administration of the full SQL Server technology stack, including engineering and all related projects. The role involves collaboration with Infrastructure teams, developers, and end users.

• Administer and manage the SQL Server Database estate on-premises and in cloud (Azure).
• Assist with daily management of database architecture for live and non-live environments.
• Ensure high availability of the database infrastructure to minimize outages.
• Maintain high service levels for incidents, requests, and changes.
• Support and advise other Infrastructure teams, developers, and end users on database matters.
• Maintain database security standards across the SQL Server estate.
• Collaborate with peers in other technology teams to find optimal solutions.
• Participate in on-call support rota.
• Perform day-to-day BAU activities of the DBAs.
• Coordinate with project teams.

Qualifications

• Knowledge of recent SQL Server versions and cloud technologies like Azure SQL.
• Previous experience in a similar role.
• Understanding of scripting in T-SQL and PowerShell (desirable).
• Working knowledge of CI/CD and Configuration Management tools.
• Experience with performance diagnosis and tuning across the stack, including internals, OS, Storage, Networks, and SQL Server Query Processor fundamentals.
• Expertise in support lifecycle management of SQL Server SSIS, SSRS, and SSAS.
• Experience managing and migrating large volumes of data, including compression.
• Ability to predict potential issues in database infrastructure and workloads.
• Beneficial but not essential: experience in Finance/Insurance industry and tools like RMS, Remetrica.
• Good understanding of storage and virtualization technologies.

Personal Qualities

• Interest in DBA skills and career development.
• Willingness and ability to innovate.
• Good communication skills with end users and IT staff.
• Proven ability to automate builds and repetitive tasks.
• Flexibility to develop skills across areas as needed.
• Ability to prioritize projects and tasks.
• Willingness to learn about latest database technologies.
• Effective workload management.