We provide IT Staff Augmentation Services!

Sr. Oracle Application Dba Resume

2.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Result oriented Oracle Application DBA with over 16 years of experience with Oracle Databases/Applications deployed on various platforms.
  • Strong knowledge of Oracle EBS, Performance Tuning, Space Management & Capacity Planning, PLSQL, GRC, Backup and Recovery.
  • Extensive experience in full lifecycle of Oracle Database systems, complete ERP implementations and System Administration of R12/11i application suite at numerous organizations of varying size and complexity.
  • Experience in configuring HA solutions with VMware, EMC Storage Devices, and Confidential for oracle databases.
  • Extensively working on oracle database installations/Upgrade and Database migrations of Oracle databases (7.x and 8i, 9i, 10g 11g, and 12c ) and Oracle Application Suite (11i/R12).

TECHNICAL SKILLS:

Oracle Products: Oracle 9i - 12c Database Administration, Oracle Application DBA eBusiness Suite 11i/R12 with P2EU upstream, Rapid Clone, RMAN, Data Guard, RAC, Discoverer 10g/11g, OEM, Weblogic, Golden Gate.

Software: Microsoft office, Visio, Project, Apache, IIS, NetBackup, Kofax, MarkView, and Opentext, Toad.

Operating Systems: LINUX AIX, SOLARIS, UNIX, HP-UX, Windows Server 2K3 -2K8

Network: F5 Load Balancers Cisco network switches, ASA firewalls, and routers.

Storage: Confidential, Dell Compellent, IBM, Confidential, EMC

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Application DBA

Responsibilities:

  • Perform monthly clones using Rapid clone to refresh R12 EBS TEST/DEV environments from Production.
  • Performed cross platform migration of legacy11i EBS system from AIX to OEL to eliminate $40K in IBM annual support.
  • Applied quarterly CPU/PSU patches, EBS patches, for Oracle applications R12 instances and standalone databases.
  • Perform daily DBA task such as database monitoring, custom code deployments, security, and concurrent manager monitoring.
  • Configured and managed hot backups using RMAN solution for 20 production databases.
  • Implemented disaster recovery solution using Data Guard Physical Standby databases for one production multi-tier R12 EBS environment and 19 standalone productions databases.

Confidential, CA

Senior Management Consultant

Responsibilities:

  • Planned and executed eBusiness suite upgrade from 11.5.10.2 to 12.1.3 on multi-node Linux environment
  • Upgraded EBS database from 11.2.0.3 (11gR2) to 12.1.0.1. (12c)
  • Cloned Oracle application/Database using Rapid clone to refresh TEST/DEV/CRP Instance.
  • Configured online database backup with RMAN.
  • Planned database, application patching for Oracle applications (ERP) 11.5.10.2/R12 instances.
  • Prepared documentation of database backup and recovery standards
  • Provided detailed roadmap to resolve audit findings with user credentials and access for 100 oracle database to assure environment was in security compliance before next audit review.
  • Implemented process to assure changes and modifications to RDMS are approved and documented.
  • Provided weekly status reports detailing completed task and open items.
  • Created detailed Solution designs, Disaster recovery plan, Implementation Plans, Technical recovery Plan and for databases that needed to be moved to Disaster recovery environments
  • Worked with Senior DBA team to implement cross platform migration using golden gate from DB2 Mainframe to Oracle 11Gr2 schema on Linux.

Confidential, El Segundo, CA

Information Technology Director (Database Administration & Linux systems)

Responsibilities:

  • Managed and administered EBS environment versions 11.5.10.2 and 12.1.3 on multi-node Linux environment.
  • Successfully, performed all facets of the EBS DBA role including, installation, upgrades, backup and recovery using RMAN, cloning using Rapid Clone, Oracle Enterprise Manager, EBS patching, SR support, and performance tuning .
  • Planned and executed 3 Cross-platform oracle database migrations/upgrade from 9i Solaris 64bit to 11gr2 Red hat Linux 64 bit.
  • Enhanced Oracle backup and recovery strategy by converting from Confidential user managed backup solution to Confidential RMAN backup solution to assure Confidential reliable backup and recovery solution was in place.
  • Successfully and implemented annual disaster recovery plan to assure EBS environment and all oracle databases met 4 hour RPO/RTO business requirement. Architected and implemented three Physical standby databases using Confidential Snap manager. Annual DR Test showed that business-critical database systems were certified to be fully operational within 1 hour, and non-critical business system was completely restored and was operational within 8 hours.
  • Planned and executed monthly refreshes/clone for DEV TEST and Staging environments in accordance with code release schedules and adhoc request.
  • Implemented Oracle enterprise grid control 11G for centralize monitoring of the database environment.

Confidential

Senior Management Consultant

Responsibilities:

  • Planned and execute " Confidential ” HDS to " Confidential SAN” migration which involved migrating Oracle, Windows, Exchange, and VMware environments to new storage.
  • Reworked, database hot backup strategy with DBA team to leverage Confidential snap manager for oracle.
  • Conducted analysis of infrastructure sighting current status and provided recommendations to executive management to improve.

Confidential, Houston, TX

Sr. Oracle Application DBA

Responsibilities:

  • Planned and executed oracle eBusiness upgrade from Solaris to 11.5.9 to 11.5.10.2
  • Upgraded production database from 10GR1 to 10gR2.
  • Migrated database to from old Confidential storage To new platform

Confidential, Houston, TX

Sr. Oracle Application DBA

Responsibilities:

  • Provided application DBA support for multi-tier EBusiness system and RAC marketing system running Red hat Linux.
  • Assisted DBA team with patching and cloning of all eBusiness environments
  • Perform patch management and code migration form DEV to TEST to PROD.

Confidential, Irvine, CA

Sr. Oracle Application DBA

Responsibilities:

  • Led implementation to migrate 11i production EBS instance from Oracle on Demand (Hosted environment) to in-house environment
  • Planned and led database upgrade from 9i to 10gr2 Database.
  • Trained in-house IT staff to setup and administer 11i eBusiness Suite environment and use Rapid Clone.

Confidential, Santa Monica, CA

Database Manager

Responsibilities:

  • Managed DBA team that consisted of two full time DBA’s and one contract resources responsible for 24/7 database administration EBusiness suite.
  • Coordinated refresh schedules with application development and functional teams for DEV, TEST and UAT environments.
  • Planned and executed Oracle Financial 11i upgrades from 11.5.3 thru 11.5.10.2 on database versions 9i thru 11G.

Confidential, Santa Monica, CA

Senior Database Consultant

Responsibilities:

  • Provided Oracle DBA support and assisted the DBA team with addressing performance issues on reporting database.
  • Mentored, DBA team and provided Confidential methodology to identify poor performing queries and solutions to improve performance .
  • Assisted database team with implementing global partitioned tables/indexes & tablespaces.

Confidential, Redwood City, CA

Senior Consultant

Responsibilities:

  • Architected and Implemented enterprise environments nationwide using oracle products such as eBusiness Suite, Oracle Databases, and Business intelligent. Successfully, performed all facets of the DBA role including, installation, backup and recovery using RMAN, cloning, RAC, Oracle Enterprise Manager, upgrades, patching, SR support, and performance tuning .
  • Coordinated and performed Oracle application and database upgrades for clients on multiple releases in the technology stack.
  • Oracle E-business suite modules include (finance) Confidential /R, Confidential /P, G/L, F/ Confidential, P/O (human resources) Benefits, Self-Service HR, Payroll, Discoverer, Projects, ADI.

We'd love your feedback!