Talent.com
This job offer is not available in your country.
DB2 Specialist

DB2 Specialist

Stefanini North America and APACPune, Maharashtra, India
26 days ago
Job description

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 client’s 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.