SUMMARY:

• 8+ years experiences in Information Technology as Oracle Database Administrator (10g, 11g, 12c).
• 8+ years experiences in Unix - like system administration (Linux). Proficient in developing management / monitoring scripts by using Korn/Bash Shell.
• 8+ years in-depth knowledge and solid hands-on experiences of installation, configuration, trouble-shooting and performance tuning in Oracle 10g/11g R2 RAC/12C RAC (Real Application Cluster), ASM (Automatic Storage Management), Data Guard (physical standby database), Goldengate, Oracle Enterprise Manager (11g, em12c).
• Proficient in Oracle database backup & recovery strategies plan and implementation such as RMAN backup with/without catalog, cold and hot backup, full/incremental backup. Hands on experience in disaster recovery.
• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Solid hands-on experiences in developing complex database objects like Stored Procedures, Functions, Package and Triggers using SQL and PL/SQL.
• Great experience in implementing and operating Oracle E-Business Suite Financial R12 (AP, AR, GL)
• Experience in managing PeopleSoft FSCM and HCM.
• Experience in Solarwinds, Netapp SMO (SnapManager for Oracle), and Oracle OVM (Oracle Virtual Machines).
• Experience in Oracle Advanced Security 12c data encryption and redaction.
• In-depth knowledge in managing Oracle Fusion Middleware (OAM/OID, WebLogic, Oracle Forms & Reports, Oracle Discoverer)
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

PROFESSIONAL EXPERIENCE:

Confidential, Orange, CA

Oracle DBA

• 24x7 Production database support.
• Managing Oracle Enterprise Manager 12C to communicate with multiple targets.
• Deploy OEM Agent 12c to multiple targets.
• Maintain 50+ Oracle databases range from 30GB to 2TB.
• Managing Goldengate to stream replication for data warehouse.
• Applying quarterly Oracle CPU (Critical Patch Updates) and Oracle RDBMS Patches for bug fixes.
• Create tablespaces, tables and indexes, sizing the tablespaces, allocating default table space for users.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Involved in database cloning, tuning, and monitoring
• Install and configure Oracle Advanced Security 12c and setup data encryption and redaction.

Confidential, Corona, CA

Oracle DBA

• 24x7 Production database and applications support.
• Upgraded Oracle Database / RAC from 11gR2 to 12c.
• Installed and Configured Oracle Enterprise Manager 12C to communicate with multiple targets.
• Applying quarterly Oracle CPU (Critical Patch Updates) and Oracle RDBMS Patches for bug fixes.
• Managing the Oracle Fusion Middleware with WebLogic.
• Managing and administering Oracle Applications EBS R12.1.3 (GL, AP, and AR module).
• Managing user accounts, roles, and privileges to the database.
• Migrated databases from Sun Solaris to Linux.
• Installed, configured, and maintained of ORACLE 11gR2 RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
• Implemented an Oracle EBS R12.1.3 production single instance environment to RAC environment (2 application nodes & 2 database nodes).
• Managing the Oracle Fusion Middleware (OAM 11g, OID 11g, and Oracle Forms & Reports 11g).
• Installed Oracle Forms & Reports 12c.
• Upgraded Oracle E Business Suite Financial from R12.1.3 to R12.2.3.

Confidential, Irvine, CA

Oracle DBA

• Performed maintenance checks and upgrades on systems as required
• Upgraded Oracle RAC from 10g to 11gR2.
• Refreshing database from production to development every two to three weeks.
• SQL tuning as part of enhancing development code.
• Monitoring performance using AWR repository.
• Monitoring backup logs, alert logs and trace files for ORA errors.
• Performance tuning large Oracle database using defragmentation, identifying indexes and implementing materialized views.
• Exporting and Importing schemas with LOBs.
• Recovering standby databases by applying the archived logs.
• Load and Transform data using SQL*Loader and External Tables
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Partitioned large tables for better performance and manageability.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.

Confidential, Alhambra, CA

IT Support Technician

• Provide, as appropriate, telephone and verbal application support to resolve incidents.
• Maintain written communication such as log updates to a professional and legible standard.
• Monitor and respond to hardware and software problems utilizing hardware and software testing tools and techniques.
• Configure, install, update, troubleshoot, repair and replace computer systems, terminals, peripheral equipment and related hardware throughout the organization.