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.
• 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.
• 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.
• 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.
• Installations, configurations, migrations, upgrades, cloning, backups, troubleshooting.

TECHNICAL SKILLS

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, Confidential, 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, Dallas TX

Responsibilities:

• 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, Raleigh NC

Senior Oracle DBA

Responsibilities:

• 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, Malvern, PA

Senior Oracle DBA

Responsibilities:

• 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, Atlanta, GA

Sr. Oracle DBA Applications 11i

Responsibilities:

• 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, Tampa, FL

Senior Oracle DBA

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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.