SUMMARY:

• Confidential is a Senior Solutions Architect - 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).
• 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.
• He has vast experience in Fusion Middleware applications such as Oracle Identity Management (SSO/OID/OAM), SOA/BPEL, Webcenter Portal and Weblogic.
• 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 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.

PROFESSIONAL SKILLS:

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

Oracle Exadata V2 and Oracle Goldengate

Oracle Enterprise Manager Cloud Control 12c

Oracle EBS Applications R12.2/12/11i/10.7

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

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

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

Oracle Financials (GL, AP, AR), Projects, iProcurement, WIP, OM and HCM

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

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 with SOA/BPEL for interface program
• 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, OEL 7.2, RDBMS 12c, Enterprise Manager Cloud Control 12c)

Confidential

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.
• Apply patches Oracle EBS patches for OID integration.
• 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

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

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
• Plan and design the implementation of Oracle EBS R12.2.4 Supplier Data Hub.
• Provide lead role in designing system architecture for EBS R12.2.4
• Install and configure R12.2.4 in Dev, Test and Production.
• Implement instance strategy for R12.2.4 environments.
• 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 analysis and support for the existing EBS R11i archiving strategy
• Provide management and support for Reusable SOA Framework project
• Migration of SOA Framework components to multiple environments
• 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 RDBMS, Oracle10gAS, Oracle Fusion Middleware 11g, Oracle Weblogic 11g, Oracle Sun Solaris 11, 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

Responsibilities:

• Plan and design the implementation of Confidential 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

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, New York

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) Application, Oracle EBS 11.5.10.2, Oracle Fusion Middleware (Oracle Identity Management, SOA/BPEL and Weblogic), Oracle GRC, Markview, Vertex O’ Series, Oracle 10g RAC, Oracle 11gR2 RDBMS, Oracle VM, Oracle Enterprise Linux)

Confidential

Senior Oracle DBA

Responsibilities:

• Provide leadership in designing system architecture for PCI Compliance implementation
• Lead role in RAC database design, capacity planning, database tuning and system architecture
• Oracle11g RAC ASM Database monitoring, performance, tuning and reorganization
• RAC to RAC, RAC to non-RAC and non-RAC to RAC cloning of Oracle R12 environments
• Management and monitoring Oracle R12 instance using Oracle 11G Enterprise Manager Grid Control.
• Migrate Oracle EBS R12.1.3 from 11gR2 RAC to Oracle Exadata V2.
• Install and configure Oracle GoldenGate for data replication.
• Configure data replication between Oracle Datawarehouse database and EBS
• Lead role in designing system architecture for EBS R12 implementation for North America, Canada and EMEA
• Provide training and mentoring for client DBA staff in management of R12 databases
• Conducted Oracle 11g Performance Tuning for application developers
• Developed coding standards, documented cloning process and database design procedures
• Installed and configured Oracle Weblogic 11g for SOA integration with Oracle EBS R12 instance.
• Installation and configuration of Oracle R12 Applications and databases
• Applied patches RUPs, minipacks, family packs and bug fixes on Oracle R12 Apps instances
• Cloning and migration of Oracle R12 Apps instances across multiple environments
• Configure Oracle EBS R12 environment for PCI Compliance
• Install, configure and managed Oracle R12 MWA / WMS.
• Maintained, managed and administration of Oracle R12 multi-node environment
• Management of Oracle Exadata running on BI/Datawarehouse environment

Environment: (Oracle ERP R12 (12.1.3) Application, Oracle 11gR2 RAC ASM, Oracle Exadata V2, Oracle 11G Enterprise Manager Grid Control, Oracle Enterprise Linux, IBM AIX)

Senior Oracle DBA

Confidential

Responsibilities:

• Responsible for building and managing Oracle databases for the following applications: Oracle 11i ERP, Oracle IM/OID/SSO, MDSI Advantex, Remedy, Intergraph, Metasolv, Oracle Communications ASAP, Business Objects XI R2, Hyperion, Geneysis, Siebel 7.8, Informatica PowerCenter 8.11, Comverse Kenan/BP, NetCool/Proviso
• Configured, installed, managed and administer Business Objects XI application and DB
• Configured, installed, managed and administer Remedy ARS 7 and DB, High Availability and Load Balancing
• Oracle Database cloning, monitoring, performance tuning, reorganization, migration and upgrade
• Configured Oracle Database DataGuard environment for Oracle 11i database
• Installation and configuration of Oracle 11i Application and databases
• Maintenance and management of Oracle11i dev, test, UAT and production DBs
• Applied patches minipacks, family packs and bug fixes on Oracle 11i Apps instances
• Cloning and migration of Oracle11i Apps instances across multiple environments
• Setup and configure multi-node Oracle11i ERP environment in Production and UAT
• Configured and Managed Oracle Identity Management (SSO/OID)
• Integrated Oracle 11i ERP with Oracle Internet Directory and Single Sign-On (SSO)

Environment: (Oracle 11i (11.5.10.2) Application, MDSI Advantex, Intergraph, Hyperion, Metasolv, Oracle Communications ASAP, Remedy, Business Objects XI R2, Siebel 7.8, Informatica, Comverse Kenan/BP, NetCool/Proviso, Oracle 10G/9i Database, HP-UX11 Unix, Windows 2003 Server, Sun Solaris 9)

Senior Oracle DBA

Confidential

Responsibilities:

• Oracle RDBMS Database monitoring, tuning and reorganization
• Migrated existing Oracle9i databases to Oracle10g RAC database
• Database and schema creation; and Database backup and recovery
• Provided technical support to ERP, Clarify and JAVA developers in tuning SQL statements and batch programs
• Developed PL/SQL batch programs for uploading data from OLTP databases to Data Warehouse database
• Assisted developers in Oracle Forms and Reports programming
• Cloning and System administration for Oracle Apps instances
• Maintain, manage and administer Clarify CRM and Broadvision application

Environment: (Oracle Applications 10.7SC, Business Objects, Oracle 10G RAC Database, Oracle 9i Database, Oracle 8i Database, Clarify Applications, Broadvision, AppWorx, HP-UX11 Unix, Windows 2000 Server, Red Hat Linux 8.0)