[AD4QQQR7] Mainframe Database Architect

ZettaMine Labs Pvt. Ltd.; Bengaluru; On-site; INR 2,500,000 - 5,000,000; Full time

Job summary

ZettaMine Labs Pvt. Ltd. seeks an experienced Database Architect / Mainframe DB SME to lead modernization of core databases. You will define target data architecture, design scalable models, and plan migrations from DB2 to PostgreSQL across mainframe environments.

With 8+ years of hands-on mainframe database experience, you will drive data quality, lineage, and conversion strategies while collaborating with cross-functional teams to ensure a smooth production migration.

Qualifications

• 8+ years of relevant database and mainframe experience.
• Hands-on in DB2, PostgreSQL, and data architecture.
• Experience with DB2-to-PostgreSQL and VSAM-to-PostgreSQL conversions.
• Knowledge of IMS hierarchical databases and data lineage.

Responsibilities

• Define target data architecture for mainframe modernization initiatives.
• Design scalable 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 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 mitigation.
• 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.

Skills

Database Architecture

Mainframe DB

DB2

PostgreSQL

Data Architecture

Data Modeling

Data Migration

DB2-to-PostgreSQL

VSAM-to-PostgreSQL

IMS Hierarchical

Data Lineage

Data Quality

Data Mapping

Data Validation

Data Reconciliation

Index Design

Database Optimization

Mainframe Modernization

Education

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

Job description

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

Job Role

Database Architect / Mainframe DB SME

Location

Experience

8+ Years

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 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.
• Strong understanding of data lineage and source-to-target mapping.
• Experience with index design and database performance optimization.

Education

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