We provide IT Staff Augmentation Services!

Senior Oracle Application Dba Resume

SUMMARY:

  • Around 13 Years of overall IT experience in Oracle database administration.
  • 11.6 Years of experience in Oracle EBS (11i and R12).
  • Strong experience in Installation and Support of Oracle Applications 11i (11.5.10.2) and R12.1.x / R12.2.x
  • Experience in ADOP issue, 12.2.X Online Patching Issue, EBS 12.2 Upgrade.
  • Strong experience with Oracle 9i database, Oracle 10g, 11g and 12C databases.
  • Hands On experience on Real Application Clusters (10g RAC), 11g RAC and 12C RAC.
  • Migrating the OCRFile and VOTFile to New quorum disk in 12C RAC.
  • Datacenter Migration between Colorado and Utah for all oracle databases and other oracle satellite systems.
  • Implemented Oracle Fusion Middleware products such as weblogic, SOA, OSB, ADF, BAM to setup multi - node High Availability clustered environments.
  • Oracle Fusion Middleware 11G, Oracle WebLogic Server 12c, SOA Suite, Oracle ADF and WebLogic experience on domain creation, clustering, node management and application deployment.
  • Implemented High Availability DR setup for Fusion Middleware Environments for fail-over and fall back mechanism between Primary and Standby.
  • Experience Confidential supporting Oracle installations which require real time data replication using GoldenGate Transaction Data Management Tool and also worked on replication solutions to facilitate data flow between the environments.
  • Database core admin and Performance issues, NET issues, NLS issues (Character Migration), Memory related issue, Internals issues (Ora-00600 & Ora-07445), Security issues, Utilities issues (exp, imp, Data pump) and issues related to Oracle Installation/migration/ upgradation.
  • Support and maintain the high availability solutions (DR) for business critical Databases.
  • Design for CPU, memory and storage capacity requirements of new database servers.
  • Database growth & capacity management for shared environment.
  • Knowledge on virtualization and containerization solutions using docker.
  • Knowledge in creating custom Docker Images using Dockerfile.
  • Knowledge in development and configuration experience with software provisioning tools like Chef.
  • Knowledge in writing cookbooks, recipes in chef for configuring infrastructure.
  • Cloning database using BCV snaps and HotBackups.
  • Oracle Production Database expertise on Oracle 9.x, 10g, 11g environments. Proficient in handling large databases with install, upgrade, implementation and performance tuning.
  • Analyzed Statspack/AWR Reports to identify on-going/proactive issues and analyzed the reports for Oracle wait events, time consuming SQL queries.
  • Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  • Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies.
  • Automated several routine tasks - Automating the cloning for both the DB and Application via shell scripting and configuring in scheduling tool SMA. Automating hot backup and DB Monitoring scripts.
  • Worked on EDMS tool for Solix Archiving.
  • Good Knowledge on Incidents/Request and CHANGE MANAGEMENT process.
  • Manage changes to the environment using best practices Change Management workflow. Review and maintain patch database and ensure that applicable patches are applied or submitted through the Change Management system.
  • Monitoring Setup using OEM 12C, cronjob, AppDynamics, Sitescope.
  • Experience in trouble shooting failed mission critical production systems under extreme pressure conditions and time constraints.
  • An excellent team player, have very good relationships with the various Application teams.

PRIMARY SKILLS:

Oracle EBS (11i, R12, 12.2.4), Oracle DBA, Fusion Middleware Admin

TECHNICAL SKILLS:

Environment: Sun Solaris, LINUX AS 3.0/4.0/5.0/6.0 , Ubuntu

ERP: Oracle Applications 11i, R12

RDBMS/DATABASES: Oracle 9i/10G/11G/12C

APPLICATION SERVER: Oracle 9iAS, 10G AS, Weblogic 10.x, Weblogic 12c

Scheduling Tools: Cronjob (UNIX)

Virtualisation: Docker

Automation/Build Tools: Jenkins, Chef

Version Control Systems: GIT

Oracle Utilities: Sql*Loader, Export, Import, Putty

11i Utilities: FNDLOAD, WFLOAD, AD Utilities

Tools: OEM, SQL*Loader, Export, Import, TKPROFExplain Plan, OAM, TOAD, OEM 12C, AppDynamics, SMA OpCon/xps

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Application DBA

Responsibilities:

  • Administration of Single Global Oracle ERP System. Confidential has Oracle ERP implemented in 100+countries.
  • Managing 20+ production database environments with size from 20+Gb to 30+TB.
  • Providing support for Production and Non-Production Environments - Oracle Apps R12, Oracle Application Server, Vertex, Oracle SOA and Solix.
  • Oracle Apps Patching and Oracle Apps Cloning.
  • Complete knowledge on various adop phases like prepare, apply, finalize, cutover, cleanup and fs clone.
  • Installation, Administration and maintenance of OFM 11g (Oracle Fusion Middleware) in cluster and Standalone environments.
  • Oracle Weblogic Setup, experience on domain creation, clustering, node management and application deployment & Management with Solutions/Products like SOA, ADF, BAM.
  • Configured virtual host routing using OHS with different Load Balancer setup across multi nodes.
  • Troubleshooting Weblogic issues in production environments and provided 24x7 production support.
  • Capacity and growth planning of SOA dehydration store in Production environment.
  • Performance tuned weblogic, SOA, OSB, OHS, EBiz to meet business requirements in terms of service call rates, response time, capacity and load planning.
  • Experience in Oracle EBS (R12.2.4) integration with OID/OAM 11g.
  • Applying one-off patches on RAC clusterware and RDBMS Oracle Home.
  • Reorganization of tables and indexes for removing fragmentation and gain performance.
  • Moving tables/indexes for performance.
  • Monitoring and Performance tuning of the database with OEM, BAM, AWR & ASH reports and using profilers like tkprof.
  • Involved in the point Upgrade of RDBMS Oracle Home and RAC clusterware from 10.2.0.4 to 10.2.0.5.
  • Conversion of the Database characterset from WE8MSWIN1252 to AL32UTF8 in 11g databases.
  • Regular Archiving of schemas like AR, INV and ONT from EBS Production database to Solix Production database From Solix EDMS tool.
  • Installation, configuration of Oracle RDBMS 11g and 12C software on single nodes and clusters (RAC).
  • Extensive experience in installation, configuration Oracle Clusterware CRS 11g.
  • Experienced in GoldenGate Install, Configuration, Maintenance, configure error handling for restart, production support and status reporting in GG.
  • Cloning database using BCV snaps and HotBackups.
  • Patch management: Patch application (one offs, Mini Packs, Family Packs, Consolidated Updates, Technology Stack Updates, CPU patches, Translation Patches, PSU patches) and trouble shooting.
  • Thorough knowledge in AD utilities like adpatch, adadmin, adctrl, adconfig, adaimgr, adcfgclone etc.
  • Automated several routine tasks - Automating hot backup, Monitoring scripts - tablespace alerts, File system usage, validating backup and alerting DBAs in case of backup failures.
  • UndoTablespace Management - Switching of Undo tablespaces due to expired undo tablespace.
  • Installation of CRS and Database 11.2.0.2 and run Fusion Metadata Repository Creation Utility.
  • Installation of Oracle Http Server (10.3.5), Weblogic server (10.3.5) and Oracle Fusion Middleware for SOA.
  • Creation of Domain for Admin Server (WSM, EM and JRF) and extend domain to include SOA and BAM.
  • Installation of Oracle Service Bus and extend domain to include OSB.
  • Installation of ADF and configuration of JDBC connection pools, datasources and creating JMS queues.
  • JDBC Connection Pool and Multipool configuration with Oracle, MySql, DB2 and SqlServer etc.
  • Monitoring thread usage, connection pool usage, CPU usage, Memory usage.

Confidential

Oracle DBA

Responsibilities:

  • Installation of 11g Grid Infrastructure and Database in x86 64 servers.
  • Applying the E-Business Suite Interoperability patches for 11g.
  • Upgrade the E-Business Suite database from 10.2.0.5 to 11.2.0.4.
  • Expanding the system from two node RAC to three node RAC.

Confidential

Oracle DBA

Responsibilities:

  • Validated OS, Kernel and Packages requirements.
  • Apply Database Interoperability Patches and Run TUMS utility.
  • LAD Localization Pre-Upgrade Patches, R12 Stage Preparation.
  • Run Rapid Install to upgrade to oracle EBS 12.2.0
  • Apply 12.2.0 upgrade driver (Use 128 workers and batchzsize=100000)
  • Run Rapid Install to configure Release 12.2.4 E-Business Suite instance
  • Upgrade to 12.2.4 and Apply the Online Patching Enablement patch: 13543062:R12.AD.C.
  • Upgrade CRS from 11.2.0.4 to 12.1.0.2
  • Oracle 12c (12.1.0.2) database binaries installation.
  • Apply Latest PSU Patches and Additional Patches for DB and Grid.
  • Pre-Upgrade and Verification Steps.
  • Database Upgrade from 11g (11.2.0.4) to 12c (12.1.0.2).
  • Post Upgrade Steps.
  • Leading, Managing and Driving the build of Oracle EBS (12.2.4) and other Oracle infrastructure like Fusion Middleware (12C), Vertex, Solix Subset, BI & ODI after Production Go-Live.
  • Collaborate with various stakeholders like ServerOps team, Storage team, Network team and
  • Environment Management team for the project requirements to minimize the occurrence of the issues and to enhance the performance of the application and to keep the database highly available.

Confidential

Oracle Application DBA

Responsibilities:

  • Handling administration of 24*7 Production and Dev/test environment.
  • Expertise in handling the cases raised by the clients through Peoplesoft CRM Tool.
  • Patch Analysis for the patches including CPU patches, RUP, minipacks, oneoff and RDBMS patches.
  • Applied India Localization, RDBMS, Applications patches, using Opatch/adpatch utility.
  • Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purpose.
  • Performed clone from Prod backup to Test and DEV environment instances for all clients. Cloning includes from multinode-multinode, multi-single, RAC to Non-Rac and RAC to RAC environments.
  • Upgraded DB from 10.2.0.2 to 10.2.0.4 for client L&L Products.
  • Setting Profile Options (site level, User level).
  • Helping to functional and development team on perform action plan regarding SR (tar), provided file version and migrated file from dev/test to Prod.
  • Troubleshooting issue with Apache, Concurrent services, WF Mailer and apps login etc.

Confidential

Oracle Apps DBA

Responsibilities:

  • Provide technical support to 1000+ users by resolving any problems faced with Oracle ERP application.
  • Analyzing the tickets and communicating with Business users for understanding the requirements.
  • Registered Executables,created Concurrent Programs and Request Groups.
  • Created new custom concurrent managers, Purged concurrent requests table.
  • Applying RDBMS, Applications patches, using Opatch/adpatch utility.
  • Application of Product Minipacks, Family Pack, Standalone Patches and India Localizations patches.
  • Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purpose.
  • Performed Oracle application Database Cloning through RMAN backup.
  • Troubleshoot invalid and unusable objects, Gather schema statistics.

Confidential

Team Member

Platform: RHEL 4 (update 6)

Responsibilities:

  • Installation of Oracle applications (11.5.10.2) on RHEL 4.
  • Custom top Application Registration.
  • Applied Latest India Localization Patches.
  • Applied developer6i patchset 18 and RUP6.
  • Upgraded the 9i database to 10.2.0.3.

Confidential

Engineer Technical Support

Responsibilities:

  • Reviewing and analyzing the bugs imported to the Bug Toolkit from DDTS.
  • Interacting with the TAC Engineers and developers regarding the customers bugs and RNE issues.
  • Promptly handling Customer bugs and even escalating the cases to the DE Manager.
  • Reviewing and Writing workaround section of the RNE wherever required.

Hire Now