Monish Patil

IBM certified DB2 LUW Database Administrator and a Data Science enthusiast. Having a total work experience of 14 plus years. I like upgrading to new skills, exploring new technologies and completing targets before SLA.

DB2 Database Admin (Senior Team Lead) - Coforge India Pvt Ltd - Mumbai, India

(2025-02)

• DB2 Server/Client Setup with Pacemaker Installation.
• Fixpack Upgradation and Patching.
• Decommissioning for Older versions of Databases.
• Indexing and Performance Tuning.
• Daily work on Production server troubleshooting databases for Banking Domain.
• Table Space management.
• HADR Setup from scratch along with, maintenance and DR activity.
• DB2 Backup and Restoration.

DB2 Database Admin (Senior Consultant) - ATOS India Pvt Ltd - Mumbai, India

(2022-04 - 2025-01)

• Daily Health Check reports of critical banking servers.
• Daily work on Production server troubleshooting databases for Asia Continent.
• Table Space management using Reorg and Runstat.
• HADR Maintenance and DR activity.
• Prepare DML and DDL scripts.
• DB2 Backup and Restoration.

DB2 Database Admin (SME) - IBM India Pvt Ltd - Mumbai, India

(2017-01 - 2022-04)

• Daily Health Check reports of all the production servers.
• Data Migration from on premise server to IBM Public cloud.
• Setting up SQL Replication for tables and resolving replication related issues.
• DB2 Stop & Start Activity.
• Data Movement Activities like db2move, export Import and Load.
• Preparing Cron jobs and Shell Scripts for Reorg, Run stats, Backups, Filesystem, Housekeeping and CPU High Utilization.
• Helped Customers in building new database servers.

DB2 Database Admin (Consultant) - CAPGEMINI India Pvt Ltd - Mumbai, India

(2012-04 - 2017-01)

• Maintaining and testing backups, monitoring logs, resolving job abort issues, lock Escalations, Lock Timeout, Deadlock
• Detection, Secondary Logs, File System usage issue, High CPU Utilization issues, Memory Utilization issue.
• Data Movement Activities like export Import and Load.
• Data Maintenance activity like Reorg and Run stats.
• Incident management, Change management & Problem Management
• Execution of random scripts given by application team.
• Auditing of incidents for all GEO.

Masters - Data Science - Liverpool John Moores University (2021-09 - 2022-08)

Post-Graduation - Data Science - International Institute of Information Technology Bangalore (2020-07 - 2021-08)

Bachelors of Science - Information Technology - University of Mumbai (2010-06 - 2011-06)