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.
- Solid 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 [email protected]

We look forward to connecting with you!

📌 QDatabase Architect (Bengaluru)
🏢 ZettaMine Labs
📍 Bengaluru