Work History

Work History
Jun 2012 - Present

Lead Consultant (Domain Lead)


Leading and trained a team of 65+ members of oracle,sybase and db2 domain team to provide effective DBA support for production and non-production databases.

Providing L5 support for Oracle.

Coordination of work with staff, vendors and other stakeholders.

People Management of the Team.

Serve as a lead point of contact for operations, take charge of all aspects of service delivery in the account

Automated mundane tasks via scripting and resource optimization.

Customer environment review and discussion with necessary stakeholder.

Designing and implementing business processes for service management and operations

Analyzed, Planned, implemented and optimized performance of the database by implementing best practices from os, db and application level.

Database Forecasting using historical data and provide the extended comparative data using the graph.

Installed, configured, administered,upgraded and migrated databases from 9i, 10g to single instance, dataguard,RAC,OEM,Golden gate,CDC.

Resolved multiple Performance issues.

Troubleshoot RAC related issues.

Analyzing the system on regular basis and providing advisory report.

Capacity planning.

Planning and performing regular DR drills.

Customer environment review and discussion with necessary stakeholder.

Performing Root Cause Analysis of Issues.

Planned, installed, configured and administered HADR and TSA.

Nov 2009 - Apr 2012


HCL Comnet System

Lead and trained on-shore and offshore global team to provide effective DBA support for production and non-production databases.

Install and configure 10g six node RAC system.

Upgrade from to RAC system.

Upgrade clusterware and Database from Oracle to in a timely manner.

Troubleshoot node eviction issue on clusterware.

Installed, configured and supported Oracle Enterprise Manager (OEM)/Grid Control to monitor Oracle Databases.

Managed database migration from HP UNIX to Linux servers. Databases were moved from Unix file system based storage to Oracle ASM. This resulted in significant reduction in hardware, operational and storage costs.

Resolved Performance issue after database upgrade from to

Configured Oracle’s Total Recall to enable querying historical data

Designed, Installed and configured Maximum Availability Architecture (MAA) using Oracle Data Guard.

Database Forecasting using historical data and provide the extended comparative data using the graph.

Used ORION (Oracle I/O Calibration Tool) for calibrating the I/O performance for storage systems .

Optimized SQL Statement using 10046 and 10053 trace event.

Sep 2007 - Sep 2009



Upgrade single instance databases from to

Implemented incident, problem and change management ITIL processes across Global Operational Services organization.

Proactively identified issues and ensured service level agreements are met.

Administered customers’ production databases totaling over 100TB in size for various Data Warehouse and OLTP applications.

Designed database and server monitoring and notification system using Oracle EM Grid Control for monitoring Oracle databases. This reduced the number of outages by 35%.

Created Physical and logical Standby Database for disaster recovery system for the clients.

Configure RMAN backup Policy for 30+ customers’ database.

Tuned Oracle database(s) to achieve optimum performance using Analyze Tables/Indexes, Explain Plan, and TKPROF.

Install and configure 4 node RAC systems.

Research, analyze, and recommend patches, tools, and/or database upgrades to resolve issues and add features/functionality.

Resolve a ORA-4031 Problem for oracle database.

Used Systemstate dump analysis for the analysis high intensive sequences in RAC.

Jun 2005 - Aug 2007


Atmiya InfoTech Pvt. Ltd

Responsible for database administration of Oracle databases.

Work closely with Unix and Oracle support in resolving issues.

Installed software, created database(s), primary database storage structure(s) and primary objects like tables, views and indexes.

Added datafiles, created Oracle users, and granted roles and privileges using Enterprise Manager.


May 2003 - Sep 2007

B.E Computer Science




Oracle database Installation, Upgradation & Migration across various platflorm (9i,10g,11gr2 & 12c)


Oracle database Administration 9i,10g,11gr2 & 12c


Oracle backup and recovery 9i,10g,11gr2 & 12c


Oracle Dataguard 9i,10g,11gr2 & 12c


Oracle RAC & ASM 9i,10g, 11g r2 & 12c


Oracle Performance tuning 9i, 10g, 11gr2 & 12c


Oracle Enterprise Manager 9i,10g,11g & 12 c


Oracle database Security 9i,10g, 11gr2 & 12c


Oracle golden gate 11 & 12


Hadoop, Cloudera, DB2, Sybase, MongoDB, CDC, SYBASE





Oracle Certified Master 11g

Oracle University

Oracle Partner Network Certified Specialist

Oracle University

Oracle Certified Expert RAC 10g

Oracle University

Oracle Certified Professional 11g

Oracle University

Oracle Certified Associate 11g

Oracle University