SUMMARY: 

    • Have 12 years of experience as Oracle Applications 11i/R12 DBA & Oracle DBA, providing 24×7 support of both Production & Development Instances on Various Platforms.
    • Experienced in Oracle Apps Administration and Sysadmin tasks.
    • Installation, Configuration & Deployment of Oracle E- Business Suite 11i/R12.
    • Good knowledge on 12.2 Run File System, Patch edition and non-edition file systems.
    • Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
    • Performing pre-patch analysis and responsible for patching of Oracle Applications instance and its maintenance.
    • Experience in Installation of Oracle 9i, 10g, 11g, 12c in UNIX/LINUX and Windows environment. 
    • Proficient in Database and Applications Administration activities such as Upgrades, Patches, TAR support, Backup and Recovery, Performance tuning, script development. 
    • Effective troubleshooting of Database and Performance problems.
    • Worked with development teams and data administration staff to enhance Database and application performance.
    • Extensive performance tuning of Concurrent programs and Concurrent Mangers.
    • Very strong in Auto Patch, Upgrade, cloning.
    • Expertise in using ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR tools. 
    • Management of schemas, objects & Partitioning the tables & indexes.
    • Experience in a variety of different environments like HP-UX, SUN SOLARIS, Linux and Windows.
    • Experience in managing very large databases (Multiple TB of size).
    • Write Korn shell scripts to monitor and maintain the Oracle Applications database.
    • Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN.
    • Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.

Technical Skills:

Operating Systems : HP-UX, Sun Solaris, IBM AIX, Windows, Red Hat Linux.
RDBMS : Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c.
ERP : Oracle E-Business Suite 11i, R12.
Languages : SQL, PL/SQL, UNIX Shell Scripting.
Tools : RMAN, OEM, OAM, SQL*PLUS, SQL*Loader, TOAD, SQL Developer
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR

Professional Experience:

Organization:    NCR Corporation Pvt Ltd.
Designation:    DBA Technical Lead
Duration:    Oct 2016 – Till date

Responsibilities:           
    • Oracle Applications R12 and database support.
    • Cloning Oracle Applications using with Rapid Clone (Single & Multinode)
    • Applying Patches (Database & Application )
    • Upgrade Oracle Applications Database
    • Create and Follow up Service Requests with Oracle Support for Technical Support
    • Working with the Development Team to fix the problems in Applications
    • Monitoring Health Check of servers by background process and by using OAM
    • Maintaining Application Security and Database Security
    • Managing Users, Responsibilities and Profile options
    • Backup and Recovery Processes (RMAN). Restoration of the backups as and when required
    • Tuning Oracle Database
    • Space Management (table space, undo segment), Monitoring (alert log, memory, CPU)
    • Proactively checking the Database Server for functionality and Network connectivity by using UNIX scripts.

Organization:    TriCore Solutions
Designation:    Senior Consultant- Oracle DBA
Duration:    Nov’2014 – Oct 2016

Responsibilities:           
    • Managing Oracle E-Business Suite 11i, R12 and databases for multiple clients.
    • Cloning of Application / database as and when required.
    • Following up with Oracle to find the latest patch set updates for Oracle database available and to apply those, if required.
    • Communicating with developers / support team to gets the functionality of Apps working.
    • Work with Oracle support for problem solution by raising SRs and having OWC sessions / Phone calls as necessary
    • Oracle Real application cluster. 
    • Proactively checking the space utilization of database.
    • Co-ordination with other teams in case of planning outages.
    • Checking for all the database scheduled jobs and concurrent programs.
    • Creation of new Databases/ Schema for clients as per requirements.
    • Database Upgradations and migrations.
    • Performance monitoring and analysis for Oracle Application/ Databases.
    • Proactively checking the Database Server for functionality and Network connectivity by using UNIX scripts.
    • Database server connectivity and availability to users.
    • Database Server access problem
    • Maintaining BACKUP for the databases as per the backup policies. 
    • Restoration of the backups as and when required.
    • Reporting regarding SLA (Service Level Agreements) and availability of databases

Organization:    IBM, India
Designation:    Sr. Oracle DBA
Duration:    Oct’12 till Nov’14

Project Title        :      IBM India pvt ltd.   

Client        :     Maruti Suzuki India ltd.
Role        :     Team lead
Technologies    :     Oracle Applications 11i (11.5.10), R12
Team Size    :    7  
Database Versions:      Oracle 9i, 10g, 11g.
OS Platforms         :    AIX, HP-UX, Windows
Duration                 :      Oct 2012 – Nov 2014

Responsibilities:    
    • Handled the responsibility as Apps dba as well as Core DBA.
    • Creation of Incident reports and RCA for priority incident tickets and problem tickets.    
    • Review of database daily, weekly and monthly monitoring checklists.  
    • Production database refreshes on Test/UAT servers on weekly basis.                               
    • Managing Concurrent Requests, troubleshoot All Phase/Status of a concurrent Request.
    • Handling system administrator jobs for the application.
Raised and Followed up Oracle TAR on Severity 1 basis.
    • Cloning of Oracle database and applications.
    • Patching on Oracle environment using OPATCH and ADPATCH  utilities    
    • Perform purging and archiving activities.
    • Monitoring of high utilization based queries and fixing them based on approvals from respective application owners.
    • Performance tuning for optimized results using tools like Explain Plan, SQLT, and TKPROF.
Managing Oracle Database Backups and recovery through RMAN utility. 

Organization:    TCS
Designation:    IT Analyst
Duration:    June’11 till Sept’12

Project Title         :      TATA Consultancy Services Ltd.   

Client             :      Electronics Arts
Role             :      IT Analyst 
Team Size         :      8
Database Versions :     8i, 9i, 10g
OS Platforms         :      Linux, Windows
Duration         :      June 2011 – Oct 2012

Responsibilities :          
    • Production support for Oracle database and applications
    • Cloning of Application / database as required.
    • Following up with Oracle to find the latest patch sets for Oracle Application available and to apply those, if required.
    • Communicating with developers / support team to gets the functionality of Apps working.
    • Work with Oracle support for problem solution by raising SRs and having OWC sessions / Phone calls as necessary
    • Proactively checking the space utilization of database.
    • Co-ordination with other teams in case of planning outages.
    • Checking for all the database scheduled jobs and concurrent programs.
    • Creation of new Databases/ Schema for applications.
    • Database Upgradations 
    • Performance monitoring and analysis for Oracle Application/ Databases.
    • Proactively checking the Database Server for functionality and Network connectivity by using UNIX scripts.
    • Database server connectivity and availability to users
    • Database Server access problem
    • Maintaining BACKUP for the databases as per the backup policies. 
    • Restoration of the backups as and when required.
    • Implementation of ITIL Processes.
    • Reporting regarding SLA (Service Level Agreements) and availability of database

Organization:    Wipro Infotech Ltd
Designation:    Senior Customer Service Engineer 
Duration:    Dec’09 till June’11

Project Title         :      Wipro Infotech ltd.   

Client             :      Wipro Enterprise Solutions (On-call support)
Role             :      Senior Customer Service Engineer – Database & Middleware 
Team Size         :      4
Database Versions :     8i, 9i, 10g
OS Platforms         :      Linux, Sun Solaris, Windows
Duration         :      December 2009 – June 2011
Description    :      Support to the company clients in all models (ASC, onsite, ad-hoc, remote) as           
                                      per the requirement. 

Responsibilities:          
    • Handled the responsibility as an Oracle APPS DBA as well as Core DBA 
    • Managing Concurrent Requests, troubleshoot All Phase/Status of a Concurrent Request.
    • Starting/Stopping Oracle Applications and databases.
    • Form Generation Using Fgen Utility
    • Disable/Enable Concurrent Program and Forms
    • Handling system administrator jobs for the application.
    • Responsibility Mapping to User According To Job Profile
Raised and Followed up Oracle TAR on Severity 1 basis.
    • Installation of oracle software on different platform.
    • Creating database for Production/Testing/Development
    • Database migration and Up gradation
    • Creating new users and manage roles and privileges
    • Creation of Database Objects as per the Requirement
    • Managing Import/Export Depending up on Requirement.
    • Managing Redo logs, Control files, and Tablespaces.
    • Monitoring Users, Tablespaces, rollback segments and tuning SGA.
    • Taking Hot/Cold Backups of databases using VERITAS Netbackup and Legato.
    • Backup of initialization / configuration files, Control files, Password files and archived log files.
    • Testing Recovery Strategies by Simulating Database Crashes on Development Systems.

Organization:    Path Infotech
Designation:    Senior Support Executive
Duration:    Feb’07 till Dec’09

Project Title         :      Path Infotech ltd.   

Client        :     LG Electronics India Limited. Project

Role        :     Oracle DBA and Oracle Apps DBA

Description    :    LG Electronics India Pvt. Ltd., a wholly owned subsidiary of LG Electronics,
South Korea was established in January 1997 in India. LGEIL is using Oracle applications in the key business areas of financials, purchasing, manufacturing, sales and inventory management. I'm responsible for maintenance of 11i Oracle
E-Business Suite on AIX and   to trouble shoot the problems that are encountered in day-to-day activities. It's a 24*7 production database.

Technologies    :     Oracle Applications 11i (11.5.10)

Team Size    :    8 (Including Team Manager from ORACLE) 
Database Versions :      Oracle 8i, 9i, 10g.
OS Platforms          :    AIX, Sun Solaris, Windows
Duration                  :      April 2007 – May 2009

Responsibilities:    
    • Analyzing the client requirements.
    • Handled the responsibility as an APPS DBA as well as Core DBA.                                 
    • Managing Concurrent Requests, troubleshoot All Phase/Status of a Concurrent Request.
    • Starting/Stopping Oracle Applications
    • Form Generation Using Fgen Utility
    • Disable/Enable Concurrent Program And Forms
    • Handled system administrator jobs for the application.
    • Responsibility Mapping to User According To Job Profile
Raised and Followed up Oracle TAR on Severity 1 basis.
    • Cloning of Oracle Application.
    • Adding/Resizing datafiles to the tablespace.
    • Patching on Oracle Apps. Environment using ADADMIN and ADPATCH       
    • Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, Stats pack Reports.
    • Created Oracle / ERP users
    • Managed Oracle Database Backups through RMAN utility. 

Client        :     Deutsche Post Bank Home Finance Limited. Gurgaon

Role        :     Oracle DBA and Oracle Apps DBA 
Description    :    Deutsche Postbank Home Finance Ltd., a National Housing Bank (NHB)  
registered Company is a 100% MNC housing finance company     headquartered in New Delhi. The company is a part of Deutsche Postbank Group, which is the largest retail bank in Germany.
I'm responsible for maintenance of Oracle Application Server 10g R2 on Windows and to deploy application on different OC4J Instances.
Technologies    :     Oracle Application Server 10g R2
Team Size    :    1 
Database Versions:      Oracle 9i, 10g.
OS Platforms         :    Sun Solaris, Windows 2003 Server
Duration                 :       May 2009 – December 2009

Responsibilities:    
    • Handled the Oracle Application Server 10g Release 2 (10.1.2).
    • Installation of Oracle Application Server 10g Infrastructure & Middle-Tier.                               Deployment of J2EE applications on OC4J Instances.
Managed Dataguard in maximum protection mode.
    • Managing Scheduled Database Hot Backup through RMAN on Veritas Netbackup Server. 
    • Managed test Instances and Cloning them on demand of Application developers. 
    • Analyzing and rebuilding database objects.
    • Generating Statspack Report and basic database performance tuning.

Certification: Oracle Certified Associate (September 2008)

Education Qualification: 

 Examination 
School/College/University – Year                                                                            
 B.E (Computer Science)
 Apeejay College of Engineering
 Maharishi Dayanand University (Rohtak) 2002-2006 
 Higher Secondary
 R.S Public School – Karnal
 CBSE  2002
 Secondary
 Dyal Singh Public School – Karnal
 CBSE  2000