Saravanan Bhojan

1) Senior Database Administrator DB2 LUW - MySQL - Postgresql DBA with various database exposure and predominantly worked on DB2 LUW database, Planning and configuring the physical database environment required for development, testing, and production usage.
2) Analyzing DB2 active/archive logs for database/tablespace recovery needs.
3) Hands on experience in DB2 LUW utilities such as BACKUP (Incremental(online/offline) & Delta), RESTORE/RECOVER, Redirected Restore, Memory Tracking (Configuring Database Memory) & Performance Diagnostic with DB2PD, DB2TOP & DB2LOOK
4) Hands on experience with Data Movement utilities such as DB2 LUW - IMPORT, EXPORT, LOAD.
5) Hands on experience in migrating databases between various platforms like AIX, Linux.
6) Extensive work on automating DBA tasks using Korn Shell Scripting for DB2 LUW maintenance activities.
7) Loading the tables / monitoring the table space / Cleansing and removing the unused Indexes, tables etc.
8) Setup and Configuration of HADR Databases /TSAMP Oracle Golden Gate Replication Setup, Q-Replication and IBM-Change Data Capture
9) Hands on experience in raising PMR for IBM-PMR Support team and resolving on-going production issues.
10) Hands on experience in DB2 Tools such as db2ckbkp, db2explain, db2mtrk, db2top and dsmtop.
11) Hands on experience in DB2 Table maintenance activities such as REORGCHK, REORG and RUNSTATS.
12) Performed Installations, Version Upgrades and Fix Packs on DB2-LUW Databases
13) Hands on experience in DR and Test strategies like Failover Clustering, Log Shipping, Replication.
14) Hands on experience in Performance Monitoring tool such as OPM and IBM-Data Server Manager
15) Hands on experience in interacting with Storage teams and Deployment Teams
16) Deploying SQLs as per the CI/CD release from Site-Ops team using Change Control system thru Service –Now tool
17) Optimizing the access path and fine tuning of the SQL queries using Visual EXPLAIN.
18) Analyzed and tuned problematic SQL statements, as a result, the response time of some slow running queries went from hours to minutes or in some cases even to seconds, resulted in dramatic reductions in application processing time.

1) Senior DB2 LUW DBA with hands on experience in Core and Application DBA activities and Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
2) Hands on experience in DB2 LUW utilities such as BACKUP (Incremental(online/offline) & Delta), RESTORE/RECOVER, Redirected Restore, Memory Tracking (Configuring Database Memory) & Performance Diagnostic with DB2PD, DB2TOP & DB2LOOK
3) DB2 LUW troubleshooting the issues from application team
4) Hands on experience with Data Movement utilities such as DB2 LUW - IMPORT, EXPORT, LOAD.
5) Hands on experience in migrating databases between various platforms like AIX, Linux.
6) Extensive work on automating DBA tasks using Korn Shell Scripting for DB2 LUW maintenance activities.
7) Loading the tables / monitoring the table space / Cleansing and removing the unused Indexes, tables etc.
8) Setup and Configuration of HADR Databases /TSAMP Oracle Golden Gate Replication Setup, Q-Replication and IBM-Change Data Capture
9) Hands on experience in raising PMR for IBM-PMR Support team and resolving on-going production issues.
10) Hands on experience in DB2 Tools such as db2ckbkp, db2explain, db2mtrk, db2top and dsmtop.
11) Hands on experience in DB2 Table maintenance activities such as REORGCHK, REORG and RUNSTATS.
12) Performed Installations, Version Upgrades and Fix Packs on DB2-LUW Databases
13) Hands on experience in DR and Test strategies like Failover Clustering, Log Shipping, Replication.
14) Hands on experience in Performance Monitoring tool such as OPM and IBM-Data Server Manager
15) Analyzing DB2 active/archive logs for database/tablespace recovery needs.
16) Hands on experience in interacting with Storage teams and Deployment Teams
17) Deploying SQLs as per the CI/CD release from Site-Ops team using Change Control system thru Service –Now tool
18) Optimizing the access path and fine tuning of the SQL queries using Visual EXPLAIN.
19) Analyzed and tuned problematic SQL statements, as a result, the response time of some slow running queries went from hours to minutes or in some cases even to seconds, resulted in dramatic reductions in application processing time.

1) Mainframe COBOL - DB2 Developer to code DB2 – Cobol Programs
2) Coding & Customizations of SQL-PL DB2-COBOL Stored Procedures for the new requirements.
3) Enhancements have done for CICS - Assembler programs.
4) Mentoring Junior Developer, Review Checklist Preparation.
5) Handson Experience in Version Control and Debugging tools such as Endevour and Xpediter