Job Summary

The resource should be expert in Application DB2 DBA. Able to perform DBA activities for data migration project

Modernization of core insurance application databases from legacy CA Datacom/DB to IBM DB2 (z/OS).

Key Responsibilities

- Analyze legacy architecture: Evaluate existing CA Datacom/DB elements, table structures, and Active Data Dictionary definitions to plan relational equivalents in DB2.
- Schema Mapping & Design: Lead logical-to-physical database design, translating Datacom entities into optimized DB2 tablespaces, partitions, and indexes.
- Data Cleansing & Validation: Develop and execute comprehensive data validation, reconciliation, and integrity runbooks to verify parity post-migration.
- Cutover Management: Participate in database cutover, rollbacks, and post-migration stabilization windows during scheduled application releases.

2. Application Support & SQL Engineering

- Application Retrofitting: Collaborate with application developers to assist in converting legacy database access logic (e.g., Datacom/DB commands, COBOL calls) into native, high-performing DB2 SQL.
- Query Performance Tuning: Conduct proactive SQL statement analysis, trace execution plans, and optimize complex queries using tools like DB2 Explain.
- Deployment Automation: Review, test,



and implement application database change objects through continuous delivery tools

3. Security, Operations & Governance

- Access Control: Implement robust database security parameters in alignment with Zurich Insurance compliance frameworks and Mainframe security tools (RACF/ACF2).
- Resilience Planning: Define backup, data extraction (DXT), and high-availability frameworks to protect highly sensitive production insurance data.

Skill Requirements

- Experience: 8+ years of total Database Administration/Engineering experience, with at least 3+ years dedicated to database migration or modernization programs.
- Domain Background: Prior experience in highly regulated financial services, banking, or the insurance sector is highly preferred.
- Technical Mastery:
- Deep, hands-on knowledge of IBM DB2 for z/OS database object management, utilities (REORG, RUNSTATS, COPY, LOAD/UNLOAD), and JCL.
- Core working knowledge of CA Datacom/DB architecture, its data dictionary, and its internals to decode legacy schemas.
- Expert-level understanding of relational algebra, physical data modeling, database concurrency, and advanced SQL troubleshooting.

Must Have Skill

Mainframe Database Administration,IBM DB2 for z/OS

Positive to Have Skill

Datacom/DB,Job Control Language (JCL),COBOL

Other Requirements

📌 Technical Specialist (India)
🏢 HCLTech
📍 India