PROFESSIONAL SUMMARY

Looking for challenging career opportunities as a team player contributing on one way or another. With over 20 years of IT experience on database's design and administration for ERP, OLTP, DWH, ODS and DataMart with DRP and HA configurations. Strong knowledge on database's administration proceses to meet security and compliance audit requirements for SOX, PCI and RCIM. 12 years implementing ITIL methodology for the operation of databases and infrastructure administration aiming to improve customer satisfaction by implementing SLA's, procedures, baselines, runbooks and standards, and by measuring incidents, changes, requests and problems tickets with Remedy, Service Center and iTop, all well integrated with even monitoring tools such as OEM, NetIQ, Quest Foglight, SolarWinds and Shell scripting.

• Oracle 7, 8, 8i, 9i, 10g, 11g, 12c Databases 17 Years :
• Hands on experience on clustering admin such as HP MC Service Guard and Oracle Exadata.
• Proficiency using Flash-Back Recovery Area and performing RMAN recoveries integrated to NetBackup, Tivoli, Omniback II and Veritas with Sepaton and StorageTek libraries backups.
• 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 databases by using UtlStat, Perfstat, TKProf, Explain Plan, SQL Trace, Stats Pack, and AWR/ADDM and SQL Tuning Advisor.
• Installation and configuration of Oracle Golden Gate to manage data replications.
• Implemented Oracle Gateway for IBM mainframe databases by configuring database links.
• Data transformation processing into large databases by using SQL Loader and Shell Scripting with C, Pro C, AWK and ETL Tools like Polaris and DataStage.

Oracle PL/SQL Programming

• Extensive experience writing Stored Procedures, Functions, Triggers and Packages and programming in C, Pro C, PL/SQL, MOD PLSQL, SQL Loader, API's, APEX, Forms and Reports.
• Hands on experience on conceptual, physical and logical databases design by using Erwin, SDesigner, Oracle Designer, SQL Developer and Quest TOAD.
• Tuned applications working with developers teams by analyzing queries engineering, data modeling, histograms analysis, hints, etc.
• Oracle Applications 11i / R12 ERP and Oracle Fusion Middleware 11g 14 Years :
• Oracle Applications 11i and R12: Installations, minor and mayor upgrades, cloning, tuning, PGP and RAC integrations, backups setup, tuning and troubleshooting, TXK and AD patching tools.
• Hands on experience on installations and configurations of Oracle Fusion Middleware 11g such as: Java EE, OBIEE, SOA, OWF, OID, OEM and APEX, WebLogic/OAS/iAS Servers, well understanding of BPEL, Web Services, XML, JDBC, ODBC, JDK, SDK, etc.
• Event monitoring event configurations by integrating OEM with databases and applications.
• Microsoft SQL Server 6, 7, 2000, 2005, 2008R2, 2012 Databases 18 Years :
• 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 and SyBase ASE 12.5, 15 Databases 5 Years :
• Installations, configurations, migrations, upgrades, cloning, backups, troubleshooting. Assisted developer teams with MySQL Workbench.

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, Oracle: Sun, Exadata, SuperCluster, IBM Mainframe, 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.
• Databases Oracle 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, ETL, DataStage.
• DB Components RAC, Active Data Guard, GoldenGate, 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 12c, PHP Server, Apache Server, Oracle Apex. Oracle Business Intelligence OBIEE , Oracle SOA Suite 11.1.1.4-11.1.1.7, OEM, OID.

PROFESSIONAL EXPERIENCE

• Recognition as speaker of Internet Communications at XI Congress of Veracruzana University.

Confidential

Senior Oracle Applications DBA

Description:

• Experienced as Oracle Applications DBA working on implementations of databases for PeopleSoft.
• Cloning and documenting runbooks for refreshes of databases and middleware applications from production to development environments by using RMAN/RAC/ASM over ExaData servers.
• Implement and document runbooks for RMAN backups scenaries.
• Implement and document runbooks for DataGuard configurations for DR.
• Tuning of middleware and Oracle databases by using ADDM/AWR reports and OEM 12c.
• Providing technical support on Oracle Applications to functional users and developers.

Environment: Oracle 11g/12c, RAC/ASM, DataGuard, ExaData, Linux, PL/SQL.

Confidential

Databases Corporate Manager

Description:

Responsible of databases, infrastructure and applications operations by implementing service operation proceses based on ITIL framework and Gartner's maturity evaluations into the Company and subsidiaries aiming to establish a IT governance model based on KPI's.

Management activities:

• Team's supervision: Coordinating activities of the Operation's teams: DBAs, Middleware, Applications, Unix/Intel Admin, Networking, Storage and QA Teams by reviewing KPI s and defining action's plans to improve the customer service.
• Delivery Management: After ITIL software tools and proceses implementation I started to act as Service Delivery Manager SDM of IT infrastructure.
• Compliance Audits: Responsible to work with IT compliance audits to fix any issue.

Project's coordination:

• Infrastructure evaluations: Acting as infrastructure architect responsible to analyze and estimate the infrastructure technology requirements for new IT resorts projects such as: TimeShareWare, EnKontrol, Innsist, DWH, SharePoint, Active Directory, SolarWinds, NetBackup, VMWare/VMotion, Oracle RAC/EBS/SOA/OBIEE/OID/Cloud Control 12c, BBG, Onity SIRAM, Nice VLOs, etc.
• ITIL management tools implementation: Specially I was responsible to install, setup and integrate iTop, SolarWinds and Oracle Cloud Control 12c with databases and middleware applications in order to manage event monitoring automated where incident tickets are created automatically into iTop to be able to fix incidents into SLA's agreements. For the integration I worked together with Oracle SOA, Web and BI Reports programmers BPEL, WebServices, REST, PHP, etc by using SCRUM and PMI methodologies.
• ITIL processes implementation: Coordinated activities of developers and support analysts to define, document, review and implement operational procedures and manuals for Databases Programming, Databases Admin, Unix Admin, Networking admin and Storage admin activities:
• CMDB design: Defining, collecting, scanning all Configuration Items CI's and creating and designing relations with SLA's, OLA's and Software Asset Management SAM .
• IT Operational procedures: Programming's standards, baselines, runbooks, RFP's, manuals, nomenclatures and procedures for standardized infrastructure administration.
• Access Management Procedures: Defining and implementing Access Processes.
• Vulnerability Management: Defining, review and fix vulnerabilities into databases, applications and infrastructure.
• Change/Incident/Problem Management: Defining and implementing process owner's responsibilities such as CMPO, IMPO, and their relations with the CAB and ECAB.
• Technical activities: I assigned activities myself such as installing, testing and documenting new databases and applications releases aiming to keep my DBA skills:
• Oracle middleware activities: Oracle Applications R12 minor and mayor upgrades 12.2.4 and patching OWF setup, Financial and Payrol modules tastings Installation, integration and administration and upgrades of Oracle Fusion Middleware such as: OID, OBIEE, Cloud Control 12c, WebLogic Server and SOA Suite. HA configurations with PCP, RAC and ASM.
• Database activities: Oracle 12c: Installations, cloning, RMAN/NetBackup, ASM/RAC, Active DataGuard and GoldenGate configurations. SQL Server 2012: installation, maintenance plans, log-shipping setups, NetBackup integration and upgrades. MySQL 5.7: Installation, cloning, refreshes and upgrades. Evaluating and testing failover by comparing VMWare with VMotion and Oracle VM.

Environment: Oracle 10g/11g/12c, RAC/ASM/DataGuard, Oracle EBS, SOA, OBIEE, BI, OID, PLSQL, WebLogic and OEM Cloud Control 12c, SUN Sparc SuperCluster, TOAD, RedHat/Fedora and Oracle Linux, Solaris 10, NetBackup, ErWin, SQL Server, SyBase, MySQL, iTop, Apache, PHP, OQL, LDOM, Containers, VMWare, VMotion, SolarWinds, EnKontrol, Active Directory, Innsist, DWH, Shared Point.

Confidential

Infrastructure Management Principal

Description:

Experienced as Senior Oracle Applications DBA and MS SQL Server DBA worked as SME Subject Matter Expert on several assignments of Xerox's Clients.

McDonalds:

• Oracle Applicationss 11i/R12 Upgrade: Initially started analyzing and estimating infrastructure needed for the migration of Oracle Applications 11i 11.5.9CU2 / 11.5.10 to Oracle eBusiness R12. 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.
• Oracle Applicationss migration: The same activities as previous point but now for the migration of all Oracle EBS and databases environment's from old Sun Servers to the new ones with latest OS and EBS releases and patches.
• Oracle Applicationss migration: Migrating of Oracle EBS and databases environment's from Sun Servers to Linux servers with latest OS and EBS releases and patches.
• IBM Tivoli Access Manager Integration: Integrating all Oracle Applications environments with IBM TAM 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.
• 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.
• 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 supporting customized Concurrent Programs CCM .
• 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.
• Integration of NetIQ with Peregrine Service Center: Worked with Peregrine's Consultants in order to automate the creation of incidents when NetIQ detect any database event.

On Call and daily activities:

Extensive experience as 7x24 on call supporting for multiple clients, attending Incidents and Normal/Emergency Changes for McDonalds, Ralcorp, Allergan, Nike, MVW and HCS:

• 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.
• Oracle Gateway administration support to connect IBM Mainframe databases.
• Provided instance level tuning reports and action plans by using PerfStat, ASH, AWR and ADDM over stand-alone and RAC 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, 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 administration: 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 Concurrent Programs CCM , responsibilities and security configurations. Tuning EBS and DB, administering Forms and Reports servers, uploading Reports, flexfields deployments, etc.
• MS SQL Server administration: Installations, patching, configurations, upgrades 2005 to 2008R2 and 2012, cloning, migrations of servers, Transact-SQL tuning, maintenance plans configurations, backups integration, assisted developers in T-SQL, etc.

Environment: Oracle 9i, 10g, 11g: RAC, ASM, Rman, 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, T-SQL, VMWare, VMotion.

Confidential

Senior Oracle DBA

Description:

• Experienced as Senior Oracle DBA working on technical support for:
• Installations and configurations of RAC/ASM.
• Tuning applications and Oracle databases by using PerfStats reports.
• RMAN/DPump backups configurations, cloning, refreshes for SAP environments.
• Administration of Oracle databases by using SAP tools.
• Tuning databases applications level by using hints, indexing and Explain Plan analysis.
• Refreshing schemas consistently by using Exp/DataPump with FLASHBACK SCN option.

Environment: Oracle 9i, 10g, RAC/ASM, DataGuard, SAP, TOAD, RedHat, ErWin, PL/SQL.

Confidential

Databases Manager

Description:

• My DBA activities were focused on hands on experience installing, testing, evaluating and documenting new releases of Oracle 11g and SQL Server 2008 databases and applications:
• Coordinated activities of DBA's, UNIX, Batch Processing's and Security Information's teams for the day-to-day activities, managed On Calls rotations and DRP scheduled failover testings. I was the L3 support responsible to resolve any issue according the SLA's defined.
• Experienced as Senior Oracle and SQL Server DBA responsible to ensure the high availability and good performance of databases and applications of the Company. Responsible to coordinate and implement ITIL procedures over databases and servers by documenting: SLA's, manuals, runbooks, processes, standards, RFP's for vendors and procedures such as Change Management, Access Managements, Vulnerability Management, etc. Including baselines configurations and proceses for SOX and PCI compliance audits.
• Installing, tuning, cloning, upgrading, migrating and troubleshooting databases and OEM over RedHat Linux, Fedora Linux and Solaris.
• Implement several scenarios of RMAN, Exp/Imp and DataPump backups.
• Integration of NetBackup and Veritas, Quest Foglight, NetIQ and Oracle Grid Control.
• Installation and administration of WebSphere and OAS for Debt Manager Applications.
• Designing, test and implement high-speed data networking for backups by integrating RMan, NetBackup and Sepaton devices.
• Implemented and documented configurations and procedures for DRP by using DataGuard, RAC and ASM for Oracle on Linux and LogShipping for MS SQL Server databases.

Environment: Oracle 10g/11g, RAC, ASM, Grid Infrastructure, DataGuard, Sun Solaris 10, PL/Sql, RedHat/Fedora Linux, Shell scripting, OEM, Putty, Toad, Sepaton, NetBackup, ErWin, TKProf, WebSphere, DBArtisan.

Confidential

Oracle Applications 11i Project Manager

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, WIP modules and Open Interfaces. Responsible to provide status of EBS projects to managers of BBU and Softtek.

• Coordinated the team and I also was programmer lead on Forms, Reports, PLSQL and API's Open Interfaces with Unix Shells scripting and DBA activities such as:
• Schemas consistent refreshes by using Exp/Imp with consistent options.
• Installing patches and upgrading EBS R12, and supporting to install and configure APEX.
• Worked on monitoring DB with Grid Control 10g, installing packages for EBS monitoring.
• Interfaces integration between Oracle EBS and Amdutch by using Oracle Open Interfaces.
• Worked doing 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 I was acting as IT manager working directly with Confidential Technology Center in order to implement CITMP ITIL procedures and maintain databases and infrastructure in compliance with SOX regulations.

Projects:

• CITMP implementation: Worked with Citigroup auditrs in order to implement ITIL framework by implementing procedures such as: Incident Management, Problem Management, Changes Management, Vulnerability Management, Access Management and Event Management. Coordination of development of software tools for the service operation such as even monitoring, incident management, change management and problem management by using Oracle iAS with Mod PLSQL and Shell Scripting.
• CITMP advanced security implementation: Documenting and implementing baselines into databases and servers based on best practices and vulnerabilities tools such as IIS and Database Scanner. 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.
• DRP and High Availability Implementation: Defining procedures and manuals for databases by using DataGuard over remote datacenters.

Daily activities:

• Installation, creation, configuration and upgrades of Oracle 8i/9i/10g databases.
• Installation and implementation of Oracle StandBy and DataGuard for production databases including procedures for DataGuard 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.
• RMAN Integration with 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.
• 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, assisting in tuning Transact-SQL, backups and programming scripts, etc.
• HPUX Administration: Installations, patching and configurations of HP9000 servers by using Ignite, LVM, MWA, Glance, Kernel's parameters configurations, NFS, crontab, disk arrays architecture designs, etc.

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, T-SQL, ODBC, JDBC, SDK, JDK.

Confidential

Oracle and HPUX Consultant

Description:

Oracle DBA consultant assigned to the SEMA OTAF Project integration at UNEFON Telecommunications Company:

• HPUX Administration: 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 Bimbo Bakeries. Worked in meetings with Softtek, Ernest Young and Bimbo people to understand business's rules and to define the scope of the developments:
• Responsible to analyze and understand functional operation of old Bimbo legacy systems in order to design Open Interfaces communication with Oracle Applications.
• 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.
• I also had an assignment with IUSACEL Telecommunications Company as Senior Oracle Programmer with shells scripting, C, Pro C and Make to improve ETL processes for the uploading of CDR's cellphone calls from switches to the large DWH.

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

Confidential

Oracle DBA Developer Lead

Description:

• Project lead responsible of the development of Oracle Logistic System by coordinating and supervising teams in Forms and Reports. Conceptual and physical database modeling by using SDesigner and Oracle Designer.
• I was programmer lead on Developer 2000 and responsible to assign and supervise activities of Developer team 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

Computer and Management Advisor

Description:

• I was responsible of system's development of the Company in Clipper, FoxProLN and DBase:
• Analyzing, designing databases 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 system's development of the Office of the Governor of State of Veracruz.
• To analyze, design and develop of National Directory Clipper/FoxPro .
• Backup's Administrator: Responsible of cadaster maps backups of the State of Veracruz.
• At the beginning I was doing automated cadaster maps by using AU2C Systems.

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