Mainframe Database Architect

Hello,

Greetings from ZettaMine Labs Pvt Ltd!!

We are looking for an experienced Database Architect / Mainframe DB SME with project opportunities.

Job Role

Database Architect / Mainframe DB SME

Location

Bangalore / Hyderabad / Chennai / Pune / Noida

Experience

8+ Years

Relevant Experience

Strong hands-on experience in Mainframe Database Architecture, Data Modeling, Data Migration, DB2, VSAM, IMS, PostgreSQL, Data Quality, Data Lineage, and Database Modernization.

Notice Period

Immediate Joiners

Mandatory

Mainframe DB + DB2 + PostgreSQL + Data Architecture + Data Modeling + Data Migration Design + DB2-to-PostgreSQL Conversion + VSAM-to-PostgreSQL Conversion + IMS Hierarchy Conversion + Data Lineage + Data Quality + Index Design

REQUIREMENT FOR DATABASE ARCHITECT / MAINFRAME DB SME

Key Responsibilities

• Define and implement target data architecture for Mainframe database modernization initiatives.
• Design scalable and optimized data models aligned with business and technical requirements.
• Develop detailed data migration strategies and designs for legacy Mainframe databases.
• Lead database modernization and migration from DB2 to PostgreSQL.
• Design and support VSAM-to-PostgreSQL conversion initiatives.
• Analyze and transform IMS hierarchical data structures into modern relational database models.
• Define data mapping, transformation, validation, and reconciliation strategies.
• Establish data quality standards and validation frameworks for migration activities.
• Perform detailed data lineage analysis across source and target systems.
• Identify source-to-target dependencies and document data flows.
• Design appropriate indexes and database structures to optimize query performance.
• Analyze existing Mainframe database structures and recommend modernization approaches.
• Work closely with application, data engineering, architecture, and migration teams.
• Review technical designs, migration approaches, data models, and conversion strategies.
• Identify data migration risks, dependencies, and technical challenges and recommend mitigation strategies.
• Support data profiling, cleansing, transformation, and validation activities.
• Ensure migrated data maintains accuracy, completeness, consistency, and integrity.
• Provide technical guidance and act as a Mainframe Database SME throughout the project lifecycle.
• Prepare technical documentation, architecture diagrams, data models, mapping specifications, and migration plans.
• Support testing, reconciliation, defect resolution, and production migration activities.

Who Can Apply

• Candidates with 8+ years of relevant database experience.
• Strong Mainframe database background with expertise in DB2.
• Hands-on experience in database architecture and data modeling.
• Experience designing DB2-to-PostgreSQL migration/conversion solutions.
• Experience with VSAM-to-PostgreSQL conversion.
• Strong understanding of IMS hierarchical databases and hierarchy conversion.
• Experience with data migration, data quality, lineage, mapping, and reconciliation.
• Strong understanding of database indexing and performance optimization.
• Experience working with cross-functional architecture, development, and migration teams.
• Strong analytical, documentation, and technical communication skills.

Good to Have

• Experience in large-scale Mainframe modernization programs.
• PostgreSQL architecture and performance tuning.
• Experience with ETL/ELT and data migration tools.
• Knowledge of COBOL/Mainframe application dependencies.
• Experience with data governance and metadata management.
• Experience with automated data validation and reconciliation.
• Knowledge of cloud database platforms.
• Experience leading database modernization workstreams.

Key Skills

Database Architecture | Mainframe DB | DB2 | PostgreSQL | Data Architecture | Data Modeling | Data Migration | DB2-to-PostgreSQL | VSAM-to-PostgreSQL | IMS | IMS Hierarchical Database | Data Conversion | Data Quality | Data Lineage | Data Mapping | Data Validation | Data Reconciliation | Index Design | Database Optimization | Mainframe Modernization

Mandatory Project Experience

• Minimum 8+ years of relevant database/Mainframe experience.
• Strong experience with DB2 and Mainframe databases.
• Experience designing target data architecture and data models.
• Hands-on experience with DB2-to-PostgreSQL conversion/migration.
• Experience with VSAM-to-PostgreSQL conversion.
• Experience analyzing and converting IMS hierarchical data structures.
• Experience defining data quality strategies.
• Strong understanding of data lineage and source-to-target mapping.
• Experience with index design and database performance optimization.
• Experience supporting enterprise-scale data migration/modernization programs.

Education

Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related field.

Please share the following details along with your updated resume:

• Full Name:
• Contact Number:
• Current Location:
• Total Experience:
• Relevant Mainframe DB Experience:
• DB2 Experience:
• PostgreSQL Experience:
• Database Architecture Experience:
• Data Modeling Experience:
• Data Migration Experience:
• DB2-to-PostgreSQL Conversion Experience:
• VSAM-to-PostgreSQL Conversion Experience:
• IMS Experience:
• IMS Hierarchy Conversion Experience:
• Data Quality Experience:
• Data Lineage Experience:
• Index Design Experience:
• Mainframe Modernization Experience:
• Current Company:
• Notice Period:
• Earliest Joining Date:
• Current CTC/Rate:
• Expected CTC/Rate:
• Preferred Location:

Share Your Updated Resume to [Confidential Information]

We look forward to connecting with you!