Garvit Jain

Background

About Garvit Jain

o Worked as Technical Lead for DB2 application support team o Mentoring new Joiners in the team o Conduct weekly meetings with the client to ensure better co-ordination and communication o Conduct regular meetings with the team to address any grievances and any outstanding issues o Delegate the work allocated by the client amongst the team members based on the workload, availability and skill sets. o Performing Data Refreshes from Production to Dev & QA environments. o New database creations and object definitions o Creating new Reorg\Image Copy\Unload\Load Utility jobs using the reusable components and changes to appropriate parameters. o Creating packages to move JCLs or Control Card changes to PROD environment using CA ChangeMan tool. o Binding of Plans and Packages and resolving Bind errors in all environments o Monitoring the performance of the various environments o Performing & scheduling different checks in a database environment like Extents Report, Space Utilization, and Package Status etc. o Establishing archival and purge strategies for large tables (REORG Purge Setup) o Recovering databases to previous point in time using RECOVER TO COPY o Log Master Tool to scan DB2 logs (Generate UNDO SQL, performing recovery) o SQL Tuning using Apptune Tool o Monitoring for deadlocks, timeouts, lock escalations, uncommitted reads etc. o Database Administration and Maintenance using utilities like REORG, RUNSTATS, IMAGECOPY, UNLOAD, LOAD utilities) o Production Release and Change Management o Automating time consuming tasks using REXX o Troubleshooting REPLICATION issues (Apply & Capture Latencies) o Preparing status reports for use in communication to stakeholders o Problem and Incident management ensuring that ensure SLA’s are achieved and client expectations are met (or exceeded). o Good Working knowledge on Tools like Omegamon, CA SYSVIEW, CA platinum Tool, DB admin tool, BMC tools.