SUMMARY

• 9+Yrs of experience in Oracle R12,11i Apps(Oracle EBS), Oracle Fusion Apps (11.1.4.0.0 ), Oracle Fusion IDM Middleware 11g Components (Weblogic, OAM, ODSM, OIM, OBIEE, SOA) /Oracle DBA.
• Experience in Installation, Setup, Implementation, Customization & Product Support of Oracle Applications 11i (11.5.9, 11.5.10, 11.5.10.2) and R12 (12.0.4, 12.1.3, 12.2.4).
• Experience in Installation, Configuration and Integration of Oracle Fusion Apps (11.1.4.0.0 ) wif Oracle Fusion IDM Middleware 11g Components (Weblogic, OAM, ODSM, OIM, OBIEE, SOA).
• Upgrading Oracle Ebiz from 11.5.10.2 to 12.0.4 /11.5.9.2 to 12.1.1 / 12.1.1 to 12.1.3 / 12.1.3 to 12.2.4
• Upgrading Oracle Database from 9.2.X to 10.2.X and 10.2.X to 11.1.X, 10.2.X to 11.2.X and 11.2.x to 12.1.0.2
• Cloning of Oracle Application R12(12.1.3,12.2.4) through Rapid Clone.
• Experience on various Financial modules such as AR, AP, GL, PO, OM and INV.
• Configured teh Shared APPL TOP and PCP(Load Balancing) Oracle R12.
• Integrated Oracle Applications 11i/R12 wif Oracle Internet Directory and SSO.
• Strong Experience wif Application database Administration Utilities (AD Utilities).
• Strong experience in Creating Users, Responsibilities, Menus and Form Functions (Sys Admin) and Knowledge of Application Object Library (AOL).
• Registering Concurrent Programs wif Concurrent Managers, Registering of Reports and Creation of Additional Concurrent Managers and Maintenance.
• Experience in changing Application user passwords using FNDCPASS utility.
• Oracle Dataguard and standby database Setup.
• Cloning of databases from RAC to RAC and RAC to non - RAC.
• Configuring Load balancing (Client/Server side) and failover wif TAF in Oracle 11g R2(11.2.0.3) RAC.
• Adding and Deleting Nodes to existing RAC database.
• Created ASM disk group to store database files.
• Management of schemas, objects & Partitioning teh tables & indexes.
• Managed large databases in 24/7 Production Environments.
• Worked as DBA on diverse platforms on Oracle Databases covering HP-UNIX, IBM AIX, SUN Solaris, Linux.
• Experience in teh creation of Database Links.
• Experience in database security patch management, upgrading oracle RDBMS to higher versions which includes RAC and non RAC environments.
• Troubleshooting expertise for all tiers (client, middle-tier, database)
• Create and Maintaining teh Technical Notes and Documentation.
• Efficient Team Player, hard working, good in analytical and logical problem solving abilities wif excellent communication skills.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux 4/5, Oracle Enterprise Linux 5.6, UNIX (HP UX 11/10.1/10.20 , Solaris 8/2.4/2.6/2.7 , IBM AIX 5L/4.3), MS-WINDOWS XP/2000.

Database: ORACLE 12C,11g/10g (10.2.0.3), 9i (9.2.x)

Application Servers: 10gAS (10gR2, 10gR3), IAS (10222), Oracle Fusion IDM Middleware 11g Components (Weblogic, OAM, ODSM, OIM, OBIEE, SOA)

Backup Tools(MML): Symantec Netbackup 6.5, Symantec Backup Exec 12.5, Oracle Secure Backup 10.4

Programming Languages: SQL, Unix Shell Scripting

Applications(EBS): Oracle Applications R 12 12.2.4/12.1.3/12.1.1/12/0. x, 11i (11.5.9, 11.5.10,11.5.10.2), Oracle Fusion Apps (11.1.4.0.0 )

GUI: OAM, OEM.

Tools: and Utilities: Oracle Tools OEM/OAM, ASM,SRVCTL,CRSCTL,SQL*PLUS Quest Software (TOAD),SQL Developer etc

Advanced Technology: Distributed Databases (Materialized views), High Availability Options (Real Application Cluster (RAC) and Standby Databases) and Performance (Database, locking, parallel execution, partitions and SQL tuning)

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

Sr.Oracle Apps DBA Consultant

Responsibilities:

• Maintained teh Oracle Applications instances R12 & 11i in multi node environment.
• Upgraded Oracle Applications 12.1.3 to 12.2.4 in multi node environment.
• Administration of EBS 11i/R12 and Database like patching, cloning/refreshes, trouble shooting performance and other issues.
• Upgraded Databases and Grid Control from Oracle 11g (11.2.0.3) to 12C (12.1.0.2) both standalone and RAC Databases.
• Applying Applications Patches.
• Cloning of Oracle Application R12(12.1.3,12.2.4) through Rapid Clone.
• Used AD Utilities like ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR, ADOP(online patching).
• Administration of Concurrent Managers and Concurrent Processing.
• Implemented Shared APPL TOP
• Worked on managing users, menus, responsibilities and other sysadmin responsibilities.
• Worked on bouncing teh workflow mailer services depends on requirements.
• Experience working on RMAN Backups and recovery procedures.
• Worked in environments wif ASM Storage system, Cooked file system and RAW file systems.
• Worked on setting up High Availability of teh database using RAC, Standby, Data guard.
• Worked on resolving connectivity issues related to TNS entries and SQLNET.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, ASH,AWR, ADDM.
• Worked using export/import of schemas, tables etc., as per requirements.
• Created ASM disk group to store database files.
• Supported multiple production, test and dev environments concurrently.

Environment: Oracle Applications 11i (11.5.10.2), R12(12.1.3,12.2.4), Oracle 11g/12C(DB and Grid Control) RHEL -6, OEM, Toad.

Confidential, Topeka, Kansas

Sr.Oracle Apps DBA Consultant

Responsibilities:

• Installing, Configuring and Integrating wif Oracle Fusion 11g (11.1.1.7) IDM Middleware Components (Weblogic, OAM, ODSM, OIM) wif Oracle Application Express (3.1.1.00.09 ).
• Configured teh schemas for OID, OAM and OIM using Oracle Repository creation utility (RCU).
• Installed, configured and integrated System components (OHS, OID, OVD, ODS) wif Fusion middleware Java components (Weblogic, OAM, OIM, SOA).
• Installing Oracle HTTP Server 11.1.1.7.
• Installing Directory Services Components (OID / OVD) 11.1.1.7.
• Validated teh installation of teh OID, OVD instance using ldapbind command.
• Creating a policy store property file and using teh idmConfigTool, to configure teh Policy store for different components.
• Creating Adapters in Oracle Virtual Directory and validating both Changelog Adapter and User Adapter using ldapsearch command.
• Configure OID/OVD parameters for better performance through Oracle Fusion Middleware control (Enterprise Manager).
• Troubleshooting teh issues wif OID and OVD during teh Configuring phase.
• Taking teh snapshot backup of Fusion Middleware components (Weblogic, OAM,OIM,OID,OVD).
• Managing teh Fusion Middleware components through Weblogic Admin Console and Oracle Fusion Middleware control (Enterprise Manager).
• Troubleshooting teh issues wif Fusion IDM Components.
• Raising SR's to Oracle and responding to SR's on teh issues.

Environment: Oracle Applications Express (3.1.1.00.09 ), Oracle Apps R12 (12.1.3), Oracle Fusion IDM Middleware 11g Components (Weblogic, OAM, ODSM, OIM, SOA), Solaris Sparc 10, Oracle 11g, OEM, SQL*plus, Toad.

Confidential, Kansas City

Technical Lead

Responsibilities:

• Upgraded Oracle Applications 11.5.9 to 12.1.3 in multi node environment.
• Database Upgrade from oracle 11g 11.1.0.7 to 11.2.0.3 and Re-Organization of data through Datapump method (expdp & impdp utilities).
• Installed and Upgraded RAC from 10.2.0.4 to 11.2.0.3.
• Applying Applications Patches.
• Cloning of Oracle Applications R12.
• Custom code migrations and related setups on EBS.
• Created custom tops.
• Bouncing teh Apache and Workflow Notification Mailer services based on requirement.
• Reset ORACLE schema passwords by using FNDCPASS.
• Installation and Configuration of OBIEE 11g.
• Experience on various Financial modules such as AR, AP, GL, PO, OM and INV.
• Bouncing teh OBIEE instances as per requirement.
• Worked using export/import of schemas, tables etc., as per requirements.
• Worked on managing users, menus, responsibilities and other sysadmin responsibilities.
• Worked on resolving connectivity issues related to TNS entries and SQLNET.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
• Troubleshoot problems wif web server, forms server and concurrent managers.
• Experienced in handling regular maintenance tasks like Purging Concurrent manager log files.
• Database backups and recovery by using RMAN Utility.
• Experience in teh creation of Oracle Applications Database Links.
• Responding to Oracle support for teh raised SR (service request or TAR) (depending on severity level).

Environment: Oracle Applications 11i (11.5.9, 11.5.10.2), R12, Oracle 10g, IBM AIX OEM, SQL*plus, SQL Loader, Toad.

Confidential, Hanover, Maryland

Technical Lead

Responsibilities:

• Maintained teh Oracle Applications instances 11.5.10.2 in multi node environment.
• Applying Applications Patches.
• Administration of Concurrent Managers and Concurrent Processing.
• Experience working on RMAN Backups and recovery procedures.
• Worked using export/import of schemas, tables etc., as per requirements.
• Worked on managing users, menus, responsibilities and other sysadmin responsibilities.
• Defined Executables, Concurrent Programs, Request Sets.
• Created ASM disk group to store database files.
• Installed, Configured and Integrated Oracle Fusion Apps (11.1.4.0.0 ) wif Oracle Fusion IDM Middleware Components (Weblogic, OAM, ODSM, OIM, and SOA) on Dell RAC Mounted server (single server).
• Installed Oracle database software, database creation and applied teh patches wif opatch.
• Installed Oracle Fusion IDM Middleware Components and applied teh patches wif opatch.
• Configured teh schemas for OID, OAM and OIM using Oracle Repository creation utility (RCU).
• Installed, configured and integrated System components (OHS, OID, OVD, ODS, BI) wif Fusion middleware Java components (Weblogic, OAM, OIM, SOA).
• Upgraded Oracle HTTP Server 11.1.1.2 to 11.1.1.5.
• Upgraded Directory Services Components (OID / OVD) from 11.1.1.2 to 11.1.1.5.
• Validated teh installation of teh OID, OVD instance using ldapbind command.
• Creating a policy store property file and using teh idmConfigTool, to configure teh Policy store for different components.
• Installed, Configured and Integrated Oracle Fusion Apps through Provisioning utility wif Oracle Fusion IDM Middleware Components.
• Bouncing teh Fusion Apps, IDM Components through Weblogic Console or FMW Control (EM) or through Node manager or through fastartstop.sh.
• Done teh Fusion Applications patching using FAPMGR Utility.
• Creating admin users of each IDM Components and registering in Weblogic to make sync wif IDM Components.
• Resetting teh password for admin user and normal users through ODSM and OIM and resetting teh password policy through OIM Designconsole.
• Taking teh backup after each and every component installed.
• Troubleshooting teh issues wif Fusion IDM Components and Oracle Fusion Apps during Provisioning.
• Raising SR's to Oracle and responding to SR's on teh issues.

Environment: Oracle Applications 11i (11.5.10.2), Oracle Fusion Apps (11.1.4.0.0 ), Oracle Fusion IDM Middleware 11g Components (Weblogic, OAM, ODSM, OIM, SOA), RHEL - 4.0 Oracle 10g, OEM, SQL*plus, SQL Loader, Toad.

Confidential, Alpharetta GA

Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to R12 (12.0.4) in multi node environment.
• Applying Applications Patches wif adpatch.
• Cloning of Oracle Applications R12.
• Created teh custom tops.
• Create custom concurrent requests.
• Reset ORACLE schema passwords by using FNDCPASS.
• Changing forms mode from servlet to Socket and vice versa.
• Worked on Oracle Applications AD Utilities like adrelink, adadmin, adctrl, ad splicer etc.
• Applications AOL object setup (users, menus, responsibilities, Form Functions).
• Troubleshoot problems wif web server, forms server and concurrent managers.
• Relinking Oracle applications programs and regeneration of Oracle Forms and Reports.
• Experienced in handling regular maintenance tasks like Purging Concurrent manager log files.
• Monitored teh Applications and database using OEM and OAM.
• Knowledge in configuring a shared APPLTOP.
• Implementation of Dataguard (Physical Standby database for Test & Prod instances).
• Database backups and recovery by using RMAN Utility.
• Experience in teh creation of Oracle Applications Database Links.
• Worked on Partitioned tables(Hash and Range) and indexes
• Worked on Materialized views in synchronizing teh database tables.
• SQL query analyzing wif explain plan and tuning.
• Responding to Oracle support for teh raised SR (service request or TAR) (depending on severity level).

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 10g, Sun Solaris8, HP-Unix 11.0 OEM, SQL*plus, SQL Loader, Toad.

Confidential, Washington, D.C

Oracle Apps DBA

Responsibilities:

• Maintained teh Oracle Applications instances 11.5.10 in multi node environment.
• Cloning of Oracle Applications.
• Applying Applications Patches.
• Performed Application admin tasks using ADADMIN utility.
• Creating teh Application users through Sysadmin.
• Monitoring concurrent jobs for Oracle Applications.
• Administration of Concurrent Managers and Concurrent Processing.
• Bouncing teh Apache and Workflow Notification Mailer services.
• Maintenance tasks like Purging Concurrent manager log files.
• Created and resized teh new Datafiles.
• Created database links for maintenance of distributed databases.
• Alert log file monitoring.
• Worked wif Oracle Support on resolution of SRs

Environment: Oracle Applications 11i (11.5.10.2), Oracle 10g, RHEL 4.0, OEM, SQL*plus, SQL Loader, Toad.

Confidential, Norwood, MA

Oracle DBA

Responsibilities:

• Experienced in Installing Oracle 9i, 10g and upgraded database from 9.2.0.6 to 10.2.0.4.
• Created and managed different kinds of tablespaces, space issues, and extent and storage parameters.
• Experience in using export and import utilities like exp, imp Commands in 9i and data pumping in 10g wif commands like expdp, impdp.
• Adding new user accounts, creating profiles, roles and assigned them to different users.
• Worked using export/import of schemas, tables etc., as per requirements.
• Worked on resolving connectivity issues related to TNS entries and SQLNET.
• Taking Cold and Hot backups of teh database regularly using user managed method RMAN utility.
• Cloning oracle databases.
• Creating teh Manual database.
• Update, remove, add parameters in init SID.ora file. .
• Knowledge on Flashback tables.

Environment: Oracle 10g/9i, RHEL 4.0, OEM, SQL*plus, SQL Loader, Toad.