Description

You will lead the data conversion and database redesign for the MEPIC technology upgrade project.

Responsibilities

• Analyze existing SQL database structures, content, and quality to design and optimize a new relational database structure.
• Map data elements from source tables to target tables and develop the programming architecture for conversion.
• Write stored procedures, triggers, and SSIS packages to manage data migration into Microsoft SQL Server.
• Validate the accuracy and integrity of converted data and document the resolution of all data element issues.
• Coordinate with IT services and multiple divisions to implement requirements, system interfaces, and scheduled processes.
• Provide technical leadership in data conversion strategies and deliver detailed progress reporting to the Project Manager.

Required Skills

• 7+ years of experience in systems analysis or data migration roles.
• Bachelor's degree in Computer Science, Business Administration, or a related IT field.
• Extensive experience with MS-SQL 2019 database design and optimization.
• Proficiency in writing stored procedures, triggers, and SSIS packages.
• Hands-on experience with J2EE/Java, JSP, EJB, XML, and JDBC.
• Experience working with JBoss 7.x application servers.
• Proven ability to manage data conversion without automated utilities.
• Strong technical documentation skills for data conversion plans and maintenance operations.

Key Skills

Education

Bachelor's degree