Data Migrition - Technical Analyst at CloudStream Global

Job description

To work within the Data migration workstream of the BTP/ERP project, and provide technical assistance in capturing, cleansing, and converting data from legacy systems into the new ERP.

Key Accountabilities:

• To provide the technical capabilities to deliver new data stores for capturing legacy data for cleansing and maintaining the data prior to loading to the new erp system
• To develop cleansing algorithms to aid in the cleansing process
• To develop conversion algorithms, checks/balances and control data, to aid in the conversion process to the new erp system.
• To develop mini applications to allow data to be maintained prior to loading cleansed data into the new ERP system
• Write and maintain programming documentations, document programming problems and resolutions for future reference.
• Develop training guides/cheat sheets to aid the end user to utilise the data migration tools.
• Has the ability to create, implement and monitor database maintenance procedures
• Communicating regularly with internal technical, applications, and operational staff, to ensure the database integrity and security is maintained.
• To provide as necessary any training to the end user to help then use the tools developed for data capture and cleansing.
• To have the technical capability
• To troubleshoot SQL Server service outages.
• To configure SQL Server monitoring utilities, performance monitoring and tuning of Database servers
• To check performance issues and determine the most effective way to address.
• Of SQL database structures, programming and debugging

Skills, Experience & Qualifications

Mandatory:

• SQL databases/programming (.Net)
• In depth knowledge of MS SQL to the latest version.
• Deploy database change(s) through scripts.
• Knowledge of server administration
• Maintain confidentiality with regard to the information being processed, stored or accessed
• Experience with Microsoft products, MSCE/MCSA/MTA entry level
• Strong troubleshooting skills and demonstrated abilities to diagnose and analyze technical issues.
• ITIL / ISO 20000 processes

Ideally to have knowledge in one or more of the following fields:-

• Monitoring tools
• Configuration management tools
• Microsoft Server administration
• Barcode technology