Application DBA Mainframe Modernization (DB2 z/OS, Datacom/DB, VSAM, Data Migration)
Posted Today by Aroha Technologies
Negotiable
Undetermined
Remote
Remote or California
Summary: We are looking for a hands-on Application DBA to support a mainframe modernization initiative, focusing on legacy data structures and database technologies such as IBM Db2 for z/OS and Datacom/DB. The role prioritizes data extraction, transformation, performance tuning, and schema evolution over traditional DBA tasks. The candidate will work closely with application developers and modernization teams to facilitate efficient data migration and optimize database interactions.
Key Responsibilities:
- Analyze and interpret legacy data structures including VSAM files, Db2 z/OS, and Datacom/DB objects.
- Design and optimize data models/schemas aligned with modern application requirements.
- Develop and tune SQL queries (Db2) and support Datacom access patterns for scalability and performance.
- Identify and resolve inefficient data access patterns (e.g., full table scans, poor indexing strategies).
- Partner with modernization teams to ensure smooth data extraction, migration, and integration.
Key Skills:
- Strong expertise in Db2 for z/OS, Datacom/DB, and VSAM.
- Proven experience in data migration, schema evolution, and performance tuning.
- Hands-on SQL development and optimization skills.
- Familiarity with mainframe modernization initiatives and hybrid cloud integration.
- Excellent problem-solving and collaboration skills.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
Job Description: Mainframe Modernization Application DBA
Job Title: Application DBA Mainframe Modernization (DB2 z/OS, Datacom/DB, VSAM, Data Migration)
Duration: 12 month contract (extendable)
Location: Remote
Role Overview
We are seeking a hands-on Application DBA to support a mainframe modernization initiative involving legacy data structures and both relational and network-style/mainframe database technologies (IBM Db2 for z/OS and Datacom/DB). This role emphasizes data extraction, transformation, performance tuning, and schema/data model evolution rather than traditional DBA administration.
The candidate will collaborate closely with application developers and modernization teams to enable efficient data migration and optimize database interactions.
Key Responsibilities
Analyze and interpret legacy data structures including VSAM files, Db2 z/OS, and Datacom/DB objects.
Design and optimize data models/schemas aligned with modern application requirements.
Develop and tune SQL queries (Db2) and support Datacom access patterns for scalability and performance.
Identify and resolve inefficient data access patterns (e.g., full table scans, poor indexing strategies).
Partner with modernization teams to ensure smooth data extraction, migration, and integration.
Required Skills & Experience
Strong expertise in Db2 for z/OS, Datacom/DB, and VSAM.
Proven experience in data migration, schema evolution, and performance tuning.
Hands-on SQL development and optimization skills.
Familiarity with mainframe modernization initiatives and hybrid cloud integration.
Excellent problem-solving and collaboration skills.
Preferred Qualifications
Experience with data migration tools and ETL frameworks.
Exposure to cloud-native environments (AWS, Azure, Google Cloud Platform).
Knowledge of enterprise modernization strategies and governance.