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