Database Administrator

Reference

dba


Sector

Digital Forensics, eDiscovery & Legal


Salary

Competitive


Town/City

London


Contract Type

Permanent

Share this Job

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

About Brimstone Consulting: We specialise in finding highly qualified staff in the following areas:
Forensic Accounting & Fraud - (AML/CTF, Investigation, CFE’s etc.); Legal and LegalTech (E-Discovery, Digital Forensics, EDRM); Big Data and Data Analytics- (MI/BI/CI);InfoSec and Cyber Crime; Audit; Accountancy and Finance; FinTech (Payments etc.);Risk - (Credit, Regulatory, Liquidity, Market, Analysts-SAS, SPSS etc.);Compliance/Corporate Governance ;IT- (full SDLC- BA’s PM’s , Architects, Developers etc.);

Brimstone Consulting acts as an employment agency (permanent) and as an employment business (temporary) - a free and confidential service to candidates. Brimstone Consulting is an equal opportunities employer. Due to time constraints we can only reply to applicants that match our clients’ specifications. We may store applications in our cloud storage facilities that may include dropbox.

 

You may also be interested in...

X2 eDiscovery Project Manager roles Location: London or NI (hybrid) Sector: Legal Sector (international) Managing multiple eDiscovery matters including day-to-day engagement with instructing team members, liaising with stakeholders; partners and associates of the firm. Advis...
Salary: £65,000 to £85,000 Per Annum Sector: Digital Forensics, eDiscovery & Legal Contract Type: Permanent Town/City: London
eDiscovery Senior Co-Ordinator, Remote Working (UK based) Working with a variety of companies and institutions helping them to achieve their objectives by solving their most complex and important legal issues in eDiscovery. Strong client relationships, sector specific approa...
Salary: £45,000 to £50,000 Per Annum Sector: Digital Forensics, eDiscovery & Legal Contract Type: Permanent Town/City: London
Head of eDiscovery job, Location (London 3 days in office - hybrid WFH) Our client is an international firm and the role requires experience of having worked with overseas offices (particularly US offices). You will have both commercial and technical experience. This role i...
Salary: £100,000 to £140,000 Per Annum Sector: Digital Forensics, eDiscovery & Legal, Advisory & Consultancy Contract Type: Permanent Town/City: London
eDiscovery Project Manager London (we have roles in other UK locations and Germany) Our clients are actively looking to increase their eDiscovery teams at AM and Manager levels in particular. This role is with a leading diverse Consultant in one of their practice areas. W...
Salary: £55,000 to £90,000 Per Annum Sector: Digital Forensics, eDiscovery & Legal, Advisory & Consultancy Contract Type: Permanent Town/City: London
THE ROLE You will deliver innovative, technology focused solutions throughout the disputes and investigations processes. You must have a good understanding of the EDRM model and solid eDiscovery (right hand side) experience. Experience of various technologies that can be used wi...
Salary: £45,000 to £60,000 Per Annum Sector: Digital Forensics, eDiscovery & Legal Contract Type: Permanent Town/City: London