Sr Data Migration Specialist

Sr. Data Migration Specialist

You will be extracting 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. 

What will your job look like? 

You will:  

· Leverage your broad experience across various cloud DBMS services, operations, interfaces and installations to compare and recommend implementation solutions

· Collaborate with mainframe migration teams to find solutions to cross code and data related bugs and issues 

· Convert database structures and application data from mainframe technologies (Adabas, IDMS, VSAM, DB2 zOS) to the equivalent RDBMS structures in SQL Server, Oracle, PostgreSQL, and others 

· Clearly define the root cause of problems using defect reporting tools 

· Validate customer data in destination systems 

· Provide clear descriptions and feedback on tool performance for the RND team 

· Complete database performance analysis, and tune runtime and data loading performance where applicable 

· Consult and guide team on issues encountered 

· Configure and populate relational databases on Linux/Windows or in the Cloud

All you need is...  

· Experience working with Cloud Architects to implement AWS, Azure or Google Cloud Platform services.

· Familiarity with AWS, Azure or Google Cloud Platform good practices in relation to RDBMS deployment, monitoring, security and availability. 

· 7+ years’ expert experience with relational and transactional languages as a DBA (DDL, DML, TCL, etc.) 

· 3+ 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 

· Familiarity with SQL language structures and performance tuning 

· Experience with scripting languages (Powershell, bash, Python, etc.)

· Bachelors degree in Computer Science or equivalent 

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