Database Administrator

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.