Data Migration: o Design, develop, and implement SQL scripts as part of the project data migration processes.
O Ensure data integrity and consistency throughout the migration process.
O Cleanse, transform, and load data from the legacy, on-premise housing system (Capita Open Housing) into the on-premise, NEC Housing System that is being implemented.
Design and create objects such as tables, stored procedures and ETL packages using SSIS.
Responsible for the quality of the design, build, test, implementation and support solutions in MSSQL Server, SSIS and Tableau, packaging and delivering new service offerings developed by the developer or peers is performed in line with all relevant guidelines and data protection regulations.
Engage middle manager and peer level staff across the group and promote the appropriate development of business analytics usage within the respectivedepartments.
Venn Group is currently working with an NHS London Trust who are recruiting for a SQL Developer/DBA who is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities.
Agency Reference Number: J81531
Job Responsibilities
Responsible for the performance, integrity and security of the databases - include planning, development and troubleshooting.