SQL Developer (MS SQL Server)

TL;DR

SQL Developer (MS SQL Server): Design, development and management of high quality, efficient solutions using T-SQL and related tools with an accent on data cleansing, reconciliation, and database performance. Focus on writing complex scripts for data manipulation, optimizing SQL code, and maintaining REST APIs.

Location: Bromley, England, United Kingdom. On-site, Remote. BPSS and Enhanced DBS checks required as minimum.

Company

Provider of school management software solutions.

What you will do

• Design, develop, and maintain scaled solutions for data cleansing and reconciliation using MS SQL Server T-SQL.
• Manage MS SQL Server database environments including backups and recoveries in test and production.
• Write complex scripts for customer data processing and generate ad hoc reports.
• Troubleshoot issues in live production environments and liaise with stakeholders for requirements.
• Assist in REST API development and maintenance.
• Analyse and optimise database objects, functions, stored procedures, and perform performance tuning.

Requirements

• 3+ years of SQL Developer experience and administrating/supporting MS SQL Server 2017+ in large-scale environments.
• Substantial experience in SQL programming, data modelling, management, and manipulation.
• Good knowledge of code management and version control (GIT).
• Basic knowledge of C# and ASP.NET programming.
• Basic experience accessing REST APIs.
• Excellent teamwork, communication, documentation, and time management skills. Logical approach to task prioritisation and working within project timelines.

Culture & Benefits

• Work within the development team reporting to the Database team Manager.
• Collaborate with internal stakeholders and third parties on projects.
• Structured approach to time management and deliverables.