Application DBA - Mainframe Modernization

Application DBA - Mainframe Modernization

Posted Today by THE TILTED CIRCLE LLC

Apply
Negotiable
Inside
Remote
Remote
Apply
Cloud Computing Cloud Technology Data Access Data Extraction Data Migration Data Structures Extract Transform Load (ETL) Google Cloud Google Cloud Platform (GCP) IBM DB2 IBM Software Indexing Microsoft Azure Oracle Database Administration (DBA) Performance Tuning Scalability SQL (Programming Language) Virtual Storage Access Methods z/OS

Summary: The Application DBA role focuses on supporting a mainframe modernization initiative by managing legacy data structures and optimizing database technologies such as IBM Db2 for z/OS and Datacom/DB. The position requires hands-on involvement in data extraction, transformation, and performance tuning, rather than traditional DBA tasks. Collaboration with application developers and modernization teams is essential for efficient data migration and database optimization. This role is remote and is expected to last for over 12 months.

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: inside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Position: Application DBA - Mainframe Modernization
Location: REMOTE
Duration: 12+ Months Contract

on W2

Application DBA – Mainframe Modernization (DB2 z/OS, Datacom/DB, VSAM, Data Migration)

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.
Apply
Similar Jobs
Loading data...