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
Solid 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