Job Description
Job Introduction
Work within the development team reporting to the Database team Manager.
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.
- 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.
- 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
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Information Technology -
Industries
Software Development
Referrals increase your chances of interviewing at Bromcom by 2x
See who you knowSimilar jobs
People also viewed
-
BI Developer - Data Operations and Reporting
BI Developer - Data Operations and Reporting
-
Specialist Power BI Developer
Specialist Power BI Developer
-
Power BI Developer
Power BI Developer
-
Microsoft Fabric BI Developer - Contractor
Microsoft Fabric BI Developer - Contractor
-
Senior Data Analyst
Senior Data Analyst
-
Full Stack Developer
Full Stack Developer
-
ETL Developer (IBM DB2)
ETL Developer (IBM DB2)
-
Senior Associate – Application Support (Finacle)
Senior Associate – Application Support (Finacle)
-
Junior Python Developer | Fund Managment
Junior Python Developer | Fund Managment
-
Finance Data Engineer
Finance Data Engineer