Sandeep KP

Highly-skilled DB2 System Programmer with 11 years in mainframe infrastructure and design. Advanced knowledge on DB2 and IMS database. Logical and professional with excellent problem-solving skills.

• Install, support and customize licensed DB2 software and related tools
• Install, support and customize licensed IMS software and products
• Upgrade DB2 subsystem environments to newly released versions
• Apply planned maintenance refreshes to supported DB2 environments
• Provide timely resolution to DB2 software related problems, including 24/7 on Call support
• Ability to maintain & support the DB2 subsystems in a RACF and ACF2 environment
• Build new DB2 subsystem environments, or relocate existing DB2 subsystem environments upon request
• Provide technical recommendations involving the DB2 environments and tools upon request
• Worked on remediation of PLANS/PACKAGES across the subsystems
• Created, implemented and maintained DB2 databases, tablespaces and indexes per development specifications.
• Extensively monitoring the environment for HIGH CPU native and distributed threads and working with user and application team for environment stability.
• Implemented automation for Maintenance/Housekeeping jobs for daily status checks.
• DB2 administration and utilities: COPY, RECOVER, CHECK DATA, REORG, RUNSTATS, REBUILD,LOAD/UNLOAD. Support for Application/Development teams on DB2.
• Create, maintain and support various application tables on IDAA/IIDR/DVM for mainframe modernization project.

• 10 years of experience as a DB2 System Programmer having excellent knowledge of DB2 systems. 16 months as DB2 DBA and 12 months as IMS SYSPROG on IBM Mainframe z/OS.
• Mentored team members on DB2 and IMS database Technologies.
• Worked on several mainframe modernization project
• I've Onshore experience working in the US for ALLSTATE and currently hold a B1 visa for US.

• Worked on Z/OS(limited), ZOSMF and SMPE related works.
• Working in several app project/modernization as DB2 DBA since 16 months.
• Worked on the IMS(hierarchical) database activities for 12 months
• Worked on several levels of DB2 migration and maintenance process.
• Initiating Automation for regular activities and maintenance
• Installed many new products like Gardium, Query Monitor, IIDR and DVM.
• Working on the fresh installation of IDAA.
• Automated JCL's for Maintenance and Installation
• Worked on most of the IBM DB2 products
• Worked on decommissioning on DB2 subsystem/data sharing member.
• Have involved in the disaster recovery process.
• Worked on creation of Data sharing environment for the Production system

• Date of Birth: 07/18/1989
• Nationality: Indian

AWS solution architect