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