Data Migration Specialist

Candidate Should be interested for C2H Role

JD :

DB Specialist

Summary of Position
As part of the larger team, Data Migration Specialists extract data from a variety of legacy mainframe databases, map the raw data to new database systems in either the cloud or on-premises data solutions. This position will be in charge of extracting, mapping, formatting, and importing client data from legacy systems into cloud-based data environments. They must understand data structure, determine data relationships to properly map data into the most strategic areas within the new data structures.

Essential Duties and Responsibilities
• Export customer data from legacy databases such as Db2, IMS, ADABAS, or IDMS • Update taxonomy changes to reflect code changes in migrated mainframe code • Migrate legacy database files to newly configured database solutions on PostgreSQL on Linux and Windows environments in the cloud • Work with Project Managers and Implementation Engineers to further interpret and map customer data. • Collaborate with our world-class Sales Team to review prospective customer data and provide a pricing quote • Validate the data in both the original and destination systems • Analyze the methods of transforming existing data into a format for the new environment and choose the best solution for the clients situation • Relational database experience with PostgreSQL required • Scripting language experience preferred • SQL experience required Skills, Knowledge, and Abilities • Experience with SQL, Mainframe DB2, IMS, etc., database backups, and database mapping Advanced experience with PostgreSQL required • Experience in Mainframe DB2/IMS/VSAM to Postgres/SQL Server migrations • Enjoys creative problem solving, and thrives in a collaborative, open work environment. • Excellent verbal and written communication skills. • Exceptional time management and the ability to work with a project manager to set and meet deadlines is a necessity • Requires a self-driven individual who is extremely detail oriented and is comfortable problem-solving complex data issues. • Support Team members around deliverables, timelines and strategies. • Provide expert advice on best practice migration solutions that satisfy customer requirements. Education and Experience • Bachelor’s degree or college diploma in Computer Science or a related field, or an equivalent combination of education and experience • Min of 5+ years’ experience running data migrations in a complex environment with PostgreSQL • Intermediate or advanced knowledge of networking, hardware and operating systems, databases, remote connectivity, security and image processing. • Strong knowledge of Windows and Linux operating systems • Understanding of zOS and/or Unisys based Database systems • Proven knowledge of Windows Server, and SQL based Database solutions in cloud environments.