PROFESSIONAL SUMMARY

• Senior Oracle Applications DBA and SQLServer administrator with over 17 years of experience on large DEV, QA, UAT, SIT and PROD environments OLTP Data Warehousing databases implementing DR HA with strong knowledge creating databases administration processes to meet security and compliance audit requirements for SOX, PCI and RCIM. Extensive experience implementing ITIL procedures for the operation of databases improving customer satisfaction by documenting SLA's, procedures, baselines, runbooks and standards and by measuring incidents, changes, requests and problems with Remedy, Service Center or iTop. All well integrated with OEM, NetIQ, SolarWinds and Shells Scripting monitoring tools. Worked as a team player to provide 24x7 on call support in an environment where I can contribute one way or another.
• Oracle 7, 8, 8i, 9i, 10g, 11g, 12c Database Administration:
• Hands on experience on clustering admin such as HP MC Service Guard and Oracle Exadata.
• Proficiency using Flash-Back Recovery and performing manual recoveries by using RMAN with or without catalog for incremental, cumulative, full, cold and hot backups. Integration of NetBackup, Tivoli, Omniback II and Veritas to Sepaton and StorageTek libraries backups. Designing and implementing high-speed backups to disk, tape and silos. Data transfer by using conventional Exp/Imp and Data Pump utilities.
• Installing, configuring and maintaining Active Data Guard and RAC databases with ASM/ACSF.
• Closing database vulnerabilities by using several database scanners software and by applying baselines to configure SSL, initora file, auditing, profiles, passwords personalization, etc.
• Tuned many database by using UtlStat, Perfstat, TKProf, Explain Plan, SQL Trace, Stats Pack, and AWR/ADDM and SQL Tuning Advisor. Tuned applications working with developers teams by analyzing queries engineering, data modeling, histograms analysis, hints, etc.
• Installation and configuration of Oracle Golden Gate to manage data replications.
• Configured and implemented different types of Advanced Replication Models by configuring Oracle Gateway for IBM mainframe.
• Used Repository Manager to manage Very Large Scale Databases VLSD .
• Quite experienced in flat files data transformation processing into large database tables by using SQL Loader and Shell Scripting with C, Pro C, AWK and by using ETL Tools like Polaris and Data Stage to improve processing times.
• Oracle Applications 11i / R12 and Oracle Fusion Middleware Administration:
• Hands on experience on installations and configurations of Oracle Fusion components such as: EBS, Java EE, OBIEE, SOA, OWF, OID, OEM, Developer tools, WebLogic/OAS Servers, etc well understanding of BPEL, Web Services, XML, JDBC, ODBC, JDK, SDK, etc.
• Quite experienced on monitoring for health check by programming shells scripts and by integrating OEM Cloud Control 12c with databases and applications. Automated creation of Incident tickets into Remedy, Peregrine SC or iTop by using OEM Plugins, crontabs, jobs, and Web Services. Setup of OEM events monitoring for databases, applications and servers.
• Extensive experience writing Stored Procedures, Functions, Triggers and Packages and programming on C, Pro C, PL/SQL, MOD PLSQL, Forms and Reports.
• Hands on experience on conceptual, physical and logical databases design by using Erwin, SDesigner, Oracle Designer, SQL Developer, MySQL Workbench and Quest TOAD.
• Microsoft SQL Server 6, 2000, 2005, 2008R2, 2012 Database Administration:
• Extensive hands on experience on installations, cloning, maintenance plans, troubleshooting, tuning databases and queries, LogShipping configurations, monitoring, etc,
• Upgrades of SQLServer 6 until 2012 and migrations of SQLServer to Oracle and vice versa.

MySQL 5 Database Administration:

Installations, configurations, migrations, upgrades, cloning, backups, troubleshooting.

SKILLS SUMMARY

• Languages Fortran, C, Pro C, Shell Script, PL/SQL, MOD PLSQL, Oracle Open Interfaces, Oracle Forms, Oracle Reports, HTML, PHP and OQL.
• Hardware HP9000, Sun, Exadata, Intel, IBM Mainframe, IBM Intel, MAC, Sepaton, StorageTek, Clarion, DELL Equallogic, HP EVA, EMC, Cisco, Fortinet.
• Operating System UNIX HPUX 10-11, Solaris 5-9, AIX 4-5, Linux SCO, SuSE RH 5.5.-6.2, Fedora , Windows Servers NT-2012, VM Ware, VMotion.
• RDBMS Oracle databases 7, 8, 8i, 9i, 10g, 11g, 12c, MS SQL Server 7 - 2012, Sybase ASE 15, MySQL 5.6.
• Tools Sql Plus, Quest Foglight, TOAD, ERWin, SDesigner, DBArtisan, SQL Developer, SQL Loader, SQL Developer, MySQL Workbench, OEM, Orion Solar Winds, Remedy, Peregrine Service Center, iTop, MyOracle Support Metalink , ODBC, JDBC, JVM, SDK, JDK, jinitiator.
• Oracle DB Components RAC, Active/Passive Data Guard, Golden Gate, RMAN, ASM, Exp/Imp Data pump, SQL Loader, Upgrades, Patching, Partitioning.
• Oracle EBS OM, AP, GL, AP, AR, Inv, Time and Labor, HR and Payroll Modules OWF, Concurrent Programs, Security Users, Plugins, Packages, etc.
• Middleware Oracle Application Server 10g, Oracle Fusion MiddleWare 11g, WebLogic Server, PHP Server, Apache Server, Oracle Apex. Oracle Business Intelligence OBIEE , Oracle SOA Suite, OEM, OID.

PROFESSIONAL EXPERIENCE

Confidential

Infrastructure Management Principal

Description:

Experienced as Senior Oracle Applications DBA and MS SQL Server DBA working as SME on several assignments of Xerox s clients.

Projects with Xerox's Clients:

• Mc DONALDS: eBusines Suite Upgrade: Initially started analyzing and estimating infrastructure needed for the migration of Oracle Applications 11i 11.5.9CU2 / 11.5.10 to Oracle eBusiness Suite 12.1.3. After customer approved it, coordinated several sub-projects to upgrade all environments of EBS. Worked on the WBS and coordinated activities of Unix, Storage, DBA Applications, Functional users and developers teams to test and do the adjustments needed for DEV, UAT and PROD environments. Over production environment I was leading DBA Apps team activities working together with other DBAs in order to reduce down time windows.
• Mc DONALDS: eBusiness Suite and Oracle databases migration: The same activities as previous point but now for the migration of all Oracle EBS environment's from old Sun Servers to the new ones with latest OS and EBS releases and patches.
• Mc DONALDS: IBM Tivoli Access Manager Integration: Integrating all Oracle EBS environments with IBM TAM middle-tier application in order to reinforce security authentication of Oracle websites. Coordinated support meetings with people of Oracle, IBM and McDonald s EBS functional users to solve issues found in the integration related with jinitiator and OWF.
• Mc DONALDS: Global AS Critical Watch integration: After one year of IBM TAM software integration mentioned in previous point, Customer decided to change it to Global AS Critical Watch therefore I did the same activities but now also working with people of Global AS.
• Mc DONALDS: HR and Financials EBS Modules support: Worked with Oracle Support and EBS functional users to fix problems of Oracle EBS into modules such as GL, AP, HR, OTL, etc. and customized Concurrent Programs.
• Mc DONALDS: MS SQL Server Migrations: Worked many projects for the migration of MS SQL Server Databases to the latest releases of 2008R2/2012 with Log shipping configurations.
• ALLERGAN: OEM Setup: Integration of databases into OEM and Shell scripting for backups.
• RALCORP: High Availability Databases Projects: Migration of standalone Oracle databases to RAC/ASM environments.
• MWV: Fixing DB Troubles Projects: Worked in small projects to fix issues related to database backups, maintain jobs and tuning applications and database.
• XEROX: Internal Training Project: Responsible to elaborate manuals/courses for Oracle EBS training for new DBAs in the Company.

On Call and Daily Activities:

• Extensive experience as a 7x24 DBA Apps supporting multiple clients, attending Incidents and Normal/Emergency Changes. All completed activities were well documented with details to deliver it to customers such as McDonalds, Ralcorp, Allergan, Nike, MVW and HCS:
• Supporting Red Hat, Fedora and Oracle Linux and Unix for HP9000, Sun, Exadata, IBM AIX.
• Recovering many times with RMAN on RAC and standalone databases to fix incidents.
• RAC and ASM Support: Monitoring space usage by using ASMCMD command adding disk to disk-groups and performing ASM disk-group rebalance when required. Good hands on experience in Oracle Grid Infrastructure by using SRVCTL and CRSCTL commands to start, stop, configure, modify and verify the cluster status and resources.
• Implemented Data Guard and participated in Data Guard Fail Over scheduled tests.
• Implemented RMAN with standard configurations over new databases including testing.
• Managing Golden Gate, installations, integrations, replication using GGSCI with Extract, Extract Pump and Replicate instructions, etc. Oracle Gateway administration for IBM Mainframe,
• Provided instance level tuning reports and action plans by using PerfStat, ASH, AWR and ADDM over stand alone, RAC and Exadata databases.
• Worked extensively on performance tuning with development teams by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics, etc. Optimizing ETL processes and installation and configuration of Oracle APEX.
• Applying scheduled changes for triggers, stored procedures, Reports, DB, RAC, ASM, Rman and OEM configurations, patches, upgrades, refreshes, etc.
• Cloning large DBs and EBS Applications TB with RMAN Hot Backup and incremental and OS Applications Backups by using either NFS file systems or fast data networking.
• Oracle EBS support: upgrades by using TXK and AD patching tools having hands on experience using adadmin, adctrl, adpatch commands. Troubleshooting on patching by analyzing ADOP log directories, setting up APPSORA files and ORA env, compiling APPS, jars, forms, reports worked together with EBS Functional Users and Oracle Support to figure out root causes and implement root solutions. Working on scheduling Concurrent Programs, responsibilities and security configurations. Tuning EBS and DB statistics, administering Forms and Reports servers, uploading Reports, flexfields deployments, OID integration, etc.
• Oracle OBIIE support: Installations, cloning, patching, upgrades, migrations, tuning of reports. Elaboration of runbooks for JDBC, ODBC, SDK, JDK, jinitiatior, OC4J configurations and troubleshooting for connections.
• Oracle SOA Suite support: Installations, configurations and backups. Support for issues with BPEL process manager, Web Services Manager, Business Activity Monitoring, Enterprise Services Bus, JDeveloper, etc. Installations and configuration of plug-ins into Grid Control and Cloud Control 12c for the monitoring of the application and Web Services.
• Oracle OIM/OID support: Installation and configuration of WebLogic Server and OID components. Integration of OID with MS Active Directory, SOA and OBIEE by using LDAP.
• MS SQL Server support: Installation, configurations, upgrades, cloning, tuning, work plans and LogShipping configurations, NetBackups, IIS integrations, DR scheduled failovers, etc.

Environment: Oracle 9i, 10g, 11g: RAC, ASM, Exadata, Rman, Golden Gate, Data Guard Oracle Applications 11i, R12: HR, OTL, OWF, GL, AP and AR modules, Oracle Fusion Middleware, ODBC, JDBC, SDK, JDK, NetBackup, Tivoli, Veritas, Oracle Gateway, Remedy, Peregrine SC, OEM, Orion SolarWinds, NetIQ, MySQL, HPUX, Solaris, AIX, Linux, MS SQL Server 2005/2008/2012, VMWare, VMotion.

Confidential

Senior Oracle DBA

Description:

Working as experienced DBA in the company for the operation of applications and databases.

Daily activities:

• Installation and configuration of Oracle 11g/10g on Windows, Solaris and AIX Servers.
• Successfully installed Oracle 11gR2 on Linux platforms and built standalone databases.
• Upgrading Oracle 10g and Oracle 11g databases and applying required patches.
• Successfully implemented oracle 11gR2 Physical Standby database using Oracle Data guard in high availability configuration.
• Enforced database security on User accounts and Roles assigning and revoking Privileges.
• Implemented disaster recovery procedures documenting Rman, RAC and ADG activities.
• Worked closely with application developers in troubleshooting application tuning.
• Created, scheduled and worked on database maintenance tasks such as upgrades, patching, Golden Gate configuration changes, tuning analysis, index rebuild, materialized views refresh.
• Monitoring through Oracle Enterprise Manager to diagnose database problems.
• Developing Unix shell scripts and setting up cron jobs.
• Used Secure SCP SFTP extensively for the file transfers from machines to remote servers.
• Managed CRONTAB file, rescheduling the failed jobs due to errors , changing timings for the scripts to run if the job fails.
• Diagnosed Oracle bugs with Oracle support through Metalink to resolve them in timely manner.
• Implemented Data Guard with high availability.

Environment: Oracle 11g/10g, RAC, ASM, Grid Infrastructure Cluster ware , Golden Gate, Data guard, Sun Solaris 10, PL/Sql, AIX 5.1, Data guard, Shell scripting, OEM, Putty, Toad, Fedora Linux.

Confidential

Senior Oracle DBA

Description:

Working together with my team for the implementation of RAC and Data guard databases.

Daily activities:

• Installation and configuration of Oracle 11g/10g/9i on Windows Linux and AIX series.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Executed RMAN recoveries on RAC and standalone databases.
• Recovered huge Database when UNDO table space got corrupted in RAC.
• Cloned Databases using RMAN on remote Server and used SRVCTL commands for RAC.
• Implemented backups with RMAN including hot backups and Cold backups.
• Cloned schemas consistently by using Exp/DataPump with FLASHBACK SCN option.
• Implemented Data Guard with high availability and performance configurations.
• Tuning databases for event waits, sessions, physical and logical IO and memory usage.
• Performance tuning of queries by maintaining Aggregates, Compression, partitions, indexing and use of Hints, Stored outlines, statistics, etc.
• Supported development teams optimizing ETL processes by fixing query performance bottlenecks with EXPLAIN PLAN, STATSPACK, AWR/ADDM reports, and TKPROF tools.
• Configuration of notifications for monitoring events and adding them to the 10g Grid Control.

Environment: Oracle 11g/10g, Oracle 10g/RAC, RedHat/Fedora Linux, Solaris 10, Informatica, TOAD, Veritas, OEM, Erwin 7.2, SQL, PL/SQL, TKPROF, WebLogic, EXPLAIN PLAN, Business Objects XI, Data Guard.

Confidential

Sr. Oracle DBA Applications 11i

Description:

• Experienced Oracle Applications 11i/R12 assigned to work with Bimbo Bakeries USA BBU Company, worked in meetings with BBU functional users, Amdutch and Softtek people to analyze requirements of new projects for GL, OM, AP, PO, INV, WIP and WIP Modules and Open Interfaces Developments. I also was reporting status of projects to BBU and Softtek managers.
• Cloned schemas by using Exp/Imp and table spaces transported in 10g and 11g.
• Installing patches, and providing support to install and configure APEX.
• Worked on monitoring DB with Grid Control 10g, configuration of error notifications.
• Responsible to analyze and to understand functional requirements and assigning and supervising activities of Oracle Reports, JDeveloper and Shell scripting teams.
• Coordinated interfaces integration project between Oracle EBS and Amdutch application by using Oracle Open Interfaces.
• Worked doing minor and mayor upgrades into EBS and databases.

Environment: Oracle Applications 11i/R12, Oracle DB 10g/11g, Solaris, JDeveloper, Forms, Reports, Pro C, Shell Script. Oracle APEX, JDBC and ODBC.

Confidential

Senior Oracle DBA

Description:

Extensive experience as Senior Oracle DBA and HPUX administrator. The last years acquired responsibilities of IT manager to coordinate Infrastructure Area and worked directly with Citibank Technology Center Confidential order to maintain IT subsidiary in compliance with SOX.

Projects:

• Worked with CITMP division in order to implement ITIL procedures and software for the service operation of databases such as: Incident Management, Problem Management, Changes Control, Vulnerability Management, Access Management and Event Management.
• Implementing CITMP advanced security baselines into databases and servers. Installing and setting up software such as IIS and Database Scanner to scan DB vulnerabilities. Programming shell scripts to implement Event Monitoring automated processes. Responsible to apply and maintain databases baselines updated with best practices of IT security software vendors and Oracle Support Metalink in a quarterly basis accordingly of IT SOX processes.
• Implementing DRP and High Availability Procedures for databases by using Data Guard.

Daily activities:

• Installation, creation, configuration and upgrades of Oracle 8i/9i/10g databases.
• Installation and implementation of Oracle StandBy and Data Guard for production databases including procedures for Data Guard fail over scheduled testing.
• Performed Database Refresh from Production to DEV, QA and UAT environments.
• Tuning DB for Event Waits, Hit Ratios, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN configuring Hot and Cold Backups and recovering huge Database when UNDO, TEMP, SYSTEM table spaces and control files got corrupted. Integration of Omniback II and Veritas with StorageTek silos devices.
• Cloned Databases using RMAN and OS Cold Backups.
• Worked extensively with development teams to improve performance of Queries by maintaining Aggregates, Compression, partition, indexing, Hints, Statistics, etc.
• Supported development teams by elaborating manuals for SQL statement tuning and optimizing ETL by using EXPLAIN PLAN, STATSPACK, PERFSTAT and TKPROF. Fixing issues of SDK, JDBC, ODBC, datasources connections, etc.
• Daily SQL Server 7/2000 DBA support activities: Troubleshooting, installations, backups, tuning, scripting for backups and programming scripts for maintenance, etc.
• Installations, patching and configurations of HP9000 servers with HPUX by using Ignite, LVM

Environment: Internet Applications 9i, Oracle DB 8i 9i, Storage Tech, Meta4, SAS ERP, HPUX, SQL Server, OEM 9i, Omniback II, Veritas, Database Scanner, ISS, MOD PLSQL, PLSQL, Forms, Reports, Pro C, Shell Script. MS SQL Server 7/2000, ODBC, JDBC, SDK, JDK.

Confidential

Oracle and HPUX Consultant

Description:

• Oracle DBA consultant assigned to the SEMA OTAF Project integration at UNEFON Company:
• HPUX administrator: troubleshooting, LVM, tuning, parameters kernel configurations, HP Omniback II Integration, MC Service Guard cluster administration.
• Oracle DB 7.0.4 8.1.5: Installations, tuning, cloning, RMan, migrations, etc.
• Tuning databases with UTLSTATS and TKPROF and personal health check queries scripts.
• SCO Linux administrator: JDBC, ODBC, JVM Installations, troubleshooting, Apache admin, etc.

Environment: Oracle 8i 9i, Solaris, HPUX, Solaris, Pro C, Shell Script, Forte, SCO Linux, Omniback II, HPUX MC Service Guard, OEM.

Confidential

Oracle DBA Applications 11i Lead

Description:

• Oracle Applications DBA assigned to work in the first integration in Mexico of Oracle Applications 11i 11.5.1 in Bakeries Bimbo. Worked in meetings with Softtek, Ernest Young and Bimbo people to understand the scope of the project and the developments.
• Responsible to analyze and understand functional operation of old Bimbo legacy systems in order to design Open Interfaces communication with Bimbo legacy systems.
• Leading and supervising programmer's activities to migrate data from Bimbo legacy systems to Oracle Databases by using Exp/Imp, SQL Loader, Pro C, C ANSII Language with sockets and shell scripting with AWK and Make.
• Oracle DBA activities such as database links, Tablespaces, Tunings, Rman Backups.

Environment: Oracle Applications 11i, Oracle DB 81 9i, Solaris, JDeveloper, Forms, Reports, Pro C and Shell Script.

Confidential

Oracle DBA

Description:

• Project lead responsible of the development of Oracle Logistic System by coordinating and supervising teams in Forms and Reports. Database modeling by using SDesigner and Oracle DBA.
• Assigning and supervising activities of Developer 2000 team assigning me myself programming activities in Forms and Reports.
• Daily activities as Oracle DBA: Installations, backups, tuning, migrations from Clipper5.3 to Oracle 7 and troubleshooting with Oracle Metalink.
• Doing maintenance for old databases developed on DBase and Clipper 5.3a.
• Installing NT and Novell networking cables, switches and routers setup , SNA workstations.

Environment: Oracle 7, 8, 8i, Solaris, Oracle Developer 2000, Clipper, NT, Novell, SNA.

Confidential

IT Coordinator

Description:

• I was responsible of system s development of the Company in Clipper, FoxProLN and DBase:
• To analyze, DB design and programming Inventory Systems.
• I was OS and DB administrator of Intel and MAC Servers and responsible of IT support area.
• Installations and migrations of databases and applications from FoxProLN to MS SQL Server 6.

Environment: DBase, FoxProLN, Clipper, FORTRAN, SQL Server 6.

Confidential

System's Coordinator

Description:

• Started having Backups Administrator responsibilities in the Finance Department and ended as responsible of systems development of the Governor of State of Veracruz.
• To analyze, design and develop of National Directory for the Governor Clipper/FoxPro .
• Backup's Administrator: Responsible of cadaster maps backups of whole Veracruz State.
• At the beginning I was doing automated cadaster maps using AU2C Systems.

Environment: DBase, FoxProLN, Clipper, AUD2C.