Senior Database Administrator

Job Introduction
DAC Beachcroft is looking to appoint a Senior Database Administrator to join our busy IT Systems team in Bristol. With a significant investment in people, technology and training, our IT environment is fast paced, busy and rapidly growing. We are looking for enthusiastic and innovative people with ideas to contribute and improve the service we deliver to the business.

Main Responsibilities
- Architect/Design (Infrastructure), Implement, configure, and maintain database instances, replication, backup, partitions, storage, security and access
- Manage monitoring and optimisation of system performance
- Document and maintain configuration for the design, routines, processes and tools
- Identify areas for improvement. Recommend solutions based on the technical analysis of business requirements
- Design and manage production and non-production environments
- Administration of Microsoft BI suite (SSIS, SSRS & SSAS)
- Operate in a highly skilled and respected technical team controlling the delivery of key components for database administration, implementation and upgrade projects
- Manage the ticket system for the database requests
- Lead ongoing 3rd line support activities related to the firm's Database Infrastructure, taking ownership of and escalating to Infrastructure and Problem Managers when required
- Review capacity requirements and manage capacity planning for database systems
- Ensure that IT continuity plans, technology and tools safeguard data integrity, security and access
- Taking steps to guarantee the integrity and availability of our data
- Mentor and transfer knowledge and skills to the Infrastructure team
- Working with Data, Development and MI Teams to influence and advise on the best solutions
- Input to technical strategy and architecture, project engineering design and documentation
- Evaluation of potential solution providers, selection of preferred supplier
- Liaise and work with development ,and production support teams to achieve the best solution
- Develop implementation test plans ensuring functionality, performance, availability and continuity are delivered to specification, policies and best practices
- Act as technical specialist to project teams
- Evaluate change control requests for impact
- Ensure compliance with DAC Beachcroft's information security policies, standards and procedures in the day-to-day delivery of IT services
- Support information security risk assessments within IT Service Delivery by making resources available where appropriate
- Proactively identify and report security risks to the Information Security team
- Advising on and implementing security best-practice
- Proven DBA experience in MS SQL environments with extensive knowledge of Transact SQL
- Strong experience of database infrastructure design/architecture
- Strong experience of Azure SQL and elastic pools
- SQL Clustering / Always On Availability Groups /SQL Server Enterprise
- Ability to design database infrastructure as part of a complex multi-platform environment
- Experience of a Cloud technology (Azure/Aws)
- Solid skills in database performance factors, monitoring tools and tuning procedures
- High availability environment experience and disaster recovery
- Stay up to date with latest developments and industry best-practice
- Experience of a Cloud technology
- Good understanding of server virtualisation technologies
- Good organisational, multi-tasking, and time-management skills
- Must be keen for a new experience, responsibility and accountability as well having a good eye for detail
- Good inter-personal skills and the ability to work on own as well as a team player
- Ability to be flexible and work analytically in a problem-solving environment
- Knowledge of ITIL (v3) service management principles

About The Company
We are a leading international legal business with over 2,500 colleagues and a diverse range of capabilities. We have 11 offices in the UK as well as offices in Dublin, Madrid, Paris, Singapore, Chile, Colombia, Mexico and Miami. We also have associations/alliances with firms in Malaysia, Brazil, Peru, Argentina, Central America, the USA, Australia and Germany.

We are a broad-based commercial firm with a strong heritage in insurance, health and real estate. This is complemented by a fast-growing Business Advisory capability. We represent a wide range of clients, ranging from household names to government departments and NHS bodies. We act for all of the UK’s top-ten insurers, we are market leaders in the provision of strategic, commercial and regulatory advice to providers and commissioners in the health sector, and in real estate we advise all of the UK’s top-12 housebuilders.

We have an impressive legal pedigree, with 142 Chambers UK 2021 practice area and individual lawyer rankings. In Legal 500 UK 2021, the firm received a top tier ranking for 37 of its practice areas, and 58 DACB lawyers were singled out in the ‘Leading Individual' rankings.

Our su