Saurabh Awasthi

About Saurabh Awasthi

Saurabh Awasthi Email id : s••••••••@gmail.comEXPERIENCE HIGHLIGHTSHCL Tech, Noida, India18th October 2022– PresentRole: DB2 DBA LUW, Technical Support EngineerYears of Experience: 3 years PROJECT DETAILSDisney Walt Services Domain : DB2 LUW Database AdministrationDuration : July 2023 – PresentRole : DB2 LUW L2 SupportRole and Responsibilities:• Working Knowledge of DB2LUW 10. X, 11.X• Proficient in managing in SAP systems with DB2.• Provide L2 level operational Support for LUW in Production and Non-Production Environments.• Doing regular checks for the database performance, and database connection issues.• Backup monitoring of the systems on the Rubrik and Net Backup e.g. Backup check, Backup trigger through command line.• Working on both offline/Online backups • Restoring DB form PROD to Non-PROD using Re-direct restore and Point -In Recovery using their local time• Managing Archive log files.• Expertise on Transaction log utilization issues and find out their Causes and their resolution• Planning, documenting and performing DB2 LUW Upgrades and Fix pack Upgrade.• Working Knowledge of Clusters Active /Passive Nodes.• Hands-on experience in creating and managing partitioned tables for scalability and faster data retrieval.• Implemented and managed jobs for scheduling and automating routine DB2/database administration tasks.• Working on Data Movement utilities like Export, Import and Load• Archive log and other mount point monitoring.• Experience on DB Privileges and Authorizations• Has the Working Knowledge of VI. • Has the Working Knowledge of Crontab. • Expertise in Data Monitoring Utilities REORG and RUNSTATS for better performance of the database.• Good experience in maintaining Database Level (DB CFG) and Database Manager Level (Instance) Parameters.• Experience in maintenance of databases, and troubleshooting.• Have working experience on ticketing tools like Service Now.• Monitoring DB2 Activities using Db2pd, db2top, Snapshots & Event monitors.• Troubleshooting database issues using db2diag and notification log, event, monitoring, snapshot, and opening cases (PMR) with a vendor as required.

Experience

1. Database Administrator

   HCLTech

   Jul 2023 — Present

Education

• APJ Abdul Kalam Technological University

  Bachelor of Technology, Information Technology