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