Poonam Rajput

Background

About Poonam Rajput

10+ years of professional IT Industry Experience as a Mainframe DB2 System Programmer for z/OS. Experience in Mainframes DB2 Administration (v9.1, v10.1, v11.1, v12 & v13).ROLES & RESPOSBLITY• DB2 Migration, RSU Maintenance, Upgrades, Function Level Activation.• IBM, CA, BMC tools for DB2 z/OS Installation, Migration and RSU Maintenance, experience with CA Fast unload,CA Fast Load, Log Analyser, Detector, RC Query, RC Migrator, CA Insight for DB2, BMC Recovery Analyser andother CA Platinum products, IBM DB2 Analytics Accelerator.• End to end coverage for z/15 and z16 Migration from DB2 Infrastructure support• Disaster recovery exercise for DB2• Support DB2 System Programming weekday and weekends oncall.• SMP/E Administration, Ordering PTF from IBM & ISV Vendors, SMPE RECEIVE, APPLYCHECK, APPLY, RESTORE,ERROR SYSMOD report analysis, HOLDDATA analysis, Hiper & PE weekly review• Hands on experience on IBM Online Utilities ( LOAD.• Catalog and Directory Reorg for DB2, DB2 Cold Start, Conditional restart activity and Conversion of 10 Byte RBAactivities on both Stand Alone and Datasharing subsystems• Analysis of SVC dumps using IPCS, Error SYSMOD report, LOGREC report to review PTFs and work with IBM ifrequired.• Driving Incident/Change meetings, maintaining repository of issues encountered during Change implementation and for Critical Incidents.• Integration-testing the new products with existing applications and user procedures.• Apply Program Temporary Fixes (PTFs) for DB2 system software and ISV Products on requirement basis.• Review Local Bufferpool, Group Bufferpool, coupling facility recommendations to Performance Team. Review ofDB2 Storage and recommend space utilization.TRAINING & CERTIFICATION• DB2 Version 12 Family Fundamentals (CE031G)• Introduction to DB2 for z/OS for Systems and Operations Personnel (CV021G)• DB2 Version 12 SQL Workshop(CE121G)• DB2 Version 12 SQL Workshop for Experienced Users (CE131G)• DB2 Version 12 for z/OS system Administration• DB2 Version 12 for z/OS Implementation Workshop• DB2 backup and recovery - CF910• Advance REXX Programming - ES52A• C2090-320 – DB2 11 Fundamentals for z/OS• C2090-317 – DB2 11 System Administrator for z/OS• – DB2 12 for z/OS• C2090-318 – DB2 12 System Administrator for z/OS• Mainframe specialist – REXX Programming– Experienced• Mainframe specialist – SMPE and DB2 software Installation/Migration V11/V12 – Experienced