SQL Server Performance Specialist

Role Title: Sharepoint SME Duration: contract to run until 31/03/25 Location: Salisbury, hybrid 2 days per week Rate: £519.50 Umbrella Clearance: Must be SC Cleared and DV Clearable. Must be a British Citizen Key Skills/ requirements Establishing (using existing documentation and interviews of staff) and writing new documentation for the existing architecture of the Sharepoint or .Net estate within DSTL. Establish (using existing documentation and interviews of staff) the interface map related to the Sharepoint or .Net Estate, criticality and support model for the apps. Establish and document (using existing documentation and interviews of staff), the database architecture liaising and working with the DBA SME. Establish and document (using existing documentation and interviews of staff), the current and to be backup approach and data retention approaches (and whether aligned to data retention policies) - working with the DBA SME Establish and document (using existing documentation and interviews of staff), backup and restore test approach Contribute to development of the KT plan through review of foundation knowledge sessions suggested by the incumbent. Attend KT sessions and document knowledge provided by the incumbent team through foundation KT. Establish and document (using existing documentation and interviews of staff), current monitoring and how this feed into an Event and Incident Management flow Establish and document (using existing documentation and interviews of staff), the Service Continuity Plan for Sharepoint or .Net estate Establish and document (using existing documentation and interviews of staff) how access is managed Establish and document (using existing documentation and interviews of staff) existing environments (including lower environments) and how data is managed and alignment to data anonymisation policies Establish and document (using existing documentation and interviews of staff) where software and configurations are stored and how items are migrated through environments to Live (not the Change process rather the tooling and environment flows) Establish and document (using existing documentation and interviews of staff) whether any of the Sharepoint or .Net estate would be classed as "evergreen" Establish and document (using existing documentation and interviews of staff) the stakeholders and knowledge centres (people), the Tier of the Applications and existing hours of Support Establish and document (using existing documentation and interviews of staff) an operations manual for the Sharepoint or .Net Estate Establish a skills matrix required for staff to support the existing Sharepoint or .Net estate. Store all relevant documentation (defined by you - or existing) in a central organised repository (this may exist today, if not this will need to be established) Complete the Application Database - detailing all modules and other details using the template within the data room Identify any risks and add to the Risk Register for the Sharepoint or .Net - highlighting any risks (technical, people or tools) Establish a Continuous Improvement Plan based on the above Develop and add relevant information for a Technical Roadmap for the Sharepoint or .Net (including core, interfaces, patches and databases) Review existing and available ADM / automation tooling as part of the technical roadmap identifying actions which can drive improved monitoring / productivity Review the ITSM tooling (and other repositories) to establish the Configuration Database situation (are CIs in place and relatable)? Establish what action is needed. Review the existing capacity management processes and establish (as part of the Continuous Improvement Plan - improvements in measurement and automation) Establish and document licensing position and how these are managed Work with the Transition Manager, existing team and SMEs to meet the foundation requirements (as above) and as identified through the Transition Lead on the transfer of the existing apps sharepoint site from the incumbent and to develop it to deliver the basis of the Apps database and Apps Run book All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!