SQL Developer/Analyst
Work within the database development team reporting to the Database and Migration teams manager.
-
Responsible for design, development and management of high quality, efficient and effective solutions in Microsoft SQL Server T-SQL and related tools to support and extend data migration projects.
-
Optimise database performance by identifying bottlenecks, fine-tuning queries, and implementing best practices to enhance the efficiency of internal systems and improve response times.
-
Analyse and cleanse production-level data to ensure its integrity, accuracy, and consistency, using data validation techniques.
Role Responsibility
-
Analyse data to support data cleansing and reconciliation activities.
-
Develop complex queries for data extraction, reporting, and analysis.
-
Work closely with non-technical stakeholders to define and interpret technical requirements.
-
Responsible for identifying issues with the data, data correction, and ensuring the accuracy of the data.
-
Perform data validation as part of an onboarding Migration process.
-
Help manage data conversion activities, ensuring that data structures are appropriately translated into the target format.
The Ideal Candidate
-
The ideal candidate will have substantial experience of SQL programming and an excellent knowledge of the techniques and the functionality and capabilities of MS SQL Server 2017 and above.
-
A strong background in data management and manipulation, code management and version control (GIT) is also important, as is having good attention to detail.
-
Capable of working through problems independently and liaising with team members to find quality solutions.
Your job will involve
-
Writing complex scripts for data manipulation and management report generation
-
Export/Import of data
-
Data conversion/migration
-
Data correction
-
Database object creation (Functions, Stored Procedures, Tables, etc)
-
Performance tuning of new and existing code
-
Analyse SQL code for potential flaws
-
Optimisation and maintenance of existing products
Desired Skills
-
3+ years of SQL Developer experience supporting MS SQL Server Database infrastructures in large-scale environment.
-
Excellent teamwork, communication, and documentation skills
-
Reasonable understanding of OS and Infrastructure / Network layer
- Company
- Bromcom Computers
- Location
- BR2, Bromley Town, Greater London, United Kingdom
- Employment Type
- Permanent
- Posted
- Company
- Bromcom Computers
- Location
- BR2, Bromley Town, Greater London, United Kingdom
- Employment Type
- Permanent
- Posted