Details:
Job DescriptionStefanini Group is a multinational company with a global presence in 41 countries and 44 languages, specializing in technological solutions. We believe in digital innovation and agility to transform businesses for a better future. Our diverse portfolio includes consulting, marketing, mobility, AI services, service desk, field service, and outsourcing solutions.Job Requirements
Details:
DB SpecialistSummary of PositionAs 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.