Job Description
Description
Job Introduction
Work within the development team reporting to the Database team Manager.
Responsible for design, development and management of high quality, efficient and effective solutions in Microsoft SQL Server T-SQL and related tools.
Manipulate customer data in a production environment, taking the necessary precautions.
Provide technical knowhow on projects and work with third parties to provide information about the Bromcom database structure.
BPSS and Enhanced DBS checks required as minimum.
Role Responsibility
Responsibilities will include designing, developing, and maintaining appropriately scaled, effective solutions to support data cleansing and reconciliation activities using Microsoft SQL Server T-SQL and related tools.
The role requires you to manage MS SQL Server database environments that support data backups and recoveries in test and prod environments.
Demonstrating a logical and structured approach to time management and task prioritisation. Working within project timelines and requirements. Being able to organise own time, schedule tasks for completion and deliver work to that schedule.
Assist in the development effort behind our REST APIs.
Write complex scripts for data manipulation to support customer data processing and reconciliation activities.
Liaise with internal stakeholders to gather requirements, provide updates, and support business needs.
Troubleshoot and resolve issues relating to live customer data within production environments.
Generate ad hoc reports in response to internal and customer requests.
Analyse database objects including Functions, Stored Procedures, Tables, and other SQL Server components.
Review and analyse SQL code to identify potential flaws, inefficiencies, and areas for improvement.
Maintain and support existing REST web APIs.
Optimise and maintain existing database-driven products and solutions.
Perform performance tuning on new and existing SQL code to ensure efficiency and scalability.
Skills and Experience
The ideal candidate will have substantial experience of SQL programming and good knowledge of the techniques and the functionality and capabilities of MS SQL Server 2017 and above
A strong background in data modelling, data management and data manipulation, code management and version control (GIT) is also important, as is having good attention to detail
Have basic knowledge of C# and ASP.net programming
Have basic experience of accessing REST APIs
3+ years of SQL Developer experience and administrating/supporting MS SQL Server Database infrastructures in large-scale environment
Data flow analysis skills
Excellent teamwork, communication and documentation skills
