We provide IT Staff Augmentation Services!

Sr Oracle Application Dba Resume

SUMMARY

  • Extensive experience with the Oracle Database with the necessary insight to ensure that any Oracle implementation will make the best use of the database functionality
  • Upgraded Oracle Application 11.0.3 to 11.5.10.2 and 11.5.10.2 to R12.2.4
  • Upgraded DB version 10.2.0.2 to 10.2.0.4, 11.2.0.1 to 11.2.0.3, 11.2.0.3 to 11.2.0.4
  • Implemented R12.1.3 Oracle Application, Implemented Oracle Revenue Management and Billing application
  • Provided Production support for Oracle Application of various different versions, provided Production support for RMB application, OBIEE application, Applimation, Journix application, Demantra Application, Discoverer to name a few
  • Provided Core DBA support for various Oracle Database versions
  • Planned, designed and implemented Real Application Cluster for High Availability
  • Had proven track record of success in supporting clients and providing insight that can only be obtained from broad range of experience with the Oracle database and integrated packages in JAVA, Web Server, EJB, XML, and Web Logic

TECHNICAL SKILLS

Database: Oracle 7.3.4/ 8.0.4/ 8.0.5/8.0.6/ 8.1.5/ 8.1.6/8.1.7/ 9.0.1.4 / 9.2.0.1/9.2.0.6 10.2.0.2. 10.2.0.4 , 11.1.0.6, 11.2.0.1, 11.2.0.2, 11.2.03.0.8 ,11.2.0.4

Tools: SQL Navigator, Precise, Spotlight, Oracle Enterprise Manager, TOAD, AD Tools, Erwin, All Fusion Harvest Change Manager, Designer, Forms Developer, Reports, Discoverer, IT governance, Kintana, Export, Import,datapump, RMAN, Data guard, grid control, OBIEE, RAC 10g and 11g,CtrixIBM Rational

PROFESSIONAL EXPERIENCE

Confidential

Sr Oracle Application DBA

Responsibilities:

  • Implementing Oracle R12.2.2
  • Development support
  • User support

Confidential

Sr Oracle Application DBA

Responsibilities:

  • Oracle application 11i to R12.2.4 upgrade
  • Oracle Federal Financial
  • SOA, Weblogic,
  • OAM implementation and integration to R12.2.4
  • Informatica archive ILM 6.2 to 6.4 upgrade
  • Informatica applimation 11.5.10.2 to R12 upgrade
  • Production support for 11i and R12 application, Discoverer, OAM, informatica
  • Analyzed and Applied Quarterly Security patches to RAC DB, 11i Application, OAM, Discoverer, Informatica
  • Maintained oracle XML DB Repository
  • Provided End user support for various login issues for 400 users using IBM Rational Ticket System
  • Clone Dev, Test and UAT environments as needed basis
  • IBM Rational Suite
  • C - 6 Clearance

Confidential

Sr. Apps DBA

Responsibilities:

  • Product Development and user support R12.1.3 Application,
  • 11.2.0.1 Database upgrade to 11.2.0.3
  • Upgrade EBS db from 11.2.0.3 to 11.2.0.3.8
  • GRC Support
  • Oracle Revenue Management and Billing (RMB) Support
  • RMB cm.jar, SPLApp.war, framework code and patches deployment
  • RMB Blue print deployment
  • Clone RMB environment, troubleshoot weblogic issues
  • Web Content Management with IPM, UCM
  • Patching and user support
  • Updated init.ora for XML DB repository with Dispatcher parameter
  • OBIEE implementation 11gR2 database installation, 11.1.1.6.0 BIEE MT installation
  • 32bit RCU (Repository Creation Utility) installation and support
  • Heavy Fusion Apps environment

Confidential

Sr. Oracle Application DBA/Core DBA

Responsibilities:

  • Production maintenance of 11.0.3 and R12 12.1.1. Confidential -Business instances
  • Major modules support Oracle ERP 12i (GL, AP, FA, PO, PA, INV, OM I-Expense) cloned 11.0.3 and R12 Confidential -Business instances as needed using RMAN and hot backup
  • Golden Gate, Data Guard, OEM
  • Old oracle apps with 11.0.3 (8i) database maintenance,
  • Production Support and patch management of 11.0.3 and 12.1.1 oracle Confidential -Business
  • Production Support for 10.2.0.4 Clarify Database and application (CRM)
  • Production Support of 9i Journix Database,
  • Configured XML DB database using xdbconfig.xml file
  • Created daily oracle production apps database clone script to support BI database extraction from Oracle Application database

Confidential

Application DBA/Core DBA

Responsibilities:

  • Lead the upgrade project, ERP database from 11.2.0.1 to 11.2.0.2 for 3.5 T size of database and production support for R12 ASCP, Demantra and Confidential -Business 11.5.10.2 with (GL, AP, FA, PO, PA, INV, OM modules)
  • 11g RAC database with ASM, evaluated with oracle team for SAN to EXADATA migration but company decided not to go with EXADATA due to cost and dual storage maintenance

Confidential

Application DBA/Core DBA

Responsibilities:

  • Technical lead DBA, monitoring offshore DBA team to support 24x7 environment
  • Responsible for leading team and provide weekly task with execution plan if needed, cloned and refreshed instances as needed using RMAN
  • Implemented DR site for EBS database and Application for Production and QA system
  • Recently completed DR testing for all production systems, Data guard, 11g R2 RAC, ASM
  • Implemented RFS transportation for companywide production databases
  • Responsible for patching analysis and scheduling matching company downtime
  • Responsible for change order moving from test, QA, Prod respectively
  • Responsible for technical project management for web method and Demantra upgrade
  • Involve in R12 ongoing upgrade project with major modules (GL, AP, FA, PO, PA, INV, OM, HR, PAY)
  • OBIEE Team interaction and providing support regarding OBIEE and EBS ETL schedule and troubleshoot
  • Managed project for Upgrade web methods database to 11g and application
  • Managed Project for Upgrade Demantra database to 11g and application.
  • Managed Project adding informatica for GL module in Confidential -Business for data archiving to control the db growth which is 100G/yr

Confidential

Project Lead/Sr. Oracle Apps DBA

Responsibilities:

  • Reason for Leaving: DBA services outsourced to overseas data centre after contract completed
  • Team lead for Confidential -Business application upgrade and production support project
  • Production support for most manufacturing and Fin. Modules like (GL, AP, FA, PO, PA, INV, HRMS, PAY, OM), user support for development, patching, cloning
  • Upgrade, added DMZ node for i-Expense, and ASCP, upgraded Discoverer to latest Version
  • 10.2.0.2 database upgraded to 10.2.0.4 for pre-requirement for OS migration and 11i to R12 upgrade
  • Extensively used RMAN for cloning, refreshing and standby db creation
  • Ervin for data modelling

Hire Now