Chandan Chourasia

Experienced Mainframe DB2 Database Administrator (DBA) with over 7+ years of expertise in managing, maintaining, and optimizing DB2 databases on z/OS platforms. Proven track record in ensuring high availability, performance tuning, backup and recovery, IBM service Maintenance, performance tuning, system migrations, cloning prod systems and disaster recovery planning. I am skilled in database design, data modeling, and implementing robust security measures.

Adept at collaborating with cross-functional teams to support mission-critical applications and deliver seamless database solutions. Strong understanding of SQL, JCL, REXX and automation tools to streamline operations and improve efficiency. Committed to continuous improvement and staying current with evolving mainframe technologies.

DB2 DBA / System Programmer for z/OS at Tata Consultancy Services (2018-12 – Present)

System Administrator Role with expertise in Data Sharing Environment, DB2 installation, subsystem creation, configuration and customization. Database Administrator Role managing table maintenance, backup/recovery, performance tuning, and database object creation.

• DB2 Installation, Subsystem Creation, Configuration & Customization, Decommission of system
• Led DB2 version upgrade from V11 to V12, ensuring minimal downtime
• Rolling out of DB2 RSU Service Maintenance (Patch Fix)
• DB2 Admin tool upgrade
• Cloning or DB2 refresh of DB2 system using DB2 cloning tool
• I participated in DR drill exercise conducted every year
• SAP S4 HANA and HANA BW migration from DB2v12
• Troubleshoot subsystem availability errors, abnormal address space failures, performance issues, authorization issues, deadlocks and timeouts
• Manage log offloads, buffer pool allocations and system parameter (ZPARM) updates
• Optimize and Tune subsystems for performance by enhancing buffer pool utilization, Catalog statistics accuracy, ZPARM rationalization, Directory cleanup & Catalog/Directory reorganization
• Table maintenance (Rotate, Rebalance, Adding Partition, SEG to PBG, Increase Seg Size, Alter PRI and Sec, etc.)
• Backup/recovery/restores of DB object
• Performance issue due to scan method and manage DB2 lock contention(Deadlock, timed out)
• Adding workfiles to manage workload on subsystem
• Enabling CDC (Change Data Capture) to replicate data from Db2 to Qlik
• Alter Table parameter (pri/Sec, DS size, BP, Audit all parameter, etc.)
• Grant/revoke privilege to user
• Reorganization of DB object( Tablespace/Indexspace)
• Scheduling object level backup/reorg/stats from SAP (DB13 transaction)
• Creation of Db objects(Database, Tablespace, Table, Index, Views, etc.)
• SAS Performance analysis
• SAS Install / Migration from M6 to M9 maintenance level
• SAS software license renewal
• Analyze and rerun the failed Performance report using SAS script
• MXG version upgrade and customization

Bachelor of Technology in Computer Science & Engineering – Gauhati University Institute of Science and Technology (2018-07)