Junior DBA

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

Job summary

An established industry player is looking for a Junior DBA to join a dynamic team responsible for managing SQL Server databases. In this exciting role, you will support the full SQL Server technology stack, ensuring high availability and performance while collaborating with various teams. Ideal candidates will have a solid understanding of SQL Server, cloud technologies, and scripting skills. This is a fantastic opportunity to grow your DBA skills in a supportive environment that values innovation and continuous learning, making a significant impact in the technology landscape.

Qualifications

• Knowledge of SQL Server and cloud technologies like Azure SQL.
• Experience in a similar DBA position with scripting skills.

Responsibilities

• Administer and manage SQL Server Database estate on-prem and in cloud.
• Ensure high availability of database infrastructure and support.

Skills

SQL Server

T-SQL

PowerShell

Database performance diagnosis

Continuous Integration

Configuration Management

Database security standards

Data migration

Tools

Azure SQL

SSIS

SSRS

SSAS

Job description

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:

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

Minimum Requirements:

• Knowledge of SQL Server recent version and cloud technologies e.g. Azure SQL.
• Previous experience in a 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.
• Predict potential issues both in the Database infrastructure and workload.
• Beneficial not essential: Experience within Finance / Insurance industry and tools like RMS, Remetrica etc.
• Good understanding of Storage and virtualisation technologies.

Personal Qualities:

• Interest in DBA skills and career.
• 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 the latest technologies in the database space.

Job Info

• Job Identification 207
• Job Category Information & Technology
• Job Schedule Full time
• Locations WeWork, Manchester, UNITED KINGDOM, M2 3DE, GB