SUMMARY

• A self - motivated, detail-oriented, dedicated, responsible and reliable team player with over 12 years of experience in the IT Industry as Database Administrator, specializing in Oracle Database Administration, Data Guard, Performance Tuning and E-Business suite, seeking an opportunity where I can provide Oracle Database Design, Administration, Database/Application Performance Tuning using my professional tuning techniques, Data Modeling and Benchmarking expertise.
• Database Administrator Oracle 8i, 9i,10g,11i and 12c.
• Installation, configuration, maintenance and troubleshooting of EBS 11i and R12.
• Oracle Disaster Recovery solutions (Physical and Logical Data Guards).
• Oracle Backup/Recovery Solutions (RMAN,EMC Networker,HP data protector).
• Installation, patching and troubleshooting of Oracle Demantra.
• Installation and troubleshooting of Oracle agile.
• Installation, maintenance and troubleshooting of Oracle OBIEE & informatica.
• Linux installation and administration - RHEL/ORHEL 2.1&4, 5&6.
• HP-UX Administrator.
• Oracle Applications 11i & 12 - SysAdmin.
• Oracle Application Server (iAS) 9i & 10g.
• Administer Oracle Collaboration suite.

PROFESSIONAL EXPERIENCE

Confidential

Oracle APPS DBA & Project Lead

Responsibilities:

• DBA and project leader in the completion of 80+ medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
• Developed and tested storage strategies and disaster-recovery plan on operational database, delivering solution that guaranteed recovery performance and high availability
• Part of a cloud project to migrate existing databases to Amazon.
• Provided 24/7 production support on a rotational basis along with a team of six DBA’s.
• Database performance optimization, tuning and monitoring.
• Upgraded databases 9i and 10g to 11g.
• Migrated databases from 32 bit to 64 bit.
• Performed a successful switch over/ fail over of physical data guard between Phoenix and Torrance data centers.
• Setup multiple Oracle 10g/11g RAC, ASM, DATA GUARD environments.
• Used AWR, ADDM, SQLTRACE, and TKPROF to diagnose the database performance issues.
• Setup and managed RMAN for database backup and recovery purposes.
• Installed a configured GRID control and OEM (OMS, Grid Agents).
• Monitored production databases using Big Brother/ Big sister monitoring tools.
• Oracle EBS 11i and R12; clones, upgrades, administration and applying patches.
• Cloned and refreshed test/dev instances from production servers.
• Oracle Apps - Sysadmin role.
• Third party application configuration with EBS (Loftware,shipping,reporting..etc).
• Oracle Demantra, ASCP and OBIEE database admin.
• Installed and integrated Oracle Agile (PLM system) with EBS.
• Application performance tuning.
• RedHat RHEL 5/6 system administrator and patch management.
• Created custom scripts to monitor Oracle and RedHat resource status and processes.
• Installed and configured SAMBA servers for Oracle reporting use.
• Part of the extended leadership team since 2013 representing the IT department to address ideas, solutions and issues to the Executive Team.

Confidential, CA

Oracle Apps DBA & System Administrator

Responsibilities:

• Leading and managing the offshore and on site teams with 24/7 production support.
• Strong database, application and development tool troubleshooting expertise. Experienced in logical and physical database design, modeling. Hands on database performance and instance tuning for both RAC and NON-RAC environments. Managing Grid Control.
• Oracle E-Business Suit administration EBS 11i cloning, patching, user administration, application upgrades, DMZ configurations and troubleshooting.
• Migrated EBS single node instance to multi nodes under different platforms.
• Setup and administrated oracle WMS.
• Upgraded Linux servers to higher version and migrated existing oracle instances.
• Upgraded oracle iAS to a higher version and redeploy applications.
• Installed and administrated OBIEE (WAREHOUSE DATABASE) under Linux and Windows environments.
• Administrated and setup Informtica.
• Installed oracle ASCP 11.5.10.2 and setup decentralized data collection for planning instance.
• Installed and upgraded Oracle Demantra
• Setup Oracle 11i DMZ (iStore, iSupplier).
• Oracle Database administration (installation, backup configuration using RMAN, applying security updates and bug fixes, upgrades, cloning and user administration) of 9i/10g/11g
• Complied with all ETS security and audit standards. Ensured the security of the company information by ensuring database is secure and monitor the environment to identify improper access.
• Configured and developed monitoring shell scripts to trigger an alert if services are down.

Confidential

Oracle 11i Applications DBA-Technical Consultant

Responsibilities:

• Installed and upgraded Oracle EBS from 11.5.9 to 11.5.10.2 and Database 9i to 10g.
• Applied EBS Patches and updates.
• APPS database tuning (production and test databases).
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle9i & 10g database.
• Responsible on migrating from MRP to ASCP
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Continuous performance monitoring and database tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Performed database and application cloning of production database on TEST environment to provide users the live data for testing purposes.
• Created application users, profiles, responsibilities, menus and functions for the user
• Troubleshooting and Tuning Application Server. iAS backup and recovery.
• EMC networker backup solution and HP data protector
• Installed and managed Oracle under Linux.
• Created custom Linux scripts, as alert and fail over.
• Part of a team to install and implement EMC-Networker 7.3 to be integrated with Oracle databases for online backups.

Confidential

Oracle Technical Support Engineer

Responsibilities:

• Provided technical support and administration on many Oracle products under different operating systems.
• Administrated, installed and configured Oracle databases 8,8i,9i
• Database Architect (Production and Development Database).
• Oracle 9i RAC (Real Applications Cluster).
• Oracle Performance Tuning.
• Backup and recovery via RMAN scripts and troubleshooting.
• Oracle Application Server from 9 to 10g.
• Administrated, installed and configured Application server.
• Oracle Collaboration Suite from 9i to 10g.
• Installed and configured the backup solutions for Oracle.
• Administrated Microsoft SQL Server 2000 Database.
• Installed and administered RedHat and HP-UX.
• Setup high performance and availability on many oracle products.
• Setup application for load balancer.
• Setup archiving file system.
• Setup and configure third party applications with Oracle.
• Migrated Oracle database for upgrades and databases to Oracle databases