We provide IT Staff Augmentation Services!

Sr.oracle Apps Dba Consultant Resume

3.00/5 (Submit Your Rating)

San Jose, CaliforniA

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 ) with 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 the Shared APPL TOP and PCP(Load Balancing) Oracle R12.
  • Integrated Oracle Applications 11i/R12 with Oracle Internet Directory and SSO.
  • Strong Experience with 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 with 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 with 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 the 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 the 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 the Technical Notes and Documentation.
  • Efficient Team Player, hard working, good in analytical and logical problem solving abilities with 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 the 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 the workflow mailer services depends on requirements.
  • Experience working on RMAN Backups and recovery procedures.
  • Worked in environments with ASM Storage system, Cooked file system and RAW file systems.
  • Worked on setting up High Availability of the 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 with Oracle Fusion 11g (11.1.1.7) IDM Middleware Components (Weblogic, OAM, ODSM, OIM) with Oracle Application Express (3.1.1.00.09 ).
  • Configured the schemas for OID, OAM and OIM using Oracle Repository creation utility (RCU).
  • Installed, configured and integrated System components (OHS, OID, OVD, ODS) with 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 the installation of the OID, OVD instance using ldapbind command.
  • Creating a policy store property file and using the idmConfigTool, to configure the 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 the issues with OID and OVD during the Configuring phase.
  • Taking the snapshot backup of Fusion Middleware components (Weblogic, OAM,OIM,OID,OVD).
  • Managing the Fusion Middleware components through Weblogic Admin Console and Oracle Fusion Middleware control (Enterprise Manager).
  • Troubleshooting the issues with Fusion IDM Components.
  • Raising SR's to Oracle and responding to SR's on the 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 the 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 the 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 with 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 the creation of Oracle Applications Database Links.
  • Responding to Oracle support for the 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 the 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 ) with 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 the patches with opatch.
  • Installed Oracle Fusion IDM Middleware Components and applied the patches with opatch.
  • Configured the schemas for OID, OAM and OIM using Oracle Repository creation utility (RCU).
  • Installed, configured and integrated System components (OHS, OID, OVD, ODS, BI) with 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 the installation of the OID, OVD instance using ldapbind command.
  • Creating a policy store property file and using the idmConfigTool, to configure the Policy store for different components.
  • Installed, Configured and Integrated Oracle Fusion Apps through Provisioning utility with Oracle Fusion IDM Middleware Components.
  • Bouncing the Fusion Apps, IDM Components through Weblogic Console or FMW Control (EM) or through Node manager or through fastartstop.sh.
  • Done the Fusion Applications patching using FAPMGR Utility.
  • Creating admin users of each IDM Components and registering in Weblogic to make sync with IDM Components.
  • Resetting the password for admin user and normal users through ODSM and OIM and resetting the password policy through OIM Designconsole.
  • Taking the backup after each and every component installed.
  • Troubleshooting the issues with Fusion IDM Components and Oracle Fusion Apps during Provisioning.
  • Raising SR's to Oracle and responding to SR's on the 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 with adpatch.
  • Cloning of Oracle Applications R12.
  • Created the 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 with 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 the 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 the creation of Oracle Applications Database Links.
  • Worked on Partitioned tables(Hash and Range) and indexes
  • Worked on Materialized views in synchronizing the database tables.
  • SQL query analyzing with explain plan and tuning.
  • Responding to Oracle support for the 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 the 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 the Application users through Sysadmin.
  • Monitoring concurrent jobs for Oracle Applications.
  • Administration of Concurrent Managers and Concurrent Processing.
  • Bouncing the Apache and Workflow Notification Mailer services.
  • Maintenance tasks like Purging Concurrent manager log files.
  • Created and resized the new Datafiles.
  • Created database links for maintenance of distributed databases.
  • Alert log file monitoring.
  • Worked with 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 with 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 the database regularly using user managed method RMAN utility.
  • Cloning oracle databases.
  • Creating the 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.

We'd love your feedback!