SUMMARY

• Over 15 years of progressive and diversified experience as a Sr. Oracle Apps DBA with extensive skills in architecting and implementing Oracle Applications environments.
• Solid experience as an Oracle Core and EBS DBA administering Databases and ERP Applications.
• Advanced background in Oracle 9i, 10G,11G & 12c Databases, RAC, Oracle Applications 11i, Release 12 & 12.2, GRC Suite, OBIEE Applications, SSL, SSO, OID, 10G Grid Control, OIM, designing databases and performance tuning.
• High level of organizational skills to handle multiple tasks with precision detail.
• Reputation for being a dependable, hard worker. Commitment to providing exceptional service and support. Co - operative, team oriented professional.

TECHNICAL SKILLS

Hardware & Operating Systems: SUN Solaris 8/9, HP - UX 10.20/11.0, HP-UX Itanium OS 11.2/11.23, IBM AIX 5.1/5.2/5.3/6.1 , Sequent SE70, NumaQ, PtxDynix, Compaq Servers, Linux (x86, X86-64), Windows 2003, 2008

Databases: Oracle RDBMS 7.x/8.x/8i/9i/10G/11G/12c (RAC), SQL Server 2000/2005

Applications: Oracle Apps 11i/12/12.2

Application Modules Implemented: All modules in ERP, FIN, and HR

Other Technology Products Implemented: WebLogic Server, OBIEE 10g/11g, APEX 3.1, UPK, GRC Suite, 10gAS, Single-Sign On, SSL, OID, Identity Management Suite, Access Management, Role Manager, Agile and Essbase

Tools: 9i/10G OEM 10g/11g/12c, OAM, RMAN, Statspack, Quest Central, Spotlight, Data Guard, ADI 7.x, Informatica, Ascential, Toad 8.6, 10G Grid Control, Erwin Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Present Irvine, CA

Senior Oracle DBA

Responsibilities:

• Supporting ASM instances
• Refreshing ASM Databases
• Partitioning Tables in data warehouse instances
• Administering 10g WebLogic server and upgrading to 11G
• Supporting 11i and R12.2 instances
• Online patching in R12.2 and cloning instances
• Supporting 12c databases

Confidential, Santa Ana, CA

Oracle DBA

Responsibilities:

• Installed R12.2 on dev, test and production in Linux environment
• Providing support on EBS 12.1.3 development and production instances
• Cloning instances
• Patching
• Applying database patches using Opatch
• Configured RMAN and taking backups
• Configured Workflow Mailer
• Installed Apex 3.1 with the Glassfish server
• Installed and configured OBIEE 10g & 11g
• Installed 10g WebLogic server and Administering
• Upgraded EBS from 11.5.10.2 to 12.1.1
• Upgraded EBS from 12.1.1 to 12.1.3
• Upgraded Oracle Database from 10.2.0.5 to 11.2.0.4

Confidential, Los Angeles, CA

DBA Lead Consultant

Responsibilities:

• Worked with IT Management in planning strategies for implementing DR databases
• Implemented Data Guard for DR
• Assisted in Logical and Physical Design of 11G Databases in Linux

Confidential, Torrance, CA

Apps DBA Lead Consultant

Responsibilities:

• Provided support and trained in-house Apps DBA for R12 E-Business Suite issues
• Applied various patches
• Provided support on Essbase and Agile

Confidential, Santa Monica, CA

Sr. Oracle DBA

Responsibilities:

• Assisted users in resolving data issues and generated reports
• Performance Monitoring using 10G Grid Control
• Supported 10G RAC instances
• Upgraded 11.5.10.2 to 12.1.1 E-Business Suite on Linux

Confidential, Los Angeles, CA

Sr. Apps DBA Consultant

Responsibilities:

• Managed a team of 4 DBA’s and offshore DBA’s for a consulting project
• Prepared Instance strategy plans for upgrade of Oracle Applications 11.5.10.2 to Release 12
• Upgraded 11.5.10.2 to Release 12
• Migrated 11i Database of size 1.5 terabytes from HP-UX to Linux using Export/Import Data Pump
• Prepared design for implementing Single-Sign On
• Applying Family Pack patches for 11.5.10.2
• Installed R12 on Linux
• Supporting Agile & Essbase integrated with Oracle Applications R12

Confidential, El Segundo, CA

Sr. Consultant

Responsibilities:

• Supporting clients all over the US in implementation of Oracle Databases, Application Servers, Identity & Access management
• Installed 11g Database
• Installed OIM
• Configured SSO
• Installed OBIEE
• Installed WebLogic Server
• Installed and supporting 10gAS

Confidential, Tustin, CA

Sr. Oracle Apps DBA Lead

Responsibilities:

• Managed a team of 3 DBA’s and Unix Admin
• Architected and designed the infrastructure layout for implementing new databases using OFA
• Key participant in administering Linux Servers and making recommendations.
• Installed Oracle Applications Release 12.0.4 on AIX 5.3 & 6.1 and Linux with Financials, ERP and HR Modules on Cisco Load Balancer.
• Implemented Single Sign-On.
• Implemented OID.
• Upgraded Oracle Applications Release 12.0.4 to 12.0.5.
• Upgraded 12.0.5 to 12.0.6.
• Upgraded Database 10.2.0.1 to 10.2.0.3 and 10.2.0.3 to 10.2.0.4
• Installed Complete Governance, Risk and Compliance Controls Suite.
• Applied patches for GRC. Resolved various issues in GRC.
• Installed Stellent & GRCM on Windows 2003.
• Installed OBIEE applications on Linux.
• Installed OBIEE Database on AIX 6.1.
• Installed UPK.
• Installed 10gAS on Linux Servers load balanced on Cisco.
• Configured SSL.
• Applied various one-off patches.
• Cloned multiple instances.
• Installed and configured 10G Grid Control. Performance Monitoring through Grid Control. Cloned Databases through Grid Control. Installed Grid Control Agents.
• Installed Applications Management pack.
• Installed 11g Database for RMAN
• Managed RMAN backups.
• Implemented Shared APPL TOP.
• Implemented APPS Tier on Cisco Load Balancer with SSL mode.
• Configured Wallet on DB Tier for Configurator.

Confidential, Irvine, CA

Sr. Oracle Apps DBA

Responsibilities:

• Practice Management: managed all Oracle consultants, including recruiting, hiring, retention, terminations, career planning, training planning, goal setting, performance reviews, project assignment and billable utilization
• Architected, designed, developed and implemented new databases from the scratch; migration from SQL server databases.
• Installed 11.5.10 on Solaris & HP-UX. Installed 11.5.9 on Linux.
• Migrated from 11.5.8 to 11.5.10.
• Cloned instances using Rapid Clone.
• Performance Tuning using various Trace Levels.
• Supported instances on 10G RAC with ASM on Linux.
• Converted Single instance to 10G RAC with ASM.
• Installed Data Guard for Standby Database.
• Applied various one-off patches, Family Packs and Mini Packs.
• Used ‘ad splice” to add new definitions.
• Applied SCM Family Pack J, Rollup Patch and Oracle Configurator patches on 11.5.10
• Installed 9i databases on Sun Solaris, AIX, Linux and performed many upgrades.
• Installed 11.5.8 on AIX 5.2.
• Installed 10G databases on AIX 5.2/5.3.
• Implemented Statspack for performance tuning.
• Used top, vmstat, sar for performance tuning and load tests.
• Used export and import between various instances.
• Performed hot and cold backups.
• Performed Capacity Planning.
• Configured RMAN.
• Installed and implemented Oracle E-business suite 11.5.9 using UTF8 with 9.2.0.3 database in a multi-node on.
• SUN Solaris 9 with various modules including WMS, WIP, BOM, WSH, ONT, HR, BEN, OTL.
• Installed 11.5.8 using UTF8 on Veritas Cluster and supporting the HA Veritas Cluster environment.
• Upgraded from 11.5.5 > 11.5.6 >11.5.7>11.5.8>11.5.9.
• Supported 15 to 18 instances with databases sizes ranging from 500 gig to over a terabyte.
• Refreshed multiple instances, TAR support, production support etc.
• Upgraded database from 8.1.7.3 to 8.1.7.4.
• Installed and configured Oracle Discoverer 4i.
• Installed/applied Oracle database and Oracle E-Business suite patches.
• Installed and configured Oracle Enterprise Manager (OEM).
• Responsible for all Applications Systems Administration tasks.
• Responsible for code and program migrations from Development, QA and Test instances to production.
• Used Veritas Netbackup for hot backups.
• Used OEM and Spotlight for performance tuning.
• Supported SOX compliance projects.

Confidential, Lake Forest, CA

Senior Oracle Apps DBA

Responsibilities:

• Supported 11.5.9 instances worldwide in both development & production environments on Solaris.
• Supported Change Control processes.
• Supported SOX requirements.
• Patched various 11.5.9 instances.

Confidential, Irvine, CA

Senior Oracle DBA

Responsibilities:

• Designed Databases and Data Modeling using Erwin.
• Supported 9i & 10G databases for various projects on HP & Linux.
• Supported databases on 9i RAC environments.
• Supported Data Warehouse projects with database sizes over 17 terabytes.
• Supported development teams in performance tuning.
• Responsible for code migration between various instances.
• Supported SOX Compliance controls.

Confidential, Irvine, CA

Senior Oracle DBA

Responsibilities:

• Installed 9i Databases on Solaris 8.
• Designed the database layout.
• Data Modeling using Erwin.
• Administered Solaris Servers.
• Involved in performance tuning.
• Supported development teams.
• Managed backups.
• Supported Sox Compliance Controls.

Confidential, Ontario, CA

Senior Oracle DBA

Responsibilities:

• Installed & configured 9i databases and applications 11i.
• Upgraded Applications from 11.5.2 to 11.5.8.
• Applications Systems Administration.
• Worked closely with developers in fine tuning the code.
• Patched and kept track of all the patches applied on all instances.
• Responsible for all systems administration tasks.
• Cloned multiple instances.
• Configured RMAN.
• Managed hot and cold backups.
• Created the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and password security.
• Extensive Performance Tuning, Memory (SGA) Tuning.
• Configured and maintained the clustered environment while doing data replication and migration.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.

Confidential, Torrance, CA

Senior Oracle DBA

Responsibilities:

• Installed Oracle 8i and managed on SUN Solaris.
• Installed 11.0.3 and production support.
• Performance Tuning using Statspack and Spotlight.

Confidential, Marina Del Rey, CA

Senior Oracle DBA

Responsibilities:

• Installed 8i on Linux Red Hat.
• Administered Linux Servers.
• Designed both logical and physical modeling for new databases.
• Managed Hot and Cold Backups.
• Data conversion from Sybase to Oracle database.
• Used Statspack for performance tuning.
• Created the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and password security.
• Data Warehouse Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Extensive Performance Tuning, Memory (SGA) Tuning, Defragmentation of database using export & import.

Confidential, Costa Mesa, CA

Oracle Apps DBA Consultant

Responsibilities:

• Production DBA support for both Oracle Database and Applications-Financials on 10.5 Character.
• Acted as a Systems Administrator and performed Systems Architecture functions at the same time.
• Handled the Data Migration.
• Installed 10.7SC & NCA on Solaris.
• Performance Tuning of Oracle Financial Applications.
• Applications Systems Administration.
• Developed custom forms and reports.
• Used SQL Loader.
• Installed, upgraded, and configured Oracle (7.1.6, 7.3.3.5) and Oracle. Applied patches both server side and client side.
• Setup new environments (development, testing, conference room pilot, production, etc.).
• Upgraded to Oracle Server 7.3.3.5.

Confidential, Costa Mesa, CA

Sr. Consultant

Responsibilities:

• Installed 10.7SC & NCA on Solaris for clients
• Applications Systems Administration
• Developed Custom forms and reports
• Handled the Data Migration
• Used SQL Loader
• Setup different environments for dev, test, qa & prod

Confidential, Pasadena, CA

Software Engineer

Responsibilities:

• Programming and Administration

Confidential, Costa Mesa, CA

Sr. Oracle Developer

Responsibilities:

• Developed ER and data flow diagrams, Performed Data Modeling and architectural design of the data warehouse.
• Developed several stored procedures.
• Creation of database, tables, users, roles in Oracle7.0.