Database Administrator.Working as an Oracle/MS SQL/MySQL DBA collaborating with support and Application Development teams and also as a Technical Oracle 11g, 12C, 18C, 19C, DBA (monitoring, supporting, deploying new databases, migrations). Experience Administrating DELPHIX 5.0.2 - Virtual Databases. Oracle OEM 12C, 11g, Space administration (ASM), Symantec Netbackups 7.7.2, HP Data Protector 7, Golden Gate 11g, 19g, 21c big data. Working collectively with Infrastructure teams to manage space, and system resources.HP Unix B 11 / Linux RH 6.7 shell scripting. SOX password change administration, On-Call Support.Exadata X5-2. Exadata Patching, OASG. Kafka, AWS MySQL 7, 8

Health IndustryAs an ETL programmer responsible for the maintenance and proper working of a research de-identified information system.Using SSIS, PL-SQL, Visual Studio on SQL Server 2012, Oracle 10g and 11g.Oracle DBA for the Clinical Trials system for the UChicago Hospital (Biology Science Division). Migration from 10.2g to 11.1g, tuning parameters, RMAN, creating Unix maintenances scrips and contabs. Working also on creating Datamarts for research projects where information is sourced from CLARITY (EPIC) SQL Server DB, CENTRICITY (Billing) Oracle 11g DB and DW and the Cancer Registry (SQL Server DB). Good understanding of Clarity DB Model for Inpatient, Outpatient, ER, Encounters, LABS, etc.

Industry: Marketing - RL POLK Duration: 5 monthsPosition: Systems Designer / DeveloperEnvironment: Windows, UNIX, Oracle Developer, SQL PlusTools: PL/SQL, SQL Plus, DBForge, SQL DeveloperInvestigated about the automobile industry and developed assemblies (program units) to execute tasks to transform information according to the needs of different OEMs. Developed Cross-Sells reports, and covered different needs of the customer to provide different information services, and reports. Developed processes in big sized databases.Industry: Manufacturing - Haworth Duration: 2 yearsPosition: System Analyst and Systems Designer / DeveloperEnvironment: Windows, Oracle 10.7, Oracle DeveloperTools: PL/SQL , Oracle Reports, Oracle Forms, SQL PlusDesigned manufacturing customized applications for RM, FG, Supply/Demand/Production Line, PO systems. Developed back-end interfaces (between Mainframe systems and Oracle based Applications). Monitored performance of production manufacturing real time systems.As a DBA created scripts for backup, reindexing and monitoring resources. Implemented the resource manager for the inventory system's DB

Developed Applications for Customer Retirement Solutions, Investments, Insurance, Banking, and Health processes. Extensively developed stored procedures and complex SQL queries in Oracle

Developed and supported Oracle EBS 11.5.1 AR, AP, GL, HR, CRM, PO, Self-Service, and other customized modules. Solved errors through Metalink as well as for managed updates, documentation, fixes, patches, service requests Sev1, Sev2, Sev3. Administered Projects for Oracle Apps developments through freelance providers. Supported new Oracle EBS 11.5.1 implementations

Implemented the main Commercial System including sales, distribution, delivery, and quotations processes in new Distribution Centers. Implemented a Web Knowledge Based system for frequent errors of the commercial system and a Visitors System. Collaborated with remote helpdesk work teams across Mexico and Brazil. Designed and tested interfaces of the Commercial System with an international sales system. Implemented and supported Vending Machine Interface Systems in Mexico and Argentina..

Developed and collaborated designing new functionality for BANNER 6 (Educational Institutions ERP) for the HR Module, Sub-modules: Position Control, Recruiting, and Payroll. Developed new web services for the 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 the database. Developed UNIX scripts and batch processes to run SQL scripts. Developed programs for data migration (Database upgrade). Trained users for new features added to the system.