IT Database Administrator

Kennedys; Birmingham; On-site; GBP 40,000 - 60,000; Full time

Job summary

A global law firm is seeking an IT Database Administrator to ensure the reliability and security of critical databases. The role involves collaborating with diverse teams to design and implement database solutions, focusing on performance and data integrity. Candidates should possess experience with Microsoft SQL Server and Azure technologies, and understand performance tuning methodologies. You will play a key role in supporting the firm's IT infrastructure while adhering to best practices in security and data management.

Qualifications

• Proven experience managing technical and support teams in a fast-paced environment.
• Experience with Azure SQL and Microsoft SQL Server.
• Strong focus on database security, performance, and scaling.

Responsibilities

• Work as part of a team to provide coverage for critical systems.
• Maintain understanding of supported applications and database architecture.
• Develop and implement bespoke database solutions.

Skills

Managing technical and support teams

Microsoft SQL Server

Database security

Performance tuning

Power BI analytics

Data Factory

Tools

Azure SQL Database

Transactional SQL

Extended Events

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.

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.

About Kennedys

Kennedys is a global law firm with expertise in dispute resolution and advisory services. With over 2,750 people worldwide across 47 offices in the UK, Europe, Middle East, Asia Pacific and America we have some of the most respected legal minds in their field.

Our lawyers handle both contentious and non-contentious matters, and provide a range of specialist legal services, for many industry sectors but we have particular expertise in litigation and dispute resolution, especially in defending insurance and liability claims.

We're a fresh-thinking firm, and we're not afraid to bring challenging new perspectives to the table way beyond the traditional realm of legal services. We empower our clients with a diverse range of ideas, tools and technology to make their lives easier, as well as delivering exceptional results, every time.

We welcome high-performing lawyers, business services professionals, secretaries, graduates and apprentices to join our rapidly expanding global firm. Whatever your role at Kennedys, you'll be involved in exciting and stimulating work, where your input will make a difference.

Our values are at the core of who we are and what make us a great firm to work with and for.

We strive to celebrate diversity,empower our people and ensure everyone can bring their authentic selves to work.We've created a culture based on client service, professional excellence, hard work and trust, where diversity, equity and inclusion (DE&I) is a key priority.

We recognise that many of our people want to work for an employer that is aligned to their values, which is why we are building an inclusive culture, decarbonising our operations and supporting our people to thrive at work.Our people are the key to driving this change and helping us to make a difference to our clients, our people and the communities in which we live and work.

Kennedys is an equal opportunities employer and is committed to ensuring our recruitment processes are as inclusive as possible. We expect all employees to be aware of and comply with all relevant policies and procedures within their jurisdiction, including those relating to Information Security, Data Protection and Quality Management, refer any breach promptly to Risk & Compliance and to complete all mandatory training when requested.