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 & 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 ).
- 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.