SUMMARY:

• Over 5 years of technical experience in Administering Oracle Applications and Oracle production databases that includes designing, developing, deploying, administration, managing, and tuning Databases in Production environments ranging in size up to 20TB on various platforms such as Solaris, Unix, AIX, Linux, Windows etc.
• Expertise in Installation, Configuration, Administration, Upgrading, Cloning, Patching, Admin, Design and maintenance of Oracle Applications 11.5.8,11.5.9,11.5.10 and R12, database 10g/11g.
• Work area mainly includes Database support & maintenance, performance tuning, memory management, query optimization, backup, recovery, up-gradation, database design in RAC and Non RAC environments.
• Troubleshooting Concurrent manager, Apache, Form server, Report server, Workflow and Discoverer services on 11i and R12 of Oracle Apps.
• Worked briefly on various application environments like PeopleSoft, Hyperion, OBIEE, OTO and Fusion Apps.
• Expert level hands on experience in the Installation, configuration, administration, security management, performance optimization etc for Oracle databases.
• Solid command over various Database tools like EXPORT/IMPORT, SQL*LOADER, RMAN, SQL* Plus, OEM, TOAD, TKPROF etc.
• Experience in database administration of OLTP and Data warehousing applications.
• Worked on Standby database/Data Guard, RAC, ASM and RMAN.
• Worked on various new features of 11g like AWR, ADDM, Flashback and data pump.
• Managing backend security, Users, Roles and Privileges.
• Experience in Oracle Apps Sysadmin, Maintenance, Operation and On-call Support.
• Provided 24/7 support of both development and production databases.

TECHNICAL SKILLS:

Apps: Oracle E-Business suite 11i and R12

Databases: Oracle 8i/9i/10g and 11g

Oracle Utilities: RAC, Data guard, RMAN, AWR, ADDM, Oracle EM 10g and Flashback

Operating Systems: Linux, UNIX, Sun Solaris, AIX

PROFESSIONAL EXPERIENCE:

Confidential

Oracle ERP DBA

Responsibilities:

• Maintain Production, Test and Development environment of oracle applications.
• Deploying codes to the application prepared by developer.
• Database upgradation from 11.2.0.2 to 11.2.0.4
• Oracle EBS Platform migration from IBM AIX to Exadata X4.
• Oracle EBS upgradation from 11.5.10.2 to 12.2.3 on Exalogic.
• Migration of database using expdp/impdp from AIX to Linux.
• Clone Database using RMAN active duplicate database.
• Cloning of Oracle E-business 11i and R12.
• Add and remove node on EBS 12.2.3.
• Patching using ADOP on EBS 12.2.3.
• Troubleshooting of Apache, Concurrent manager, Apps listener, Form server and JVM related issues.
• Convert character set from WE8ISO8859P1 to UTF8 using Data Migration Unicode (DMU) 2.0 tool.
• Convert form server from servlet to socket and vice-versa.
• Configure custom forms in R12.
• Setup PCP configuration on R12.
• Worked on AD tools like ADPATCH, ADADMIN, ADCONFIG, ADRELINK etc.
• Tuned long running concurrent requests and sql queries.
• Gather database and applications statistics.
• Managing database and application users accounts.
• Rebuilding standby site and perform switchover and failover activities.

Oracle Apps DBA

Responsibilities:

• Maintain Production, Test and Development environment of oracle applications.
• Installation of Oracle databases 11g and R12 applications using rapidwiz on linux.
• Troubleshooting of Apache, Concurrent manager, Apps listener, Form server and JVM related issues.
• Setup PCP configuration on R12.
• Patching and cloning of oracle R12 applications.
• Worked on AD tools like ADPATCH, ADADMIN, ADCONFIG, ADRELINK etc.
• Tuned long running concurrent requests.
• Gather database and applications statistics.
• Monitor Patching activity using OAM.
• Tuning Oracle database SQL queries using AWR, ADDM, ASH tools.
• Generate trace on various processes and sessions.
• Configure Data guard and data guard broker DGMGRL.
• Maintain Oracle data guard and keep it sync with Primary site.
• Perform switch over and fail over activity and also enable fast start fail over.

Confidential

Oracle Apps DBA / Oracle DBA

Responsibilities:

• Maintain Production, Test and Development environment of oracle applications.
• Complete ownership of 4 R12 EBS instances and maintain availability of oracle applications and 10TB sizes of databases.
• Installation of oracle application using rapid wiz.
• Troubleshooting of Apache, Concurrent manager, Apps listener, Form server and JVM related issues.
• Setup PCP configuration on R12.
• Convert Form server from socket to servlet mode.
• Patching and cloning of oracle applications.
• Experienced in Oracle Apps Administration and Sysadmin tasks.
• Worked on AD tools like ADPATCH, ADADMIN, ADCONFIG, etc.
• Upgrade oracle applications from 11i to R12.
• Installation of web logic server 11g.
• Monitor and maintain size of databases.
• Configure Automatic memory management for SGA and PGA.
• Tuned SQL statements using tkporf, autotrace, explain plan, AWR and ASH reports.
• Setup standby database.
• Compressing the data by using advanced data compression on 11g.
• Troubleshoot standby database, monitor gap between primary and standby.
• Convert standby database into real time apply.

Confidential CA

Oracle Apps DBA / Oracle DBA

Responsibilities:

• Understanding of Oracle Apps architecture.
• Maintaining Production, Development and Test environments of various Oracle Applications.
• Maintain the databases up to 20TB size.
• Trouble shooting Apache server, Jserv, Jinitiator, Forms server, Report server and Discoverer Issues.
• Application and Concurrent Manager load-balancing and Failover, Shared APPL TOP configurations.
• Experienced in Oracle Apps Administration and Sysadmin tasks.
• Troubleshooting MWA services and workflow issues.
• Workflow notifications administration.
• Worked on Discoverer 10g and 11g web logic.
• Maintain availability of Oracle applications and databases.
• Take care of all unplanned Outages for more than 400 Productions instances
• Resolve service requests created by customer or by monitoring tool like (OEM) and meet SLA for these SRs.
• ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH & ADLICMGR.
• Added new product using adsplice.
• Upgrade EBS from 11i to R12 on Linux.
• Cloning and patching using rapid wiz.
• 11i utilities FNDLOAD, WFLOAD.
• Proficient in performance tuning using STATSPACK, TKPROF, AWR, ADDM.
• Monitor database for ORA errors and find the root cause of the alert and fix it.
• Add data files to table spaces for future growth of the database.
• Troubleshoot connectivity issue from application to database.
• Troubleshoot standby database, monitor gap between primary and standby dataguard.
• Estimate sizes of the databases monitor and maintain the size of the databases.
• Convert maximum performance database to maximum availability or maximum productivity mode.
• Configure 10g and 11g SSO with oracle applications.
• Converting standby database to real time apply.
• Worked on managing multiple Databases and underlying database objects such as indexes, triggers, procedures, functions, partitions, packages, cursors, etc.
• Maintain and troubleshoot RAC databases.
• Backup and recovery of Oracle Applications and Oracle databases.
• Configure and maintenance of SCAN listeners.
• Configure, start/stop of ASM instance.
• Create and mount ASM disk groups also add and delete disks in disk group of ASM.
• Taking L0 and L1 backups of the database.
• Responsible of Forming Backup Strategies for getting up to point of data back in case of Failure
• Tuning the PL/SQL for faster execution and better performance of the Database.
• Was shift lead and assigned SR (Service Requests) to other DBA’s and provided solutions to issues to meet SLA.
• Worked briefly on OID, SOA server, Web logic and node manager related issues.
• Troubleshoot on web logic admin server and managed server, server hang and server crash related issues on OBIEE/Fusion apps.
• Troubleshoot Java related memory issues, memory leak issues.
• Configure node manager, add and remove managed servers.
• Scale-up and scale out clustering of managed servers.
• Convert web logic from development to production and vice-versa.

Confidential

Oracle Apps DBA/Oracle DBA

Responsibilities:

• Troubleshooting of Apache server, Jserv, Jinitiator, form server, report server, concurrent manager and Discoverer related issues.
• Experienced in Oracle Apps Administration and Sysadmin tasks.
• Workflow notifications administration.
• Tuned and Fixed Issues Related to JVM and Concurrent
• Load balancing of concurrent manager, Apache, JVM and Form server.
• Cloning and patching using rapid install
• Database Administrator - Involved in Support, Maintenance of Oracle Databases.
• Installed 10g databases on Oracle Enterprise Linux using DBCA.
• Taking cold backup of databases and ensure the integrity of the backups.
• I was responsible to manage 12 database of RTO.
• Maintained the databases ranging from few GB up to 7 TB in size.
• Worked on Tuning database queries and report
• Monitor database for ORA errors and resolve any issues.
• Rebuild indexes periodically to improve performance.
• Deploy new objects into database to support newer version of application.
• Database reorganization. Found migrated and chained rows from database and re-organized table to remove migrated rows.
• Add data files to table spaces to allow future growth of data.
• Worked on Unix scripting and shell scripting.
• Granting and revoking privileges to users.
• Managing Role and permission assignments and authorization.
• Managing password for all user accounts.
• Involved in writing professional Documentation for the Database and other backend objects.
• Worked on Tuning database server, application logic, database objects and sizes for performance improvement