Senior Oracle Ebs Database Administrator Resume
CA
SUMMARY:
Over 18 years of IT industry experience, with almost 15 years at Oracle Corporation. Strong experience in administrating Oracle Applications E - Business Suite R12, 11i release and Oracle Database administration release Oracle 7.x, 8.x, 9i, 10g, RAC and 11gR2.
OBJECTIVE:
Looking for a Oracle Database Administrator/Applications DBA position
TECHNICAL SKILLS:
Database Systems: Oracle 7.x, 8.x, 9i and 10g, 11gR2, RAC, Datagaurd, RMAN, Exadata
Applications: Oracle Applications E-Business Suite Release R12, 11i6 to 11.5.10.2, 11.0, 10.7NCA, 10.7SC, 10.7, 11g Oracle Fusion Middleware, SOA, People Soft, Siebel, Hyperion, Weblogic Enterprise Manager 12c and SQL, PL/SQL .
Operating Systems: Windows, UNIX (HP, Sun Solaris, Linux and AIX).
PROFESSIONAL EXPERIENCE:
Senior Oracle EBS Database Administrator
Confidential, CA
Responsibilities:
- Operational support and maintenance for Oracle Database, RAC, SSO, Dataguard, High Availability and Backup/Recovery.
- Oracle Applications support and maintenance for Oracle EBS 11i & R12, including full life-cycle implementation experience, configuration and administration of the application.
- Knowledge of all major versions of technology stack including Discoverer, iAS, Forms, Reports, PL/SQL, Java, Enterprise Manager, SOA, WebLogic and JVM
- Expertise in Oracle Database and Oracle EBS Applications maintenance/patching mechanics and architecture.
- Support and maintenance of Standby database (Disaster Recovery).
- Knowledge of Siebel, PeopleSoft, Hyperion
- Providing 365x24x7 on call support (off hours and weekends).
Confidential, California
Principal Oracle DBA
Responsibilities:
- Supporting Oracle Ondemand Customers running various versions of Database (Oracle 8i, 9i, 10g and 11g), Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.x), Tech Stack (Discoverer, iAS, Discoverer, JDK, Jinitiator, and Developer6i) and Oracle Application Server
- Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging Ondemand Customer environments.
- Daily responsibilities include trouble shooting and restoring Oracle Applications components Apache, Forms, Reports, Concurrent Managers, Workflow Managers, Discoverer plus/viewer, iAS, Single Sign-on
- Running autoconfig, setting up DMZ, Discoverer, Oracle Sysadmin activities and other maintenance acitivities
- Performed Oracle Database and Applications Installations, Upgrades, Cloning, done extensive patching (both DB and Applications), applied CPU patches, Family Packs, Patchsets and Single off patches.
- Identifying, analyzing and resolving technical problems related to Oracle software systems.
- Restore failed services; find workarounds to reduce business outage situations.
- Worked on multi-node RAC DB and mutli-node Mid-tier Apps.
- Performance tuning on DB and Applications.
- Performing dry run for disaster recovery test for Ondemand Customer instances.
- Performed Disaster Recovery dry run for Federal Customer instances.
- Performed refreshes of Federal Customer instances.
- Performed trouble shooting and restoring services of Federal Customer instances.
- Switch over test from primary database to standby database.
- Physical and Logical primary/standby database and Datagaurd/Failover.
- Provide 24x7 on-call support.
- Supported customers running Hyperion 11.x in restoring services and during maintenance.
- Experience setting up Weblogic, support, maintenance and restoring services.
- Support and maintenance of systems running on Exadata.
Principal Database Administrator
Confidential
Responsibilities:
- Responsible for complete refresh of Oracle hosting services customer instances, which includes refresh of production, development and test instances.
- Performed complete refresh cycle, involving complete copy of source instance to target instance. This involves copy and configuration of database, application and other file systems (tech stack) from source to target instance.
- Performing health check, customer specific post-refresh steps and releasing instance to customer was also part of refresh cycle after doing the copy and configuration of file systems.
- Performed single tier, multi-tier, RAC refreshes.
- Involved in OS upgrade (32bit to 64bit) and then performed the database and application file system migrations.
- Daily activities also include addressing and resolving customer issues.
- Performed refreshes of 9i, 10gr2 database and application releases 11i and Release R12.
- Performing tech stack (Disco 10g) clone was also part of refresh cycle.
Principal Database Engineer
Confidential
Responsibilities:
- Responsible for the complete upgrade of customer instances, which involves completes cycle for upgrading Database, Applications and Techstack.
- Responsible for preparing the upgrade project plan for each customer upgrade.
- Database upgrades from 9i to 10gr2
- Application upgrades from release 11.5.8/11.5.9/11.5.10 to latest release 11.5.10.2.
- Techstack upgrades involve upgrading iAS, Discoverer, JDK, Jinitiator, and Developer6i to latest versions.
- Trouble shooting issues after the upgrades.
- Applying quarterly security patches (CPU) to customer instances.
- Applied Daylight saving patches (DST) to customer instances.
Principal Operations Engineer
Confidential, Redwood Shores, CA
Responsibilities:
- Creating and maintaining release and integration testing environments for testing Oracle Applications 11i product patches (family packs) for major releases (11i9, 11i10), Rollups and customer one-off patches.
- Responsible for releasing family packs, rollups, customer one-off patches to metal ink and Oracle internal teams.
- Providing release specific support for customer issues when approached by Oracle Support.
- Responsible for maintaining About Docs and metal ink notes for product patches
- Resolve release, build, porting and translation issues.
- Responsible for product source area branching for 11.5.10, resolving any issues with source area (code check-in and check-out).
- Maintain web-based information resources related to complex product integration process.
- Create and execute installation and patching scripts for various technology stacks
- Responsible for closing product family patch sets (family packs) in ARU (Oracle internal utility) for major Oracle Application releases, install testing on different application baselines and releasing.
- Responsible for testing and submitting product patch sets for inclusion into Oracle Applications Maintenance Packs.
- Follow up with APPSRE for product install bugs and driving to closer
- Responsible for creating, testing and releasing product family rollup patches on top of different Oracle Applications baselines (11i8, 11i9 and 11i10).
- Responsible for testing and releasing one off patches to Oracle Internal (APPSIT/GIT), ADS and customers.
- Fully responsible for defining and implementing complete release process, coordinating with development, operations and QA teams for each build and improve the existing release process.
- Providing support to development, operations and QA teams for release specific and patching issues. Help enforce code standards
- Providing support to dev teams for seedr7, seedr8, seedr9, seedr10 and seed115 (Oracle Internal databases) to download the seed data.
- Educating users of the tools and utilities
- Work with remote teams (Australia and India).
Release Manager
Confidential, Redwood Shores, CA
Responsibilities:
- Responsible for providing complete environment support for the product development teams, which involves creation and maintenance of different baseline environments for development, unit testing, functional testing (QA certification) and release (install/ integration) testing.
- Provided support for Demo instances used for customer demos and instances used at Oracle AppsWorld.
- Successfully managed releasing 11.5.7, 11.5.8 and 11.5.9 Family Packs to metalink for responsible products.
- Responsible for testing and submitting product patchsets to Oracle Applications Maintenance Packs.
- Responsible for product source area branching for 11.5.7, 11.5.8 and 11.5.9 for the products listed.
- Fully responsible for defining and implementing complete release process, coordinating with development and QA teams for each build and to improve the existing release process.
- Providing support to development, operations and QA teams for release specific and patching issues.
- Providing support to dev teams for seedr7, seedr8, seedr9 and seed115 (Oracle Internal databases).
- Responsible for closing product patchsets in ARU for all major releases.
- Responsible for creating, testing and releasing one off patches to Oracle Internal (CRMIT), ADS and customers.
- Responsible for testing Upgrade patches for 3i (pre 11i) customers, submitted product patches for CRM Upgrade Pack for 1158 and 1159.
- Responsible for creating, testing and releasing Rollup patches (bug fixes) in between major releases.
- Providing release specific support for customer issues when approached by Oracle Support.
- Responsible for maintaining updated About Docs and metalink notes for product patches.
- Visited customers (as part of visit by dev/qa/release teams) to determine customer requirement to uptake new patches.
- Managed team located overseas, India (IDC Banglore).
- Worked/coordinated with overseas development, operations and qa teams in India and Australia.