SUMMARY

• Over 15+ years of Strong experience in IT industry. As an Oracle Database Administrator, Oracle Apps DBA, Oracle Apps Technical Consultant, Oracle Fusion Middleware Administrator, Oracle Integration Cloud Architect.
• Involved all the SDLC process, in Database Support 24x7 mission - critical and Implementation of projects on multiple platforms, Rollup of Oracle Apps 11i to 12 and Oracle ERP Cloud Implementation and Integration.
• This includes Fresh Implementation, Migration, Upgrade and Configuration of Oracle Real Application Clusters (RAC), Database Security, Performance tuning, Golden Gate and Data Guard for Disaster Recovery Sites on Oracle 11g/12c/18c/19c Databases. Experience with Oracle Cloud, AWS, GCP.
• Over 15+ years of experience as an IT Architecture and Oracle Database Administrator
• Responsible for database administration, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing and space management.
• Expert knowledge of installation and configuration of Oracle 8i, 9i, 10g, 11g, 12c databases in LINUX, HP-UX, SOLARIS, IBM AIX and Windows environments.
• Planned and implemented Oracle 10g, 11g, 12c and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
• Proficient in upgrade and migration of Oracle databases from Oracle 9i to 10g/11g/12c/18c/19c and migration of databases using transportable database, table spaces export/import, data pump utilities.
• Implementation of Oracle enterprise manager (OEM),
• Experience with performance tuning, wait & events, AWR, ADDM, Flashback Technology, experienced in creating DB links
• Experienced in cross platform migrations from Windows to Linux, Solaris to Linux, HP-UX to Linux.
• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).
• Expertise on RMAN performing cold backups, hot backups, advanced recovery methods like PITR and TSPITR, flash back recovery.
• Successfully maintained day-to-day functionality and reliability of major database and managing large terabyte-sized databases
• Experience in using Oracle 12c SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
• Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Cross platform migration of Oracle Databases and Oracle E-Business Suite Instances.
• Expertise in maintaining Database Roles, Users using Security Compliance Auditing
• Experience in using the oracle support (Metalink) for Service Requests(SR database log files related performance issues, Remote Diagnostic Agent (RDA).
• Good experience in managing Very Large OLTP databases.
• Administration, configuration of Oracle Weblogic Server
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.
• Involved in working with Oracle Support regarding technical issues with Oracle Fusion Apps, Oracle Database, Oracle Fusion Middleware, Oracle Data Integrator.
• Experience in Data Warehousing using ETL Tools and Oracle.
• Designed and Implemented Oracle E-Business Suite R12, R11i concurrent programs, custom forms, PL/SQL Packages, Oracle Reports, Oracle BI Publisher reports for modules GL, OM, INV, QP, AP, AR, PO.
• Designed and Implemented Inbound and Outbound Integrations between Oracle Fusion Applications and Legacy systems using Oracle Integration Cloud, Oracle Process Cloud, Oracle Visual Builder Cloud Service using FBDI, BI Publisher Reports, Rest API’s, SOAP Web Services, Oracle Service Bus Processes for modules GL, OM, INV, QP, AP, AR, PO,SLA, FA, PPM.
• Created and maintained Oracle Data guard configuration of primary and standby databases. Configured Client Applications failover.
• Experience in implementation of Golden Gate replication leveraging Integrated extract and Integrated replicatprocess to configure logical replication between Databases.

TECHNICAL SKILLS

• Oracle Integration Cloud
• Oracle Warehouse Builder 10g
• Oracle ERP Cloud
• Oracle Visual Builder CS
• Oracle OLAP 10g
• Oracle Discoverer
• Oracle Process Cloud
• Oracle Applications 11i/12
• Oracle Application Server 10g
• Oracle BIP
• Oracle WebLogic Server
• Oracle RDBMS 9i
• Oracle OTBI
• Oracle Applications DBA
• Oracle Forms 10g
• Oracle 12c
• Oracle JDeveloper
• Oracle Reports 10g
• Oracle 11g
• Informatica Power Center
• Oracle Data Integrator
• Oracle SOA Suite 12c
• Oracle BPM 12c
• Oracle ADF 12

PROFESSIONAL EXPERIENCE

Confidential

Oracle Sr DBA/ Oracle Application Developer/ Oracle SOA Developer/ Informatica Power Center Developer

Responsibilities:

• Confidential ( Confidential ). Oracle Application Developer/ Informatica Power Center Developer. After taking the required courses from informatica I help to a team to integrate Informatica MDM with Oracle Applications. We use concurrent programs and Oracle APIs to allow the integrations. And I was using a standalone Oracle 12c database as a staging repository.
• Installed Oracle Cluster ware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• Confidential ( Confidential ). Oracle Application Developer/ Oracle SOA Developer. I work with a team of developers to enhance the current integration of the Confidential web store to send information over internet to Oracle Applications. We use Oracle SOA Suite 11g and Oracle PL/SQL. Maintaining Oracle BPM 12 process to create Inventory items that need an approval from business users. I participate customizing ADF forms in order to allow user task to show item information. I also create a standalone application with ADF that allows user to see information stored in a custom DB related to Inventory Items with issues or rejected in the BPM Flow.
• Confidential ( Confidential ). Oracle Application Developer. Creating reports, customizing forms, creating batch processes to load information into Oracle Order Management module.
• Confidential ( Confidential ). Oracle Application Developer. Analyzing processes to fulfill sales orders created in Oracle applications that have to be paired in the same quantity for the product the customer buys with the quantity that Confidential gives as a gift. Oracle calls this kind of promotion like a buy item - get item promotion. I had to review times and proposed the used of multi processes using oracle application infrastructure called concurrent manager to allow multiple sales orders to be processed and fulfill
• Created Golden Gate setup between different applications at table level and schema level.
• Created Data guard environment with broker setup for multiple application databases

Confidential

Oracle Lead DBA

Responsibilities:

• The DBA team was in charge of implementing backups and test recoveries from databases running on Oracle Solaris 10.
• Lead the DBA team to implement BCP and Data Guard Solution at remote side using multiple Oracle Cascading Standby Configurations
• We also implement Oracle Enterprise Manager 11c, installing agents in servers, configuring OEM repository and creating reports. We also monitored all databases.
• In addition we implement replication of 32 databases with Oracle streams 11g.

Confidential

Oracle Sr Consultant

Responsibilities:

• Confidential ( Confidential ) - Oracle Applications DBA. Working as Oracle Applications DBA supporting Production and Development environments, applying patches, monitoring both application and database, performing some sysadmin activities like creating users, assigning concurrent programs to request groups, creating concurrent program definitions, monitoring concurrent managers.
• Confidential - BI Developer. Working as a project leader, building Oracle Discoverer Reports over Materialized views extracting data from Oracle Applications Modules like OM, INV, AR. We decide to use Materialized views caused they wanted to perform some analysis task over data in the base tables of Oracle Applications, so the performance was very poor.
• Confidential - Oracle Applications DBA. Working as an Oracle Applications DBA, performing tasks like upgrading minor version of Oracle 9i database from 9.2.0.5 to 9.2.0.7, applying Oracle Applications patches, cloning Oracle Applications instances.
• Confidential - Cedulas Fiscales. I was part of a Visual basic team who build some reports over data from AP, PO, GL, INV Oracle Applications modules.
• Confidential - Oracle Human Resources, i was developing some PL/SQL interfaces to Load data to Oracle Human Resources, those interfaces load EIT´s (Extra Information Type) data, this data was used to generated reports in Oracle Reports.
• Confidential – Portal de Ventas, working as a Project Leader and developer, our main task was to migrate all the querys from some Portlets build in Oracle Applications Server 10g, the source was an IBM DB2 database and a Oracle database.
• Actively participated in installing of 11g RAC on Linux environment with two nodes and ASM as storage.
• Confidential – Sistema de Administración de Ingresos, we were part of the team who develop a Java Web application that store purchase order data from tv spots. We use Oracle Jdeveloper 9.0.5 (10g) as IDE using a SQL Server database and struts as framework.
• Confidential – working as a web adminstrator, we upgrade minor version of Oracle Application Server 10g 9.0.4 to 9.0.4.2 over a HP-UX box.
• Editorial Confidential – Working as a Oracle Applications DBA i was there to provide support to Oracle Application Development instances, applying EBS patches and checking availability of services.
• Confidential – High Availability web Application. We was there to perform some changes in a web application, so it could be in a High Availability environment, we change an Oracle Portlet so it could handle a file upload task into a BLOB field in an Oracle Database, keeping that file in a jsp session.

Confidential

Oracle Sr Consultant

Responsibilities:

• Development and support for java web applications using Oracle Jdeveloper 10g. Building portlets for Oracle Application Server Portal.
•  As an Oracle Developer building reports over Oracle Application AP module, using Oracle Discoverer and Oracle reports, extracting data from Oracle Applications base tables.
• I was part of the team who build an Oracle Portal Application using Java Portlets with Oracle Jdeveloper. We use struts and work with Oracle 10g database.
• Confidential Auritec. i was working as an Oracle Developer, the main task i perform was modifying an Oracle Forms Applications that calculated some account receivables operations. We use Oracle 8i, Oracle Forms 6i and Oracle Application 9i release 1.
• I work as an Oracle Developer implementing an upload file form with Oracle Forms 9i, this was solved using java with Oracle Forms.
• Fuller Cosmetics. I was building and modifying some Oracle Discoverer Reports and building some Java Portlets who could send parameters to Oracle Discoverer Portlets so an Oracle Portal Page could refresh all at once.
• Iusacell (Data Warehouse). I worked as a BI Developer building mappings with Oracle Warehouse Builder 9i and Oracle 9i as database on a HP-UX box.
• IFAI . Java Developer. I was working as a Java Developer to build a web application with jsp´s, it manage all the user documents so they could share documents between users. The platform was Oracle 9i with Tomcat as a web server.
• Grupo Bimbo (CMS). Within CMS I perform some modifications to existing jsp´s pages with Jdeveloper. I build a search page with javascript validations linked to a Oracle 9i database. The page could sort data only clicking over the column header. I perform some modifications to PL/SQL store procedures. We use Oracle iAS 9i and the web container was Jserv.
• Vopak Terminals México. I was part of the development team who perform modifications to SCAL system, it was build with Oracle Forms 6i and Oracle Reports, I had to modify several forms and reports. The server was an Oracle 8i server on a Solaris 8 box.
• Confidential Hipotecaria. I was developing some PL/SQL store procedures to the MACC system, it was a Credit an Account Receivables application, even I build several ASP pages to the front end, we use Oracle 8i on windows.