PROFESSIONAL SUMMARY

• Over 17 years of experience as an Oracle 7/8/8i/9i/10g/11g Database Administrator having hands on experience in database creation, administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, trouble shooting.
• Experienced in maintaining large DEV, QA, UAT, SIT and Production environments.
• Worked extensively on DB and EBS versions upgrades, migrations and patching.
• Configured Oracle on different operating systems for OLTP Data Warehousing environments.
• Implemented DR High Availability Oracle solutions by installing, configuring and maintaining Data Guard and RAC databases on various platforms.
• Proficiency using Flash-Back Recovery and performing manual recoveries by using RMAN managed backups with or without catalog, archive logs, cold and hot backups, full backups, incremental and cumulative backups. Integrating NetBackup, Tivoli, Omniback, Veritas, Sepaton software for backups. Designing and implementing data networking for fast backups to disk, tape and silos
• Implemented data transfer using conventional Exp/Imp utilities and Data Pump.
• Expertise reinforcing databases security configurations by using software for vulnerability scans and applying databases baselines to remove users, configuring quotas, auditing, closing file system security holes, SSL protocols, setting up DB parameter files and integrating DB and EBS authentication with IBM Tivoli Access Management and Global AS Critical Watch.
• Dealing with databases security auditing and shell scripting to analyze data manipulation.
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning, Database Contention Tuning, I/O Tuning and Capacity Planning analysis by using TK Prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack and AWR generating reports of Automatic Database Diagnostic Manager ADDM .
• Extensive experience on databases monitoring for health check by programming shells scripts and also doing installations and integrations of OEM Cloud Control 12c with databases and applications such as EBS, OBIEE, SOA and OID. Managing Events monitoring and automated Incident tickets creation into Remedy, Peregrine SC and iTop by using OEM Plugins, crontabs, jobs, and SOAP protocols. Setting up components such as: database uptime/downtime status, listeners, space sizing, user locks, long running queries, free space, extents growth, user connections, backups fails, Web Services, Concurrent Programs, Workflows, etc.
• Installation and integration of Oracle Golden Gate to manage replication of databases or tables.
• Configured and implemented different types of Advanced Replication Models of distributed databases.
• Extensive experience writing Stored Procedures, Functions, Triggers and Packages by using Oracle products such as Pro C, PL/SQL, MOD PLSQL, Forms and Reports.
• Assisted in designing conceptual, logical and physical data models by using Erwin, SDesigner and Oracle Designer.
• Used Repository Manager to manage Very Large Scale Databases VLSD .
• Experienced in loading data from flat files into database tables using SQL Loader, Shells Script with AWK and ETL Tools like Polaris and Data Stage.
• Worked as a team member to provide 24x7 on call support for databases and applications.
• Excellent communication skills, with strong troubleshooting and team work ability.

SKILLS SUMMARY

• Languages C, Pro C, Shell Script, PL/SQL, MOD PLSQL, Oracle Open Interfaces, Oracle Forms, Oracle Reports, HTML, PHP and OQL.
• Operating System UNIX HPUX 10-11, Solaris 5-9, AIX 4-5, Linux SCO, SuSE RH 5.5.-6.2 , Windows Servers NT-2012
• RDBMS Oracle 7, 8, 8i, 9i, 10g, 11g, MS SQL Server 2000-2012, Sybase ASE 15, MySQL 5-6.
• Tools Sql Plus, Quest Foghlight, TOAD, DBArtisan, SQL Developer, SQL Loader, OEM/Cloud Control 12c, Orion Solar Winds, Remedy, Peregrine Service Center, iTop, MyOracle Support Metalink .
• Oracle DB Components RAC, Active/Pasive Data Guard, Golden Gate, RMAN, ASM, Exp/Imp Data pump, SQL Loader, Upgrades, Patching, Partitioning.
• Oracle EBS OM, AP, GL, Inv, Time and Labor, HR and Payroll Modules OWF, Concurrent Programs, Security Users, Plugins, Packages, etc.
• Middleware, Oracle Application Server 10g, Oracle Fusion Middle Ware 11g, WebLogic Server, PHP Server, Apache Server, Oracle Apex. Oracle Business Intelligence, Oracle SOA Suite, OEM, OID, Oracle eBusiness Suite.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Applications DBA

Description:

Experienced as Oracle and MS SQL Server DBA assigned to work on several projects with Xerox s customers.

Customer s Projects:

• McDONALDS: eBusines Suite Upgrade: Initially started analyzing and estimating infrastructure needed for the migration of Oracle Applications 11i 11.5.9 to Oracle eBusiness Suite 12.1.3. After customer approved it, coordinated several sub-projects to upgrade all environments of Oracle applications. Worked on the WBS and coordinated activities of Unix, Storage, DBA Applications, and Functional users and developers teams to test and do the adjustments needed into the new EBS environment. DBA Apps lead to work together with other DBAs for major upgrades where the activities were taking more than 8hrs.
• McDONALDS: 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.
• McDONALDS: 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.
• McDONALDS: 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.
• McDONALDS: HR, Time and Labor, Projects and OWF projects: Worked with Oracle Support and EBS functional users in several small projects to fix problems of Oracle EBS into modules of HR, Time and Labor, Workflows, Concurrent Programs and Projects Modules, working together with functional users and Oracle Support to analyze cases and to implement solutions for Problem Tickets that had long time opened.
• McDONALDS: MS SQL Server Migrations: Worked many small projects for the migration of MS SQL Server Databases to the latest releases of 2008/2012.
• ALLERGAN: Oracle projects: Worked in small projects such as: To integrate databases into OEM for monitoring event automated and to generate shell scripts for backups monitoring.
• 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 the completed activities were documented with details to be delivered to customers such as McDonalds, Ralcorp, Allergan, Nike, MVW and HCS:
• Applying scheduled changes for triggers, stored procedures, Reports, DB, RAC, ASM, Rman and OEM configurations, patches, upgrades, refreshes, etc.
• Extensive experience recovering with RMAN on Real Application Cluster RAC and standalone databases. Recovered several databases when UNDO, TEMP, SYSTEM table spaces and Control Files got corrupted.
• To Clone DBs and EBS Applications 1 TB using RMAN and OS Backups.
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• RAC and ASM Support for RAC administration: Monitoring space usage and ASM administration 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 resources.
• Implemented Data Guard with high availability, performance configurations and participated in Data Guard Fail Over tests.
• Successfully implemented Backup Recovery using RMAN which includes Hot backups and Cold backups.
• Managing Golden Gate, installations, integrations, setting up replication using GGSCI with Extract, Extract Pump and Replicate instructions, etc.
• Provided instance level performance monitoring reports and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures by using tools EXPLAIN PLAN, AWR, ADDM and TKPROF.

Environment: Oracle 9i, 10g, 11g: RAC, ASM, Rman, Golden Gate, Data Guard Oracle eBiz 11i ,12i: HR, Time and Labor, OWF and Project modules, NetBackup, Tivoli, Veritas, Oracle Gateway, Remedy, Peregrine SC, OEM, SQL Server, MySQL, HPUX, Solaris, AIX, Linux.

Confidential

Sr. 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 password changes, tables/indexes analysis, index rebuild, materialized views refresh, db exports and regular day-to-day tasks.
• Monitoring production databases through Oracle Enterprise Manager to troubleshoot and 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 and coordinated 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.

Confidential

Sr. Oracle DBA

Description:

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

Daily activities:

• Installation and configuration of Oracle 11g/10g/9i on Windows and AIX series.
• Monitoring and supporting more than 40 databases.
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design table spaces, data files, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and standalone database
• Recovered huge Database when UNDO table space got corrupted in Real Application Cluster RAC .
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases administration.
• Implemented Data Guard with high availability and performance configurations.
• Worked with streams in En-queuing and de-queuing messages. Starting and stopping streams processes. Perform troubleshooting of streams environment.
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Successfully implemented Backup Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partitions, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using Exports from 10g database and imported in 11g using Data Pump.
• Responsible for capacity planning, database security, recovery planning and installing patches.
• Worked extensively on monitoring database, configuration of error notifications, setting up listeners, and adding them to the 10g Grid Control.

Environment: Oracle 11g/10g, Oracle 10g/RAC, 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/12i assigned to work with Bimbo Bakeries USA BBU Company, worked in meetings with BBU functional users, Amdutch and Softtek people team to analyze requirements of new projects for 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 export/import and table spaces transported in 11g.
• Responsible for database security and installing patches.
• Worked on monitoring DB with Grid Control 10g, configuration of error notifications.
• Responsible to analyze and to understand functional customer requirements and assigning and supervising development 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 12i, Oracle DB 10g, 11i, Solaris, JDeveloper, Forms, Reports, Pro C, Shell Script.

Citigroup, Tampa, FL. April 2001 - August 2007

Sr. Oracle DBA

Description:

Extensive experience as Sr. Oracle DBA and HPUX administrator. The last years acquired responsibilities of IT manager to coordinate Infrastructure Area and worked with Citibank Technology Center in order to maintain subsidiaries in compliance with IT SOX Regulations for databases, applications and servers.

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 configurations 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 with best practices of IT security software vendors and Oracle Support Metalink in a quarterly basis accordingly of IT SOX regulations.
• 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 Active Data Guard for production databases with high availability and performance configurations and participated in Data Guard Fail Over tests.
• Performed Database Refresh from Production to DEV, QA and UAT environments.
• Tuning DB for Event Waits, 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.
• Cloned Databases using RMAN and OS Cold Backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Statistics, etc.
• Supported development teams by elaborating manuals for SQL statement tuning and optimizing ETL procedures and removing bottlenecks issues by using EXPLAIN PLAN, STATSPACK, and TKPROF.

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.

Confidential

Oracle DBA Applications Lead

Description:

• Sr Oracle DBA assigned to work remotely in the project of the Oracle Applications 11i 11.5.1 Integration in Bakeries Bimbo USA BBU . 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 interfaces for the communication with Oracle Applications 11i by using Open Interfaces.
• Team leading responsible to supervise 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, DB Spaces, DB and applications tunings, Rman Backups.

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

Confidential

Oracle and HPUX Consultant

Description:

• Oracle DBA consultant assigned to the SEMA OTAF Project integration at UNEFON Company:
• HPUX administrator: troubleshooting, LVM, tuning, 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 Unixware administrator: Java Installation, troubleshooting, Apache admin, etc.

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

Confidential

Oracle DBA

Description:

• Project lead responsible of the development of Oracle Logistic System by coordinating and supervising teams in Forms and Reports. Architect of database model by modeling with SDesigner.
• Supervising developer team and programming in Forms and Reports.
• Daily activities as Oracle DBA: Installations, backups, tuning, migrations from Clipper5.3.as to Oracle 7 and troubleshooting with 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.

Environment: DBase, FoxProLN, Clipper, FORTRAN.

Confidential

System's Coordinator

Description:

• Started being Backups Administrator in 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 cadastre maps backups of whole Veracruz State.
• At the beginning I was doing automated cadastre maps using AU2C Systems.

Environment: DBase, FoxProLN, Clipper, AUD2C.