SQL Database Specialist

Tender description

Summary of the work The candidate is required to carry out SQL Database Administration and Developer on a secure (private cloud) and help with migration and setup on Azure. Specialist role Developer Expected Contract Length 12 months, review to extend by another year after month 11 of contract Latest start date Friday 24 December 2021 Maximum Day Rate Annual contract £115k Early Market Engagement None Who Speclialist Work With The Support team is embedded with the Analytical community and serves other external departments, but all users are Analysts (Statisticians, Economists, Operational Researchers and Social Researchers). What Specialists Work On 1. Using best techniques and technology to load and extract data into cloud-based virtualised MS SQL Server to and from different data sources. 2. Monitoring MS SQL servers so that they are running in the most efficient state. 3. Support others to develop their own SQL capabilities, including T-SQL and maintenance. 4. Ensure data stored in SQL server is held securely and stored efficiently. 5. Develop technology paths so other databases and software packages to access SQL Server 6. Advising users on how to get the best out of SQL databases Skills & Experience • Previous experience of database administration of MS SQL 2016 or later - 6 points • Previous experience of using SQL Server Integration Services - 6 points • Previous experience of at least one scripting language, such as VB Script, Python, PHP or a similar language - 3 points • Previous experience of working with working data at "OFFICIAL-SENSITIVE" level - 6 points • Previous experience of working with Energy Data - 3 points • Previous experience of working on a Cloud Environment - 3 points • Previous experience of working with PostgresSQL or later - 3 points Nice to Haves • Previous experience of Linux OS, such Ubuntu 16 (or later) or anything similar - 3 points • Previous experience of designing web pages - 3 points • Previous experience of MS Excel and MS Access 2010 or later - 3 points • Previous experience of designing databases - 3 points Work Location Westminster, London Working Arrangments Hybrid working, London Office and working from home. Security Clearance Willing to undergo Security Clearance (SC). No. of Specialists to Evaluate 3 Cultural Fit Criteria • Able to work in a small multi-skilled team (less than 10) - 6 points • Willing to help develop other colleagues' capability - 6 points • Always be willing to help users - 3 points • Willing to working within the existing toolset - 3 points • Able to communicate complex solutions in a simple manner for non-technical users - 3 points Assessment Method • Reference • Interview Evaluation Weighting Technical competence 40% Cultural fit 20% Price 40% Questions from Suppliers 1. 1. Is there an incumbent currently in this role? Yes