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 contemporary 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 [email protected] We look forward to connecting with you

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