IT Database Administrator

Kennedys Law LLP; Chelmsford; On-site; GBP 45,000 - 60,000; Full time

Job summary

A legal services firm is seeking an experienced IT Database Administrator to ensure database reliability and security in Chelmsford and other locations. Ideal candidates should have a strong background in Microsoft SQL Server and Azure, along with experience in managing critical systems. This full-time role entails collaborating with teams to enhance database designs, perform analytics, and provide third-line support. Competitive compensation and support for applicants are provided.

Qualifications

• Proven experience managing technical and support teams in a fast-paced, high-pressure environment.
• Experience with Microsoft SQL Server and Azure cloud services.
• Knowledge of performance tuning methodologies and troubleshooting.

Responsibilities

• Provide adequate coverage for all critical systems across the business.
• Maintain understanding of supported applications and their functionalities.
• Design, develop, and support custom database-level solutions.

Skills

Managing technical teams

Microsoft SQL Server

Azure SQL Database

Performance tuning

Data analytics support

Tools

Azure Data Factory

Power BI

Job description

Kennedys is looking for a IT Database Administrator to join our IT team.

IT Database Administrators are responsible for ensuring the reliability, efficiency, and security of our critical databases and applications. This role involves collaborating with various stakeholders, maintaining a thorough understanding of the software architecture, and influencing database design to support business continuity and disaster recovery strategies. This includes also managing supplier relationships and providing third-line support to colleagues and the wider business.

Open to locations - Chelmsford, Birmingham, Manchester and Sheffield.

Team

Kennedys IT team is responsible for delivery of a responsive, effective and timely IT support service to the firm's employees and clients. They devise and implement operational processes and procedures in order to provide reliable and available IT systems to the firm.

Key Responsibilities

• Work as part of a team to provide adequate coverage for all critical systems across the business.
• Maintain a comprehensive understanding of the functionality provided by supported applications and their use within the organization.
• Understand software architecture for selected applications to influence database architecture and design for efficiency and reliability.
• Provide database design specifications and develop/implement solutions as required.
• Design, develop, and support bespoke database-level solutions, including interfaces, data extracts and integrations with other applications.
• Extract, transform and maintain data to support data analytics and reporting needs
• Work with internal and external teams to advise and assist in performance tuning for both internally and externally facing systems, ensuring optimal performance and user experience

Required Experience

• Proven experience managing technical and support teams in a fast-paced, high-pressure environment, with an emphasis on business-critical systems.
• Microsoft SQL Server On-Premises, Azure SQL Virtual Machine, Azure Managed Instance and Azure SQL Database.
• Experience of managing databases, focusing on security, performance, scaling and cost optimization.
• Implementing and maintaining backup, database integrity checks and index maintenance jobs.
• Configuring custom integrations mainly using Transactional SQL, function and Stored procedure.
• Familiar with Blocking, Caching and Wait Statistics methodologies when troubleshooting performance.
• Using Extended Events and Query Store.
• Analysis and assessing datasets used by Power BI reports.
• Ingesting data into Microsoft Fabric using Azure Data Factory.

Please let us know if you require any additional support or adjustments to be made in order to submit your application to Kennedys.

*where a level of experience is indicated, this is a guideline only and represents the amount of time we would usually expect a candidate to accumulate the requisite level of experience. This does not preclude applications from candidates with more or less experience.

Job Details

• Seniority level: Mid‑Senior level
• Employment type: Full‑time
• Job function: Information Technology
• Industries: Law Practice, Legal Services, and Alternative Dispute Resolution

Referrals increase your chances of interviewing at Kennedys by 2x.