Job Description

Group / Team

Information Technology

Working pattern

Full Time

The opportunity

The Opportunity:

Primary Objectives:

• To provide outstanding technical expertise in the management, support and continuing improvement of Herbert Smith Freehills core systems with a specific focus on the firm\'s SQL Server environment

Key internal relationships:

• IT Production Support Teams
• Applications & Development teams
• Support Services team
• Business Projects team

Key external relationships:

• Technology Consultants
• Software Vendors

Hours:

• The Production Support team provide cover from 08:00 -18:00 Monday to Friday across an 08:00 -16:00 and 10:00 -18:00 shift pattern
• On occasion participation in global team and project meetings outside of these hours will be required.
• 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

Key responsibilities:

• Installation, Administration and Maintenance of SQL Server environments - versions 2012-2019 & Azure/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 PROD -

TEST/DEV/SSIS packages for Bi-Weekly/End of Month 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-a-lone/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
• Contribute to the success of Production Support colleagues through teamwork and cooperation in all day to day activities
• Contribute to the success of other IT teams by providing timely assistance and advice as required
• Keep management updated on the status of the technology, projects tasks at hand

Skills, experience and qualifications

The Opportunity (continued):

Key Performance Indicators:

• Database administration, maintenance and performance analysis
• Responding to automated alerts in a timely manner.
• 3rd level support and maintenance of applications
• Liaising with service providers as required
• The ability to clearly and concisely communicate and document technical information is required as part of the role
• Quality of communication and teamwork across IT teams
• Demonstrated rapport with Herbert Smith Freehills users

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 within project delivery teams 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.

Group / Team description

Group/Team description:

Innovative, efficient and effective IT systems are essential to the successful operation of a global law firm like Herbert Smith Freehills. The information technology team keeps our global team of lawyers and Business Services staff connected, whether we\'re in the office or on the move.

Information technology is responsible for everything information systems-related. That includes:

• technical support: IT helpdesks, asset management (including laptops and mobile devices) and technical training
• infrastructure: networks and systems, servers (real and virtualised), disaster recovery, business continuity and IT security
• innovation and technology: driving the increasingly important adoption of technology in new ways
• development: designing and acquiring business applications.

While the roles within the division may vary, all involve providing the very best services and systems. You may also have the opportunity to work on challenging projects across the firm.

Role type

Business Services

Contract type

Permanent

-

Herbert Smith Freehills

Herbert Smith Freehills