* Worked on installation of versions 10.1, 9.7 of DB2 UDB on AIX.
* Performed POC of DB2 V10.5 on AIX.
* Developed shell scripts for daily maintenance tasks, archiving DB2 log files, and performance monitoring.
* Generated ERD for the database using Erwin
* Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, data files & logs).
* Worked on HADR setup with Tivoli System Automation (TSA).
* Worked on HADR setup for mission critical databases on AIX platform.
* Monitor HADR activity
* Created Capture and Apply program tasks for a DB2 Q-Replication system.
* Responsible for risk management analyze any suggested change to systems and determine risk factor as well as recovery steps.
* Performed capacity planning and performance tuning.
* Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
* Developed document that provides an overview of the physical and logical design of the database environment implemented for JPMC.
* Provide database backup and recovery support for DB2 UDB
* Create, configure, monitor, and tune DB2 UDB databases for new internal projects
* Worked with tools DB2 Performance expert, DBArtisan, DB2MON, and Control center to debug and resolve database issues
* Extensively worked on tuning complex SQL queries, developing stored procedures, and functions
* Effectively carried out database performance tuning and troubleshooting & fixing problems faced by application developer.
* Involved in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the database ENVIRONMENT: DB2 EE V 10.1/9.X, Web sphere, AIX 5.x, windows NT/XP, Server, Erwin, and SAN, Clustered Environment