Database Administrator

Brimstone Consulting
London

Database Administrator - Legal

Salary: competitive

The Role:

Main Objectives:

  • To provide outstanding technical expertise in the management, support and continuing improvement of the client’s core systems with a specific focus on the firm’s SQL Server environment
  • Manage relationships with key internal and external stakeholders

Hours:

  • Shift patterns that can vary across an 08:00 to 18:00 timeline
  • Team members are expected to participate in an out of hours 24x7 On Call escalation roster
  • Team members are also expected to participate in occasional out of hours support e.g. scheduled changes such as periodic security patching

Main responsibilities:

  • Installation, Administration and Maintenance of SQL Server environments - versions 2012-2019 & Azure also AWS desirable
  • Setup High-Availability as part Disaster Recovery Strategy for the SQL environments, where required. (SQL Failover Clustering, Database Mirroring, and SQL Merge/Transactional Replication)
  • Support for SQL server – Asynchronous/Synchronous replication
  • Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Maintaining Index fragmentation, SQL storage, memory settings, monitoring CPU usage and Disk I/O activity etc)
  • Maintain SQL servers set up with local VMware VMDKs hosted on NetApp presentable storage drives (LUNS)
  • Understand database Backup and Restoration Strategy – RPO/RTO strategy. (Native SQL Backups via SQL Server Agent/Commvault agent based/NetApp snap mirroring)
  • Administration of internal maintenance tasks – SQL Backups/DBCC checks/Index maintenance
  • Database recovery/restore process via manual/automated processes
  • Troubleshoot various issues that are part of day-to-day DBA responsibilities - Remediation of issues raised by incidents internally. (Monitoring SQL alerts, actioning Incident tickets)
  • Management of escalated incidents resulting in Major Incidents/Priority Incidents/Problem tickets
  • Setup Test, Dev and Production SQL Environments (Provisioning/Decommissioning SQL Server 2012-2019)
  • Create Users/Groups and assign permissions based on the level of database access the user/groups require - Individual/Group/Role based (Security)
  • Knowledge of cross connectivity to various data sources - SQL Server/Oracle/Access/Informix/Azure etc. (Security and General Administration)
  • Documenting major changes to the SQL Servers
  • Adherence to strict Change Control process for minor/test and production changes
  • Application of SQL Server Service Packs – Stand-alone/Always-on/Database Mirroring support (General)
  • Monitoring SQL estate for critical Production environments/Analysis of issues/Proactive management of SQL server alerts
  • Support and maintain SSIS/SSRS/Power BI/SSAS – Development/Maintenance/infrastructure
  • Assist the support effort by working to resolve escalated support calls (3rd level) or critical problems

Skills, experience and qualifications:

  • 5+ years’ experience supporting large SQL Server environments including application installation, configuration and integration
  • SQL Server 2012 to 2019 clustering, Data Warehouses and Reporting Services
  • Experience working with and supporting Always On Availability Groups
  • Strong understanding of Disaster Recovery solutions and principles
  • Strong Windows Server operating system skills with exposure to Active Directory and Clustering
  • Exposure to and use of Enterprise Monitoring Tools such as Microsoft System Centre Operations Manager (SCOM)
  • Experience working with Microsoft Azure is highly regarded
  • Strong understanding of VMware virtual server technologies (vSphere / ESXi) would be highly regarded.
  • Strong ITIL experience with Incident, Change and Problem Management
  • Strong awareness of technology trends
  • Experience of working with global project and programmes would be highly regarded
  • Experience of working with Agile SCRUM delivery methodologies would be highly regarded
  • Experience of working within multi skilled Agile Sprint delivery teams (preferable) would be highly regarded

#databaseadministratorjobs, #legaljobs, #databaseadministratorjobslondon, #dbajobs, #dbalegaljobs

Posted 2025-09-01

Recommended Jobs

Asset & Wealth Management - Software Engineer - Associate - London

Goldman Sachs
London

What We Do At Goldman Sachs, our Engineers don’t just make things - we make things possible. Change the world by connecting people and capital with ideas. Solve the most challenging and pressing e…

View Details
Posted 2026-02-21

Senior Manager, Pricing and Commercial Insights

Norton Rose Fulbright
London

Practice Group / Department: Client Financial Decision Support Job Description We're Norton Rose Fulbright - a global law firm with over 50 offices and 7,000 employees worldwide. We provide …

View Details
Posted 2026-03-15

Private Client Tax Specialist

Buckley Consulting
London

Private Client Tax Specialist London (and remote) To c£46,000 + Benefits This independent firm boasts extremely high quality tax clients and has an expanding and hugely successful tax team whic…

View Details
Posted 2025-07-10

Delegated Underwriting Specialist

Harrison Holgate
London

Delegated Underwriting Specialist Location: City of London Salary: Competitive + Bonus + Strong Benefits A leading specialist insurer operating across the Lloyd’s and Company markets is looking …

View Details
Posted 2026-01-18

Multidisciplinary Designer, LONDON Office - Ref: DSGN-LDN-Q1-26

Magnetic London Creative Services Ltd.
London

About Magnetic Magnetic is an independent creative agency with offices in  London  and  Istanbul , working with ambitious global brands and organisations navigating growth, change, and complexity…

View Details
Posted 2026-01-24

Admissions Officer - Independent Girls’ School -...

Marchant Recruitment
London

Admissions Officer – Independent Girls’ School – Kensington, London Start Date: As soon as possible Contract: Full-time, Permanent Salary: Paid to scale School Information This is a…

View Details
Posted 2026-02-21

Educational Psychologist Assessment Only

Lewisham Council
Lewisham, Greater London

Job Category : Senior Interims Location : Kaleidoscope, Lewisham Council Hours Per Week : 35.00 Start Date : Immediate Start Start Time : 09:00 End Time : 17:00 Salary: £384.29 per day…

View Details
Posted 2025-08-29

Head of Adult Safeguarding

Baltimore Consulting
London

Interim Head of Safeguarding £500 – £650 per day (DoE), Inside IR35 3-6 month initial contract London Hybrid – 2-3 days on site per week This local authority is going through a period of tra…

View Details
Posted 2026-03-03

SALARIED GP P TIME ENFIELD TRADITIONAL SURGERY

Dream Medical Limited
North London

PT Salaried GP required in Enfield, North London | Negotiable salary plus MDU and Pension Dream Medical is seeking a PT Salaried GP for 3 sessions a week based in a traditional surgery in North Lon…

View Details
Posted 2025-11-29

Assistant Accountant

Pro-Recruitment Group
London

Assistant Accountant | £40,000 - £45,000 (DoE) | London - Mayfair For one of the worlds most prestigious luxury jewellers based in the heart of Mayfair, we are recruiting an Assistant Accountant. …

View Details
Posted 2026-03-15