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
Robust 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 dat

📌 QMainframe Database Architect (Bengaluru)
🏢 ZettaMine Labs
📍 Bengaluru