Managing Oracle DBA Resume

PROFESSIONAL EXPERIENCE

Managing Oracle DBA

Confidential

Responsibilities:

As an owner and managing Oracle DBA for Confidential I have been partnerships with Big Four over past 5 years, and managing high - profile projects using Oracle latest EBS/Apps/SOA and database technologies
Full DBA consulting capacity and capability for full-cycle production new install, design, architecture, setup roll-out, configurations, upgrade and migration; also ad hoc consultancy for production performance tuning, troubleshooting, proof-of-concept and set up latest Oracle technologies like TimesTen (IMDB), Golden Gate (GGSCI), 11gR2 Grid Control, Fusion Middleware 11g, Weblogic 11g, Apps Big Tablespace conversion, extended Single Sign-On setup, extended AWR analysis and ADDM reporting, ADR, ASM conversion and Oracle storage optimization
Best practices for major Oracle new database and EBS/Apps/SOA technologies. Document major Oracle DBA procedures, including the CPUs, SOX auditing and reports, Oracle backup and recovery, new feature installs, DBA runbook. Present new Oracle technologies and feature to clients

Lead Senior Consultant

Confidential

Responsibilities:

Leading in implementing major Oracle Applications including design, system integration, upgrade, migration, and performance optimization from 11.5.x to 12 using Oracle 10g/11g, RAC and MAA;
Assess and propose the full cycle of new Oracle Apps implementations including hardware and software architecture, system configurations, backup and restore, RAC/HA setup, embedded Oracle data warehouse with Oracle Business Intelligence, ETL, ASM on AIX, Solaris and Linux servers;
Handling severity # 1 TARs and critical patches; Troubleshooting and performance tuning; Cloning Apps instances and refresh/replicate schema data via Database Control and Grip Control; Fine-tune workflow mailing; Maintain RAC operations, DR and RMAN-based recovery;
Promoting new features of Oracle Apps 12, Fusion and Oracle 10g/11g; Checklist and roadmap the upgrade and migration from Apps 11i to 12; Design and document each Apps-specific build; Provide the Apps DBA runbook; Transfer knowledge to onsite and offshore data centers

Managing Principal Consultant

Confidential, CA

Responsibilities:

Lead in applying major Apps installs, upgrade and migrations including recent upgrade from 11.5.x to 11.5.10 using Oracle 10g and RAC; Manage patching such as HR K and Financials G, as well as various critical security patches and the year-begin/end Payroll patches
Assess and propose the full cycle of new Oracle Apps implementations including hardware and software architecture, system configurations, backup and restore, RAC/HA setup, embedded Oracle data warehouse with Oracle Business Intelligence
Handled severity # 1 TARs; Performance tuning; Cloned Apps instances and refresh/replicate schema data; Set up self-service Apps like iExpense and iProcurement; Fine-tune workflow mails; Maintain RAC operations
Introduce new features of Oracle Apps 12, Fusion and Oracle 10g; Roadmap the upgrade and migration from Apps 11i to 12; Provide pre-sale and post-sale supports with onsite demo/presentation

Lead Oracle DBA Consultant

Confidential

Responsibilities:

Manage major Oracle Apps tasks including advanced security setup, site and row-level auditing, performance tuning, system architecture, patching, TAR, backup and restore policies, vendor communications, demos of Oracle new features, migration and upgrade
Development and production support for 15 productions and 20 QA/testing databases; Administration of both OLTP, data warehouse and Apps servers using Oracle replication, home-made refresh, Oracle Financials and 9iAS
Deploy of RAC on RedHat as mid-tier using Oracle 10g and Apps 11.5.9; Troubleshoot and fix various issues of Apps database and systems using Oracle TAR, MetaLink, Apps OEM and other diagnostics tools
Migration of the core Financials/membership Apps system from 11.5.7 to 11.5.9; Management of user account, apps security, concurrent processing, batch jobs, patching and profiles as System Administrator
Back up and restore of all production and QA systems using EBU, RMAN, logical and physical standby, and cloning; Data access and usage securities and auditing