Overview
Skills
Job Details
Job Title: Data Migration DB Specialist with Mainframe Experience
Location: US Remote
Duration: 12+ Month Contract on W2
Summary
You will be working with a team of specialists on multi-phase projects supporting the migration and conversion of application data from a variety of legacy mainframe databases, mapping the raw data to new database systems in either the cloud or on-premises data solutions, formatting and importing client data from legacy systems to modern data environments all using your knowledge of data structures, data relationships and data strategy and set of data migration tools.
What will your job look like?
You will:
- Collaborate with mainframe migration teams to find solutions to identify code and data related bugs and issues
- Work within a team focused on converting database structures and application data from mainframe technologies (Adabas, IMS, IDMS, VSAM, DB2 zOS) to RDBMS structures in SQL Server, Oracle, PostgreSQL, and others for large international clients
- Work within a team to build/advise solutions for mainframe file migrations and transformation from mainframe ebcdic to ascii code sets.
- Clearly define the root cause of problems using defect reporting tools
- Recognize patterns in defects related to the data conversion, and at times, code conversion processes.
- Validate customer data in the destination systems
- Provide clear descriptions and feedback on tool capabilities for the Research and Development team to continue to enhance toolset
- Complete database performance analysis, and tune runtime and data loading performance where applicable
- Collaborate with other data migration specialists on issues encountered
- Configure and populate relational databases on Linux/Windows or in the Cloud
- Leverage your experience across various cloud DBMS services, operations, interfaces and installations to compare and recommend implementation solutions
- Use your comprehensive communications skills to interface with clients at all levels and coordinate the receipt and conversion of data across projects approached in a multi-phasal pattern.
All you need is...
- Bachelors degree in Computer Science or equivalent
- 10+ years expert experience with relational and transactional languages as a DBA (DDL, DML, TCL, etc.)
- 4+ years experience modernizing mainframe data systems
- Experience with both Windows and Linux
- Understanding of z/OS and/or Unisys based database systems
- Understanding of IMS, VSAM, JCL, COBOL and complexities of data types and record mapping
- Experience with DB2 ZOS catalog data and using it to generate automated solutions.
- Familiarity with SQL language structures and performance tuning
- Experience with scripting languages (Powershell, bash, Python, etc.)
Why you will love this job:
- Creatively solve problems and collaborate in a remote work environment
- Your personal drive and problem-solving acumen becomes an asset, moving your client s infrastructure from the past to the future
- Build and inspire successful teams, by sharing your lessons-learned while learning from others
Thanks &Regards
Eshant Sharma
Disclaimer: Wise Equations Solutions Inc; provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability