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 of 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.
#J-18808-Ljbffr