SUMMARY

• Extensive Experience as Oracle Application DBA, Oracle Database Administrator & Fusion Middleware Administrator
• In - depth knowledge in Implementations/Installations, Configurations, Maintenance and troubleshooting of database Oracle 9i,10g,11g and Applications 11i and R12
• Extensively worked on Oracle 11i and R12 - Database migrations, Upgrade of Databases and Applications, Troubleshooting and Maintenance of database and Applications, advanced cloning methods and database refresh
• Good experience in implementing advance configurations ie. RAC, PCP, DMZ, Shared Appltop, SSO/OAM, OID, Webgate, AccessGate, Shared application Tier, Discoverer, Workflow, etc
• Sound understanding of Oracle Database and Applications to identify the performance bottlenecks and resolving the performance issues by tuning all the layers of Oracle Applications and Database
• Experience in implementing Weblogic, Fusion Middleware components i.e Webcenter, SOA, OIM and OAM etc
• Experience in Implementation and configuration of Golden Gate
• Weblogic 11g Administration, Installation, Clustering and Advanced Configurations.
• Implementation Support of Oracle Applications (patching, troubleshooting, Concurrent Managers Management).
• Performed upgrade of Oracle Application to 11.5.10.2 & R12 (12.1.3 and 12.2.4) from prior version
• Performed upgrade of Database to 10g and 11g from prior version
• Implementation experience of 10G Oracle Single Sign On (SSO/OID) and 11g OAM for Oracle Applications R12
• Experience in Installation, configuration, administration & integration of Oracle Identity Management Suite 11g components (OID, OAM & OIM) for implementing security Platform for Oracle EBS Suite.
• Solid understanding of Authentication and Authorization concepts for OAM11g.
• Extensive knowledge of enterprise web applications and their underlying technologies, including web browsers, application servers, reverse proxies, HTTP header and cookies, session management.
• Experienced with two factor authentication using token
• Extensive knowledge in SSO, Federated SSO
• Experience in setting up OIM, Single Sign On (SSO) and OAM across multiple applications
• Experience in Director services - LDAP
• Oracle Application Cloning using Rapid clone. Multi node to single node, Multi node to Multi node
• Administering and maintaining Oracle Apps 11i & R12 instances
• Experience in Application Patching using AD Utilities and strong analytical and problem solving skills in Patch Management.
• Migrated 9i, 10g & 11g databases from various OS to Linux
• Applications sysadmin tasks like creating and managing users and their responsibilities
• Applied maintenance packs, family packs, mini packs and database patches with adpatch, Opatch utilities.
• Good implementation knowledge of Shared Appl Top and Shared Application tier
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, J-initiator and database)
• Oracle Database backups using RMAN and Import/Export
• Experience installing CRS and configuring the Oracle Real Application Clusters (RAC)
• Configured Disaster Recovery (DR) Setup using physical Standby
• Upgrading Applications to R12 - 12.1.1, 12.1.2 & 12.13 from 11i
• Upgrading Applications to R12 - 12.2.0,12.2.4 from 11i and R12 (12.1) Versions
• Upgrading Applications to R12 - 12.2.5 from 11.5.10.2
• Sound knowledge in Workflow mailer and Discoverer configurations
• Extensive experience in Shell Scripting
• Exposure on PeopleSoft Administration and Python scripting
• Experience in Implementing Dataguard Broker

TECHNICAL SKILLS

Oracle Applications: 11.5.9, 11.5.10.2, 12.1.3, 12.2.5

Oracle Middleware: Weblogic, Webcenter, SSO, OID, OAM

RDBMS: ORACLE 9i, 10g, 11g and 12c

Tools: Oracle Enterprise Manager, OAM, Toad, Kintana

Utilities: RMAN, Export/Import, Statspack, tkprof

Operating System: Red Hat/OEL Linux 3/4/5 / AS 4, Solaris 5.9, AIX, HP-UX

Scripting: Shell, Python

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Oracle Applications Database Administrator

Environment: Oracle Applications 12.2.5, 12.2.4, 11.5.10.2; Oracle 12.1.0.2, 11.2.0.4, 10.2.0.4; Linux, HP-UX

Responsibilities:

• Upgrade Oracle applications from 11.5.10.2 to 12.2.5
• Upgrade Oracle database from 10.2.0.4 to 11.2.0.4
• Platform migration of Oracle applications from HP-UX to Linux
• Platform migration of Oracle database from HP-UX to Linux
• Bringing up 11.5.10.2 system to the minimum baseline for upgrading to 12.2
• Enable multi-org in Oracle applications
• Performed Oracle application tablespace migration
• Enabled TDE for oracle database
• Cloning of non-prod instances
• Administering production and non-prod instances
• DR setup for oracle applications for business continuity
• Applying CPU patches
• Performance tuning of database and applications
• Installed & configured OAM 11GR2 PS3
• Implemented / Integrated OAM with EBS 12.2.5 and Federated with SAML2.0.
• Design, implement and test OAM11g policies and configurations.
• On boarding of applications in OAM11GR2 PS3
• Debug and troubleshoot OAM11g infrastructure and application issues and provide technical help.
• Designing and Implementing custom solutions for Web Security.
• Interface with and advise development teams that are using OAM for AuthN and AuthZ purposes.

Confidential, Sunnyvale, CA

Oracle Applications DBA

Environment: Oracle Applications 12.2.4, 12.1.3; Oracle 12.1.0.2, 11.2.0.4; Linux

Responsibilities:

• Supporting 40 node Core Production instance (R12+Webcenter), two other integrated prod instances, and around 50 other development/test instances and other integrated environments
• Upgraded applications from 12.1.3 to 12.2.4
• Worked on Datacenter migration of Production instances
• RAC, Non-RAC DB upgrades from 11202 to 11204 on all R12 and Webcenter databases
• Implementation/configuration of Golden Gate
• Installation of Oracle Application server infrastructure 10.1.2.0.2
• Application of R12 CPU patches such as DB PSU patches, interoperability patches, and Ebiz one off patches for every quarter release
• Webcenter/portal and Weblogic administration tasks
• Implemented / Integrated OAM with Oracle EBS.
• Design, implement and test OAM policies and configurations.
• Debug and troubleshoot OAM infrastructure and application issues
• JDK & JRE upgrade
• Cloning of RAC to RAC, RAC to NON-RAC, and NON-RAC to NON-RAC R12 instances & Webcenter instances, and troubleshooting cloning issues such as Confidential Filers QSM sync, Flexclone volumes creation, db recovery, webcenter refresh issues, etc
• Monitoring Daily replica of Production instance and troubleshooting the issues
• Monitoring Production volumes DR sync, which happens for every 2 hours
• Administering the databases through OEM
• Involved in performance tuning as and when required
• Preparing DB reports/OC4J/Weblogic reports of Production system during performance issues, and of Pre-prod instances while performing the tests on it
• Kintana User administration, configuring environment tasks such as updating passwords and recreating db links which are required for the integration to work properly between R12 and Kintana, Code deployment and troubleshooting package migration issues
• WSDL deployment in R12 which is required for the R12 to interact with SOA, Webcenter and other integrated environments, and troubleshooting issues
• Running AWR, ASH and ADDM reports and analyzing the database performance, and sql tuning
• SOX Implementation on DB users for enhanced security
• Coordinating with SOA, SFDC, IDM, other ERP teams, Dev and functional teams, on day to day operations
• Unix administration tasks
• Troubleshooting SSO/OID login issues

Confidential, Sunnyvale, CA., US

Oracle Applications DBA

Environment: - Oracle Applications 11.5.9, 11.5.10.2; Oracle 10.2.0.4,9.2.0.7; Sun Solaris, Linux

Responsibilities:

• Supporting 16 Core ERP instances, and other integrated ERP instances (7) & Satellite application environments
• Automated the entire Manual Refresh Process - Prepared a generic script which can be scheduled as a cron job to refresh all non-prod instances. It includes Bringing down services, transfer data from source to target using snapmirror update, Creating flexclone volumes, Configuring and Bringing up the services on DB and Middle Tiers, and Post Refresh steps
• Upgrading oracle database from 9.2.0.7 to 10.2.0.4
• Implemented shared appltop
• Supporting Aceva application upgrade, which is deployed on oracle 9.2.0.7 database, and integrated with ERP
• Implemented DR setup for Sabrix application and database, an integrated environment with ERP
• Installing OEM agents software on all target servers
• Prepared wrapper scripts to bounce the services of various applications on all nodes of the instance while performing Production migrations to reduce the downtime
• Creating/Deleting/verifying the snapshots of Confidential Filers’ Qtree volumes as and when required
• Performing Solaris administration tasks such as creating/modifying OS user accounts/passwords, mounting/unmounitng filer volumes, modifying vfstab entries
• Monitoring/scheduling the business critical daily replicas of Production instance, troubleshooting the refresh scripts and performing the recovery as and when required
• Monitoring/Managing SSO, KINTANA and other servers along with the ERP servers for performance issues
• Involved in DST Patching, OATM and Jdk upgrade
• Working on the performance issues and tuning the database
• Cloning of other ERP instances and the satellite applications from Prod to Non-Prod instances
• Identified and updated the Host executable concurrent programs definitions to avoid displaying the APPS password on Unix server while the program is running
• Monitoring OEM alerts, TIVOLI url monitoring alerts, and Custom scripts for Hot/Cold Backups failures, High CPU consumption, Blocking Locks, Tablespace Usage alerts and working on them accordingly
• Applying various applications patches to the instance
• Planning, Scheduling Backups
• Monitoring and Maintaining User Activities
• Assigning privileges and roles for the users
• Creating DB links, rebuilding indexes and adding and resizing the data files
• Provisioning OID resource for the user accounts in SSO server
• Working on SSO login issues
• Performed tablespace level re-org
• Configuring Printers and fixing other printer related issues
• KINTANA administration tasks such as user creations, package migrations, verifying Kintana log files and troubleshooting package migration issues
• PeopleSoft Administration tasks

Confidential

Oracle Applications DBA

Environment: - Oracle Applications 12.1.3,11.5.10.2,11.5.9; Oracle 11g, 10g, 9i; Sun Solaris, Linux, AIX, HP-UX

Responsibilities:

• Cloning of Rac to Rac/Non-rac database and applications
• DB upgrades from 11202 to 11204 and from 9.2.0.5 to 11.2.0.3
• Performed oracle applications upgrade from 11.5.10.2 to R12.1.3
• Database and application patching
• Monitoring and Maintaining User Activities
• Assigning privileges and roles for the users
• Creating DB links, rebuilding indexes
• Adding and resizing the data files
• Monitoring and troubleshooting performance issues
• Performance tuning of database and applications

Confidential

Oracle Applications DBA

Environment: Oracle Applications 11.5.10.2, 11.5.9; Oracle 9.2.0.7, 9.2.0.8; Red Hat ES release 4

Responsibilities:

• Performed PROD Database upgrade from 9.2.0.7 to 9.2.0.8
• Performed PROD Oracle Applications upgrade from 11.5.9 to 11.5.10.2
• Involved in 4 rounds of trial upgradation of Oracle DB and 11i Oracle Applications
• Performed Oracle Applications Patching on R12 Instances
• Performed Oracle Applications Cloning on R12 Instances using Rapid Clone.
• Performed System Administration Tasks on R12 Instances
• Troubleshooting issues faced during upgradation and patching