SUMMARY

• Over 18 years of IT experience as Oracle DBA, Oracle Developer (EBS, ETL). Experience in different types of industries in USA and Mexico.As a technical engineer analyzing customer’s needs and developing solutions to meet customer’s needs.
• Oracle DBA - 4 years of experience on Oracle 11g, 12C, Microsoft SQL Server 2016, 2014 performing DBA functions as monitoring, tuning, DBA Applications for multiple development and QA projects. As a DBA Support (OnCall) of multiple applications.
• Oracle Developer - 14 years of experience using Oracle development tools such as Oracle Forms and Oracle Reports 6i and 9i and as a PL/SQL programmer.
• Oracle EBS - 7 years of experience collaborating in implementations (configuration and administration) and version upgrade projects of Oracle based ERP systems such as EBS 11.4.10, Banner 6 and EPIC.

AREAS OF EXPERTISE

• Oracle DBA and Development
• User Requirement Analysis (Needs Analysis)
• Systems Technical Support

TECHNICAL SKILLS

Oracle Development: Oracle 11g, 12C, PL./SQL coding Forms 6i/9i, Reports 6i/9i, XML Publisher, APEX 11g, EBS 11.5.1, SQL Plus

ETL: DBForge, SSIS

Oracle DBA: Export/import DP, SQL Loader, RMAN DB Management and security, Backup and Recovery (Netbackups, HP data protector) DB Monitoring (OEM 12c) and Deploying, SQL Server 2014, 2016. Delphix VDB, Oracle Exadata, TOAD, SQL Developer

OS: Windows Server 2016, UNIX (Solaris, HP) and Linux RHEL 5, Shell Scripting, Crontab, Pro*C

Web: Java / MySQL SW Development, HTML, XML

Other Skills: AWS RDS (Beginner)

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Environment: Windows, UNIX Solaris, Oracle Developer, SQL Server 2014, 2016, Oracle 11g, 12C

Tools:SQL Developer, 2013, Oracle 11g

Responsibilities:

• Working as an Oracle DBA on different tasks for multiple systems such as Monitoring of Backup processes for multiple Databases, Refreshing QA/DEV/PRF environments, deploying and maintaining Databases, Space and Performance Monitoring.
• Peoplesoft DBA migrations/changes, Delphix environments (VDB) administration, Support OnCall rotation with other members of teh DBA team, Multiple Development project assignments as a DBA working with Development teams in Chicago IL. SOX Password updates. Gloden Gate support.

Confidential

Oracle DBA

Environment: Windows, UNIX Solaris, Oracle Developer, SQL Server 2008, Oracle 11g, Oracle 10g

Tools:SQL Developer, Microsoft Visual Studio 2008, 2013, Oracle 11g.

Responsibilities:

• Oracle DBA tasks for teh Clinical Trials system at teh Hospital of teh University, working on important projects such as teh application and DB upgrade and database, users and developer’s administration and troubleshooting, database server resources monitoring.
• Creation of ETL code (packages) for teh new Clinical Research Oracle Data warehouse incorporating data from external systems and platforms (SQL Server). SQL Database query customization for specific clinical data needs, using tools such as SSIS to communicate between different systems and databases such as EPIC (SQL Server 2008) and CENTRICITY (Oracle 11g).

Confidential

Oracle DBA

Environment: Windows, UNIX, Oracle Developer, SQL Plus Tools:PL/SQL, SQL Plus, DBForge, SQL Developer

Responsibilities:

• Developed packages (assemblies) to process and update OEM related information according to teh customer needs.
• Developed comparison reports between DB objects using DBForge to verify information in two production systems in for system transition projects. Migrated scripts from different languages to pl/sql based reports.
• Developed different PL/SQL Packages (Store procedures, Functions, triggers), analyzed and supported customized applications.

Confidential

System Analyst and Systems Designer / Developer

Environment: Windows, Oracle 10.7, Oracle Developer

Tools:PL/SQL, Oracle Reports, Oracle Forms, SQL Plus

Responsibilities:

• Integrated and investigated Mainframe legacy manufacturing systems (AMAPS, Locator) and Oracle based applications in regarding to interface between both for processes such as supply - demand, warehouse managing, transportation, and import/export. Managed to meet end user requirements and supported end user second level of 4 of teh main Oracle based systems of teh company.

Confidential

Oracle DBA

Environment: Windows, Oracle 10i, SQL Developer, UNIX AIX Oracle Forms, Oracle Reports, PL/SQL, ETL, SQL Loader

Responsibilities:

• Investigated about processing and calculations for different processes among different modules of teh system and collaborated in teh design of teh workflow of information according to each customer type, needs, specifications and government requirements for investment plans.
• Developed PL/SQL code (packages), Oracle Forms 6i and, Oracle Reports 6i tools (functions, triggers, procedures). Developed Unix Shell Scripts to execute Oracle stored procedures, Collaborated in Code Optimization tasks.

Confidential

Oracle EBS Developer

Environment: Oracle on Demand, Oracle EBS 11.5.1, Windows, Unix

Tools:Oracle Forms, Oracle Reports, PL/SQL, Oracle OnDemand, Metalink, Oracle Workflow, Oracle APEX

Responsibilities:

• Developed and supported program units for GL, AP, AR, HR, PO Oracle EBS 11.5.1 modules.
• Customized Oracle EBS reports and added new reports according to teh company’s needs. Other tasks performed: Administered teh Oracle EBS system:
• Created new responsibilities, administered users, roles and configured new modules for new and different organizations in teh company.
• Updated PL/SQL code embedded in oracle forms, oracle reports, packages, functions, triggers, procedures. Programming flex-fields (configuration) and native Forms (through Forms personalization).

Confidential

Oracle Developer

Environment: Windows, SAP, Oracle Developer

Tools:Oracle Forms, Oracle Reports, PL/SQL, Java

Responsibilities:

• Developed of new features of teh commercial system and managed teh maintenance of teh main Oracle based commercial system in teh company.
• Supported second level operations (24x7) for issues related to processes such as sales, distribution, delivering and quotations. Implemented, supported and managed teh sales applications for mobile devices (Handheld).
• Other Projects: Implemented teh Vending Systems for 7 Distribution Centers, Upgraded teh version of teh Sales Database System.
• Developed and collaborated designing new functionality for BANNER 6 (Educational Institutions ERP) for teh HR Module, Sub-modules: Position Control, Recruiting, and Payroll.
• Developed new web services for teh Oracle Employees Portal (Oracle Portal). Developed PL/SQL code to create new packages for new applications, and developed applications using Oracle Forms and Oracle Reports 6i for Banner customization Developed SQL*Loader scripts to load flat files into teh database. Developed UNIX shell scripts and SQL batch processing code.
• Developed data migration programs (Database upgrade). Trained users for new features added to teh system.