Db Specialist

Year    Pune, Maharashtra, India

Job Description

Details:
Stefanini 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 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 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.
?#LI-ONSITE#LI-QM1
Pay Range:
$ 2000000.00 - $ 2300000.00

Skills Required

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD4237439
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Pune, Maharashtra, India
  • Education
    Not mentioned
  • Experience
    Year