We provide IT Staff Augmentation Services!

Oracle Apps Dba Resume

2.00/5 (Submit Your Rating)

El Segundo, CA

SUMMARY:

  • Confidential is a Senior Oracle DBA with 18 years of IT Industry experience with strong emphasis in Oracle.
  • Confidential has valuable expertise in planning and designing implementation strategy, upgrades, migration strategy, instance and integration strategy, and building robust systems on Premise and on Cloud Infrastructure (AWS and Oracle Cloud).
  • He has very strong knowledge of database management/monitoring, performance tuning, and reorganization; cloning and migrating Oracle databases across different platforms, upgrades, patching, as well as installing and configuring Oracle EBS Applications (R12/11i) with Oracle Real Application Clusters 11gR2 and 10gRAC. He has vast experience in Fusion Middleware applications such as Oracle Identity Management (SSO/OID/OAM), SOA/BPEL, Webcenter Portal and Weblogic.
  • He has also vast programming experience with Oracle PL/SQL, Forms, Reports, Oracle ADF/Java Framework and XML Publisher.
  • Confidential has extensive experience in High Availability (HA) with Oracle DataGuard and database replication with GoldenGate.
  • Confidential also has experience with migration, maintenance and management with Oracle Exadata V2 running a BI/Datawarehouse environment, as well as OBIEE 10/11g, Informatica, DAC, OWB and OBIA, and also implementation of Oracle Enterprise Manager Cloud Control 12c.
  • He has diverse skillsets and experience from various database technologies such as MySQL, MS - SQL, Sybase, Oracle and Exadata, as well as applications such as Remedy, Peoplesoft, Banner, Intergraph, Business Objects, Kofax Markview, Hyperion, Informatica, OBIEE and Oracle EBusiness Suite.

PROFESSIONAL SKILLS:

Oracle EBS Applications DBA R12.2/12/11i/10.7 (Financials Projects, iProcurement, WIP, OM and HCM)

Fusion Middleware (Oracle OIM/OID/SSO, OAM, Portal, WebLogic)

Oracle OBIEE 10g/11g, Informatica Powercenter, DAC, Warehouse Builder, OBIA

Oracle Database 12c/11G/10G/9i/8i/7.3 RAC High Availability with Data Guard

Oracle Exadata V2, Oracle Goldengate and Oracle Enterprise Manager Cloud Control 12c

Oracle Forms & Reports 11g/10g/9i/6i/6/5/4.5

Peoplesoft 9.1 HCM and Finance

Kofax Markview, integration with Oracle Weblogic and R12

Business Objects XI R2 / 6.5, Hyperion Analytic Services 9.1, Remedy ARS ITSM /OS3, Intergraph G/Technology

MS SQL Server 2012, 2008, Sybase

Oracle VM, HP UX, IBM AIX, SUN Solaris, Red Hat Linux, Oracle EL

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Oracle Apps DBA

Responsibilities:

  • Maintained and Management of Oracle databases on DEV, CRP, UAT and PROD environments
  • Lead Oracle DBA/Architect of EBS R12.2.6 implementation design, capacity planning and high availability requirements.
  • Setup and configure EBS R12.2.6 DEV, CRP, UAT and Production environments
  • Setup cloning procedures on EBS R12.2.6 environments.
  • Performance tuning of batch program and long running reports.
  • Apply patches and bug fixes on Oracle R12.2.6 Apps instances
  • Installed and configured Oracle Weblogic 11g for SOA integration with Oracle EBS R12.2.6 instance for SOA/BPEL for interface program
  • Integration Oracle EBS R12.2 instance with Oracle BI Cloud Service (BICS)
  • Install and Configure Oracle EBS OLM Content Server
  • Integration with 3rd party ODBC connection with SQL Server database
  • Maintained, managed and administration of Oracle R12 multi-node environment
  • Management and monitoring Oracle R12 instance using Oracle Enterprise Manager Cloud Control 12c.

Environment: (Oracle EBS R12.2.6, Weblogic, SOA/BPEL Oracle BI Cloud Service, Enterprise Manager Cloud Control 12c)

Confidential, El Segundo, CA/Middleton, WI

Lead Oracle DBA

Responsibilities:

  • Plan and design the implementation of Oracle Single SignOn solution for Oracle EBS R12 environment
  • Install and configure Oracle Single SignOn on CNV1 EBS instance and TMGT UAT instance.
  • Install and configure OID in non-clustered and clustered environment for High Availability
  • Configure F5 LB for HA for Oracle SSO Production Environment
  • Customized OAM for Confidential client interface requirements
  • Install and configure Oracle Access Manager in a non-clustered and clustered environment.
  • Configure the OID and MS AD integration for SSO, provisioning and synchronization.
  • Integrated and configured OHS WebTier, WebGate, Access Gate, Access Manager and OID in a non-clustered and clustered environment for High Availability
  • Oracle SSO integration with Oracle EBS R12

Environment: (Oracle EBS R12.1.3, Oracle 12c RDBMS, Oracle Fusion Middleware 11g, Oracle Weblogic 11g, Oracle Access Manager 11g, Oracle OID 11g, Red Hat Enterprise Linux 5.11 Tikanga)

Confidential, Houston, TX/Columbus, OH

Oracle Apps DBA

Responsibilities:

  • Upgrade of Oracle database 11gR2 to 12.1.0.2 version.
  • Upgrade of Oracle EBS R11.5.10.2 to Oracle EBS R12.2.4 in Oracle Enterprise Linux 5.11 and 7.2 split tier environment for Confidential US
  • Maintained the R12.2.4 CRP, UAT and Production instances in a shared appltop and multi-tiered environment
  • OATM migration of Oracle EBS R11.5.10.2 environment running on 11gR2 RDBMS
  • Installation and configuration of Oracle EBS R12.2.4 Vision instance.
  • Setup cloning procedures on EBS R12.2.4 environments.
  • Performance tuning of batch program and long running reports.
  • Patching strategies using adop for Oracle EBS R12.2.4 environments.
  • Upgrade Discoverer 4i to Discoverer 11g
  • Upgrade of Oracle EBS R11.5.10.2 to Oracle EBS R12.2.4 on Enterprise Linux 7.2 environment for Nifco America
  • Maintained and managed DMZ for iStore and iSupplier EBS R12
  • Implement and managed Oracle EBS VCP R12.2.4.1

Environment: (Oracle EBS R12.2.4, Oracle EBS 11.5.10.2, Oracle Weblogic, Oracle 11gR2 RDBMS, Oracle RDBMS 12c, Oracle Enterprise Cloud Control 12c, Oracle Discoverer 11g OEL 5.11 and OEL 7.2)

Confidential, Miami, FL

Oracle Apps DBA

Responsibilities:

  • Install and configure Oracle RDBMS 12c RAC on AWS Cloud
  • Plan and design the implementation of Oracle Fusion Apps 11.1.8 on AWS Cloud environment
  • Install and configure Oracle Fusion Applications 11.1.8 on AWS Cloud
  • Maintained, managed and administration of Oracle Fusion Applications 11.1.8 on AWS Cloud environments.
  • Apply patches and fixes on Oracle Fusion Applications 11.1.8 POC and Development instance
  • Install and configure Oracle EBS 12.2.5 on AWS Cloud
  • Install and configure Oracle EBS 12.2.5 on Oracle Cloud
  • Proof of concept migration of On-premise Oracle database to Oracle Cloud
  • Integrate Oracle EBS database with Oracle Cloud database using Oracle GoldenGate Cloud Service
  • Plan and design the implementation of Oracle EBS R12.2.4 Supplier Data Hub.
  • Install and configure R12.2.4 in Dev, Test and Production.
  • Cloning and migration of Oracle R12.2.4 Apps instances across multiple environments.
  • Maintained, managed and administration of Oracle R12.2.4 in multi-node environments.
  • Apply patches and bug fixes on Oracle R12.2.4 Apps instances
  • Establishment and documentation of cloning and refresh strategy of R12.2.4 instances.
  • Create automated cloning and refresh scripts for R12 instances.
  • Provide capacity planning strategy for EBS R12 Infrastructure.
  • Provide management and support for Reusable SOA Framework project
  • Analysis and design for Fusion Middleware SOA Framework architecture
  • Provide an architecture that will integrate with WFS’s existing SOA Development effort, but has the flexibility, capacity, and “future proofing” to perform integration with WFS Customer & Partners community if required.
  • Implementation of Resuable SOA Framework that includes 2 Trading Partners, 2 Inbound SOA Transactions, EBS integration, and BAM Dashboards & OER setup

Environment: Oracle EBS R12.2.4, Oracle 11gR2/12c RDBMS, Oracle10gAS, Oracle Fusion Middleware 11g, Oracle Cloud Service, AWS Cloud, Oracle GoldenGate Cloud Service, Oracle Enterprise Linux 6, Oracle Enterprise Manager Grid Control 12c

Senior Principal Consultant

Confidential, Houston, TX

Responsibilities:

  • Oracle Database characterset conversion from US7ACII to UTF8.
  • Primary DBA responsible for building and managing Oracle EBS R12 and 11i Release 11g RDBMS.
  • Installed, patched and upgrade databases from Oracle 11.2.0.3 to 11.2.0.4 DB versions.
  • Plan and design the implementation of Oracle Webcenter Portal 11g and integration with Oracle IDM SSO with Access Manager
  • Install and configure Fusion Middleware product Weblogic 10.3.6, database repository schemas, OIM, OID, WebTier, Webgate and Oracle Access Manager
  • Upgrade Oracle Portal 10g to Oracle Webcenter Portal 11g.
  • Lead role in designing and re-engineering of S&B’s current reporting strategy and as well integrating their existing custom Oracle forms and reports with Oracle Webcenter Portal
  • Redeveloped and performance tuning of custom Oracle PL/SQL batch programs
  • Remediate Oracle Forms and Reports 10g custom programs
  • Implement instance strategy for Oracle R12 EBS upgrade environments
  • Lead DBA for the upgrade of Oracle EBS R11.5.10.2 to R12.1.3 for CRP1, CRP2 and UAT in Solaris 10 and 11
  • Migrated R11i and R12 instance from Solaris 10 to Solaris 11.
  • Installation and configuration of Oracle R12 and 11i Application and databases.
  • Applied patches RUPs, minipacks, family packs and bug fixes on Oracle EBS R12 and 11i Apps instances.
  • Cloning and migration of Oracle EBS R12 and 11i Apps instances across multiple environments.

Environment: Oracle Fusion Middleware - Oracle Webcenter 11g, Oracle Weblogic, Oracle EBS R12.1.3, Oracle10gAS, Oracle Webcenter Portal 11g, Oracle 11gR2 RDBMS, Active Directory, Kerberos, Solaris 10/11

Confidential, Houston TX

Oracle Apps DBA

Responsibilities:

  • Plan and design the implementation of Confidential ’s High Availability requirements with Oracle Dataguard 11g using Oracle Enterprise Manager Cloud Control 12c
  • Setup and configure Oracle Enterprise Manager Cloud Control 12c for Enterprise database management, monitory and maintenance with Dataguard.
  • Install and configure Oracle Weblogic 10.3.6 and repository database.
  • Build HCMPRD (Peoplesoft 9.1) Primary Standby database (local in Datacenter) and Secondary Standby database in remote Datacenter using Oracle Dataguard 11gR2 with OEM 12c.
  • Configure Fast Failover between Primary and Standby Oracle 11gR2 databases.
  • Implement Oracle 11g Dataguard Observer for seamlessly and automatic failover to Standby database in case of failure or disaster with Dataguard broker.
  • Configure Peoplesoft 9.1 HCM application for Transparent Application Failover to Primary Standby in case of Disaster, as well as to Secondary Standby in case of Disaster in Primary Datacenter.

Environment: (Peoplesoft 9.1 HCM, Oracle 10g RDBMS, Oracle 11gR2 RDBMS, Oracle Dataguard, IBM AIX 7.1, Oracle Weblogic, and Oracle Enterprise Manager Cloud Control 12c)

Senior Oracle DBA

Confidential, Denver, CO

Responsibilities:

  • Implementation and upgrade strategy for Oracle 10g SSO to Oracle 11g IDM SSO with Access Manager, and integration with Active Directory
  • Lead the team in building new environments and coordination with offshore team
  • Install and configure Single Sign-On using Oracle Identity Management (Oracle Access Manager, Oracle WebGate and Oracle Internet Directory) release 11g.
  • Integrate Oracle Internet Directory with Oracle E-Business Application R12.1.3 instance.
  • Integrate Oracle Access Manager with Oracle OID and define policies.
  • Integrate Oracle Access Manager with Oracle E-Business Suite Application 12.1.3.
  • Integrate LDAP MS Active Directory with Oracle Internet Directory.
  • Implement SSL on Oracle SSO and EBS Production Environment
  • Migration strategy for Oracle R12 EBS Production environment from Oracle On-Demand Datacenter to ITC Managed Datacenter
  • Migrate EBS R12 instance from Oracle On-Demand Datacenter to ITC Datacenter.

Environment: (Oracle Fusion Middleware - Oracle Identity Management (Oracle Access Manager, WebGate, SSO/OID, Weglogic, Oracle EBS R12.1.3, Oracle 10g/11g RDBMS, Dataguard, Active Directory, Kerberos, Oracle Linux)

Confidential

Oracle Apps DBA

Responsibilities:

  • Upgrade of Oracle database 10g RAC to 11gR2 RAC
  • Primary DBA responsible for building and managing Oracle EBS R12 and 11i, 10g RDBMS and 11gRAC databases.
  • Worked with Functional and Development resources to review and fix application and database issues/bugs.
  • Lead the team in managing critical issues, and coordinating with client management with action plans
  • Managing tasks between offshore and US resources for timely and crystal clear handover to ensure 24/7 operation.
  • Migration of Oracle EBS 11i instance from OOD (Oracle On Demand) environment to ITC Managed Services.
  • Maintained, managed and administration of Oracle R12 multi-node environment and 11i environment integrated with various applications such as KofaxMarkView, GRC, SOA/BPEL, Vertex and Hyperion.
  • Installed and configured Fusion Middleware Weblogic with SOA/BPEL and Markview.
  • Managed and troubleshoot issues, and work closely with client end-users to faster resolution and documentation.
  • Upgrade of Oracle EBS R11.5.10.2 to R12.1.3 on DMWACI, TMWACI and PMWACI instances for Manitowoc.
  • Installation and configuration of Oracle R12 and 11i Application and databases.
  • Applied patches RUPs, minipacks, family packs and bug fixes on Oracle EBS R12 and 11i Apps instances.
  • Cloning and migration of Oracle EBS R12 and 11i Apps instances across multiple environments.

Environment: (Oracle EBS R12 (12.1.3), Oracle EBS 11.5.10.2, Oracle Fusion Middleware (Oracle Identity Management, SOA/BPEL/Weblogic), Oracle GRC, Markview, Vertex O’ Series, Oracle 10g RAC, Oracle 11gR2 RDBMS, Oracle VM)

We'd love your feedback!