[AD4QQQR7] Database Architect

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.
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 akshitha.b@zettamine.com
We look forward to connecting with you!

Work arrangement
No