What are the responsibilities and job description for the Application DBA Mainframe Modernization (DB2 z/OS, Datacom/DB, VSAM, Data Migration) position at Aroha Technologies?
Job Description: Mainframe Modernization Application DBA
Job Title: Application DBA Mainframe Modernization (DB2 z/OS, Datacom/DB, VSAM, Data Migration)
Duration: 6-month contract (extendable)
Location: Remote / Hybrid
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.