We provide IT Staff Augmentation Services!

Oracle Dba Resume

Sunnyvale, CA

Professional Summary

  • Around 9 years of experience as Oracle DBA, Oracle Apps/e-business DBA & Hyperion admin
  • Strong knowledge in Oracle Apps/e-business Architecture 11i & R12, Oracle 9i & 10g Database Concepts, Backup recovery, Workflow Architecture, Autoconfig, OAM,Concurrent Manager and Ad utilities such as adpatch and adadmin.
  • Strong knowledge in Hyperion 11.1.2.0 architecture, administration, implementation and request flow
  • Strong knowledge in Web logic administration
  • Extensive experience in OracleApps e-business point release upgrades (11.5.8/11.5.9 to 11.5.10.2), R12 upgrade, Database upgrades, 11i Tech stack component upgrades,
  • Extensive experience in SSL Implementations, SSO Integrations, DMZ setups, Discoverer 10g installation and configuration.
  • Implemented Shared tech stack configuration.
  • Performed Single node and Multi-node installation in both 11i and R12.
  • Exposure to Applications Desktop Integrator and Web
  • Exposure on troubleshooting Oracle Apps Components like forms, Apache, Concurrent Manager, Reports Server and Discoverer.
  • Extensive experience in Performance tuning (Both Oracle application and Database).
  • Experience in XML publisher and printer setup.
  • Experience in monitoring Database and Oracle Apps/e-business environments, UNIX shell script and Solaris/Linux basic administration.
  • Performed OBIEE install and Integrated with R12
  • Performed SOA Installation
  • Performed Web logic & Web center implementation for R12 configurator
  • Exposure to RAC Database
  • Good understanding of Oracle support models, very good team player with exposure of team management.
  • Exposure to Oracle application server 10g concepts and architecture.
  • Strong Technical background with excellent problem solving skills.
  • Involved in the full implementation cycle of Oracle application 11i & R12 and Hyperion 11.1.2.1

Education

Bachelor of Engineering (Computer science)

Achievements
  • Involved in releasing an automation tool
  • Received Spot award for FY05 Q4 in Oracle India Pvt Ltd

Professional Training

  • Database fundamentals I and Backup and recovery
  • Oracle Applications 11i architecture and concepts
  • Oracle 11i Application Installation, patching and cloning.
  • AOL foundation Course.
  • Workflow Architecture and Java Mailer
  • Oracle Application server 10g admin I.

Certification

Oracle 10g certified professional
Oracle certified application DBA

Software Proficiencies

Oracle Applications

11.5.9 | 11.5.10 |R12|Hyperion 11.1.2

Fusion Middleware 11g

Web center and Web gate

RDBMS

Oracle 9i ,10g & 11g

Operating Systems

Red Hat Linux Release 3 & 4|HP-UX |Sun Solaris

OracleTools & Utilities

Autoconfig | RapidClone | Opatch | Oracle Enterprise Manager (OEM) | SQL Loader | Export/Import | Oracle Applications Manager (OAM) | AD Utilities |OPMN | Oracle Golden Gate

Application Servers

Oracle 9iAS, Web logic 11g

Professional Experience

Confidential, Sunnyvale, CA Feb 2011 to Till Date
Oracle Apps DBA & Hyperion System administrator

Confidential, provides enterprise storage and data management software and hardware products and services in the United States and internationally. The company provides solutions for storing, managing, protecting, and archiving business data. It offers fabric-attached storage and V-Series storage solutions that support mix of storage area network, network-attached storage, and Internet small computer system interface environments; storage management and application integration software. The company was formerly known as Network Appliance, Inc. and changed its name to NetApp, Inc. in March 2008. NetApp was founded in 1992 and is headquartered in Sunnyvale, California.

Roles and Responsibilities

Oracle application DBA (11i and R12)

  • Installed Oracle application 12.1.1 and upgraded to 12.1.3
  • Performed upgradation from 11.5.10.2 to R12
  • Performed single node & multinode Oracle application installation and cloning
  • Implemented and configured new R12 configurator instance
  • Performed Web logic and Web center implementation for R12 configurator setup
  • Implemented and Configured Oracle Golden gate for real-time replication of data for reporting database
  • Managing user accounts
  • Troubleshooting Patching issues
  • Worked on AD utilities (adpatch, adconfig, adadmin, adctrl etc)
  • Troubleshooting concurrent manager issues
  • Configured Discoverer 10g for Oracle applications
  • Worked on NetApp filers Creating Snapshot, Adding Space,Snapmirror
  • Day-to-day maintenance activities

Hyperion system administrator

  • Involved in installation and configuration of Hyperion 11.1.2
  • Implemented/configured HFM and FDM module for NetApp
  • Good understanding of Hyperion architecture and task flow
  • Regular Hyperion administration activities like user provisioning, System administration
  • Performed Hyperion application refreshes from PROD to NON-PROD
  • Extensive knowledge about Hyperion copy app and LCM tool
  • Performed Hyperion upgrade from 11.1.2.0 to 11.1.2.1
  • Currently involved in Hyperion Essbase and Planning implementation
  • General Troubleshooting activities
  • Installed oracle RDBMS 11.1.0.7 Database for Hyperion application
  • Regular database activities like backups, Tablespace and other DB monitoring
  • Troubleshooting Oracle DB issues
  • Oracle databases performance tuning for Hyperion application
  • Database patching and recovery from hot backup

Fusion Middleware Administration

  • Installed web center 11.1.1.3
  • Installed and configured SOA
  • Configured web gate
  • Creation of Web Logic Domains and Managed Servers
  • Support and maintenance of Fusion Middleware Tec stack 11g
  • Performance Tuning of Managed Servers and domains

Environment

Oracle applications 11.5.10 & R12, Hyperion 11.1.2 Oracle 9i/10g, Red hat Linux 3 & 4.

Confidential, Sunnyvale, CA Oct 2010 to Jan 2011
Oracle Apps DBA

Confidential, provides online properties and services to users; and marketing services to advertisers worldwide. The company also offers media products and solutions comprising online media properties, such as Confidential, Yahoo! Finance, Yahoo! Sports, and Yahoo! Entertainment & Lifestyles that are designed to engage users with the online content and services on the Web; and Yahoo! Shopping, Yahoo! Travel, Yahoo! Real Estate, Yahoo! Personals, Yahoo! Autos, and Yahoo! Small Business that enable users to research specific topics, products, services, or areas of interest by reviewing and exchanging information, obtaining contact details, considering offers from providers of goods and services, or parties with similar interests.Yahoo! Inc. has a strategic alliance with Nokia Corporation. The company was founded in 1994 and is headquartered in Sunnyvale, California.

Roles and Responsibilities as Apps/eBusiness DBA

  • Performed Oracle Applications single node and Multi node installation
  • Managing user accounts
  • Oracle applications patch application including pre-req\'s through adpatch
  • Troubleshooting Patching issues
  • Performed autoconfig stabilization, Workflow stabilization
  • Worked on localizations in Oracle Application
  • Oracle Apps/eBusiness database refreshes (clonings)
  • Cloning from multi node to single node and vice versa
  • Installation of Oracle applications, modifications and updates
  • User account management - creating users, disabling users, responsibility management
  • Managing concurrent managers -ensure system is running smooth, monitoring throughput, watch for long runners
  • Worked on AD utilities
  • Performed adadmin tasks
  • Worked on Implementation of SSL in the Application Level
  • Relinking the Oracle apps programs
  • Resolved the configuration issues raised by development teams
  • Troubleshooting concurrent manager issues
  • Deploying the code using KINTANA
  • Installed on configured HP Database Archiving software (RIM) with Oracle applications 11i
  • Worked on 11.5.10.2 to R12 upgrade
  • Configured PCP for Oracle applications
  • Worked on the BCP setup of Oracle applications
  • Configured Discoverer 10g for Oracle applications
  • Worked on Netapp filers - Creating Snapshot, Adding Space,Snapmirror

Roles and Responsibilities as Oracle DBA

  • Performed Database Installations in various platforms
  • Worked on RAC environment
  • Performed Database upgrade from 10.2.06 to 11g
  • Regular database activities, backups monitoring, issues resolving.
  • Created number of new schemas and maintained privileges.
  • Tuned Oracle databases.
  • Created a number of database instances in different versions on different platforms for development, testing and production.
  • Performed number of schema refreshes from production to test to dev using exp/imp.
  • Installed patchsets and upgraded Oracle (RDBMS).
  • Applied database patches using Opatch utility.
  • Executed number of CCs (Change Controls).
  • Coordinated and interfaced with Oracle support for upgrades and new releases.
  • Worked with Oracle Corporation and opened TARs to resolve number of bugs.
  • Performed number of dev, test and stage clonings from PROD databases.
  • Performed number of tablespace and datafiles recovery and point in time recoveries.
  • Worked on Performance tunning of RAC databases.
  • Managed tablespaces and other database objects.
  • Installed statspack in the database to monitor the database and identify the bottlenecks.
  • Performed application and database tuning.
  • Performed Load test monitoring.
  • Prepared and developed number of shell scripts to manage oracle databases
  • Installed OEM 10g for DB and Application Monitoring
  • Worked on Standby Databases - Monitoring for the standby sync with production DB

Environment

Oracle applications 11.5.10 & R12 , Oracle 9i/10g, Red hat Linux 3 & 4.

Confidential, Florida,USA Aug 2009 to Oct 2010

Client: Confidential, CA
Oracle Apps DBA

The Forest Service was established in 1905 and is an agency of the U.S. Department of Agriculture. The Forest Service manages public lands in national forests and grasslands, which encompass 193 million acres.

Roles and Responsibilities

  • Performed database upgrade from 9.2.0.7 to 10.2.0.4
  • Worked with System Administrators to Migrate from RedHat Linux 3 to RedHat Linux 4
  • Installation of Oracle Apps 11.5.9,11.5.10 and Release 12 on Linux, Solaris and HP UX platforms (Single node and Multi node install)
  • Pre Patch Analysis and application of one off patch, Tech stack patches in Single and Multi Node
  • Involved in troubleshooting patch application procedure and resolving issues encountered, troubleshooting all techstack components like Apache, Discoverer and Forms.
  • Engaged in various sysadmin activities like creating users, responsibilities, assigning responsibilities to users, Defining new concurrent managers and administering concurrent managers.
  • Upgradation of 11.5.10.2 Instance to R12
  • Performed upgradation of Disco 4i to 10g
  • Worked on Implementation of SSL in the Application Level
  • Implementation of SSO on cloned instance
  • Developed standard for directory structures on brand new Solaris boxes.
  • Performed Database Installations in various platforms
  • Regular database activities, backups monitoring, issues resolving.
  • Created number of new schemas and maintained privileges.
  • Tuned Oracle databases.
  • Oracle application database refreshes (cloning)
  • Maintaining Database backup and recovery process through RMAN and manually
  • Re-design backups and Data Recovery solution to take advantage of RMAN
  • Created a number of database instances in different versions on different platforms for development, testing and production.
  • Performed number of schema refreshes from production to test to dev using exp/imp.
  • Installed patchsets and upgraded Oracle (RDBMS).
  • Applied database patches using Opatch utility.
  • Executed number of CCs (Change Controls).
  • Coordinated and interfaced with Oracle support for upgrades and new releases.
  • Worked with Oracle Corporation and opened TARs to resolve number of bugs.
  • Performed number of dev, test and stage clonings from PROD databases.
  • Performed number of tablespace and datafiles recovery and point in time recoveries.
  • Managed tablespaces and other database objects.
  • Installed statspack in the database to monitor the database and identify the bottlenecks.
  • Performed application and database tuning.
  • Performed Load test monitoring.
  • Prepared and developed number of shell scripts to manage oracle databases

Environment
Oracle 9i/10g,11g, Oracle Applications 11i & R12, IBM AIX Redhat Linux 3 & 4.

Confidential, Coimbatore, India Nov 2008 to Aug 2009
Oracle Apps DBA

Roles and Responsibilities as Apps/eBusiness DBA

  • Performed upgradation from 11.5.9 to 11.5.10.2
  • Managing user accounts
  • Oracle applications patch application including pre-req\'s through adpatch
  • Troubleshooting Patching issues
  • Performed autoconfig stabilization, Workflow stabilization
  • Worked on customizations in Oracle Application
  • Oracle Apps/eBusiness database refreshes (clonings)
  • Cloning from multi node to single node and vice versa
  • Installation of Oracle applications, modifications and updates
  • User account management - creating users, disabling users, responsibility management
  • Managing concurrent managers -ensure system is running smooth, monitoring throughput, watch for long runners
  • Worked on AD utilities
  • Performed adadmin tasks
  • Worked on Implementation of SSL in the Application Level
  • Relinking the Oracle apps programs
  • Resolved the configuration issues raised by development teams
  • Troubleshooting concurrent manager issues
  • Performed SOA and BPEL Installation

Roles and Responsibilities as Oracle DBA

  • Developed standard for directory structures on brand new Solaris boxes.
  • Performed Database Installations in various platforms
  • Performed many database upgrades from 9.2.0.4 to 9.2.0.X manually and through dbua
  • Regular database activities, backups monitoring, issues resolving.
  • Created number of new schemas and maintained privileges.
  • Tuned Oracle databases.
  • Created a number of database instances in different versions on different platforms for development, testing and production.
  • Performed number of schema refreshes from production to test to dev using exp/imp.
  • Installed patchsets and upgraded Oracle (RDBMS).
  • Applied database patches using Opatch utility.
  • Executed number of CCs (Change Controls).
  • Coordinated and interfaced with Oracle support for upgrades and new releases.
  • Worked with Oracle Corporation and opened TARs to resolve number of bugs.
  • Performed number of dev, test and stage clonings from PROD databases.
  • Performed number of tablespace and datafiles recovery and point in time recoveries.
  • Managed tablespaces and other database objects.
  • Installed statspack in the database to monitor the database and identify the bottlenecks.
  • Performed application and database tuning.
  • Performed Load test monitoring.
  • Prepared and developed number of shell scripts to manage oracle databases

Environment

Oracle applications 11.5.8/11.5.9/11.5.10, Oracle 9i/10g, Sun solaris, HP-UX, Redhat Linux 3 & 4.

Confidential, Bangalore Jan 2007 to Nov 2008

Oracle Apps DBA

Project 1 (EStudio - UK Based Customers)

Estudio, UK group having number of Application DBA as part of Oracle Consulting UK that involves implementation and maintenance of environments hosted at Oracle Datacenters as well as at customer place. Estudio project deals with implementation of few UK based customers like Environment Agency, Alfred McAlpine, Department of Work And Pensions, Network Rail, Arqiva, Phones4u, Tubelines, Color matrix, Barclays.

Regular Activities and Responsibilities

  • Installation of Oracle Apps 11.5.9,11.5.10 and Release 12 on Linux, Solaris and HP UX platforms (Single node and Multi node install)
  • Pre Patch Analysis and application of one off patch, Tech stack patches in Single and Multi Node
  • Involved in troubleshooting patch application procedure and resolving issues encountered, troubleshooting all techstack components like Apache, Discoverer, Forms.
  • Engaged in various sysadmin activities like creating users, responsibilities, assigning responsibilities to users, Defining new concurrent managers and administering concurrent managers.
  • Performed XML Publisher upgrade and printer setup
  • Performed Web ADI Configuration.
  • Troubleshooting Concurrent manager issues and other technical issues
  • Involved in Application of RDBMS patches and patch set to database.
  • Performed DB Upgrades from 9.2.0 to 9.2.0.x versions and 9.X to 10g.
  • Involved in full Database export and import
  • Performed Application Clones (11i & R12) on single node environment.
  • Workflow mailer setup for both 11i and R12 instance
  • Monitoring the instances with respect to the technical issues related to database and apps
  • Performed custom application setup
  • Performed PCP setup, SSO Integration,Addition on MT, SSL configuration
  • Performed Oracle Application upgrade from 11.5.x to 11.5.10 and 11.5.10.2 to R12 (Single Node)
  • Installation/Licensing of Oracle Apps modules
  • Configuration of the instance using Autoconfig
  • Worked on Discoverer 10g installation and configuration Printer setup
  • Involved in NLS setup
  • Performed Complete Technology stack upgrades like Developer patchset, JDK upgrade, Jinitiator upgrade etc
  • Other AD utilities like adadmin, adsplice, adconfig, adident etc
  • Engaged in various troubleshooting activities in day to day maintenance
  • Invloved in 10g Application Server installation, configuration and troubleshooting
  • Worked on Third Party installs like Python and PHP etc
  • Exposure to tools like Kintana, Agile Application and Oracle Demantra.
  • Worked on BIEE install and configuration
  • Involved in Hyperion Installation

Environment

Oracle applications 11.5.8/11.5.9/11.5.10 & R12, Oracle 9i/10g,Sun solaris, HP-UX, Redhat Linux 3 & 4.

Confidential, India Jun 2004 to Jan 2007
Oracle Apps DBA

Worked in different Queues of Oracle OnDemand - Change Management, Release Management and Quality and Process engineering team .ON DEMAND is the Oracle Group that invloves implementation and maintenance of E-Business suite environments hosted at Oracle Datacentres as well as at customer place, Providing support to multiple test, development and production environments in 24X7 basis.

The clients served has multiple and different sorts of environments. It ranges from Twin-RAC 4 PCP nodes of Customers like Clopay Corporation, Hanover or Tropicana. It has also shared Tech Stack environments of clients like Enviornment Agency. Also customers of huge architecture like GE, Genworth, Pepsico, Agilent, American Airlines or Quantas Airways. The total clients are more than 500 and different Customers have different architectures according to their needs.

Project (Oracle OnDemand - Periodic Maintenance Team)

Regular Activities and Responsibilities

  • Involved in single node and multi node installation of Oracle E-Business suite 11i
  • Performed Shared Tech stack configuration
  • Performed Oracle Database 9i installation on linux
  • Rac Installation on linux
  • Pre and post patch Analysis and application of one off patch, Tech stack patches in Single and Multi Node
  • Application of RDBMS patches and patch set to database
  • Performed DB Upgrades from 9.2.0 to 9.2.0.x versions
  • Performed Oracle Applications point release upgrades (11.5.9 to 11.5.10) upgrades
  • Performed Complete Technology stack upgrades like Developer patchset, JDK upgrade, Jinitiator upgrade etc
  • Involved in NLS setup
  • Performed PCP setup, SSO Integration, DMZ configuration, Addition on MT, SSL configuration
  • Performed custom application setup
  • Performed Autoconfig Stabilization in Custom environment.
  • Performed product splicing and Installed additional languages in Application 11i
  • Performed Application Clones on single node and multi node environment in both 11i
  • Involved in Autoconfig Stabilization in Single and Multi Node Environments
  • Tuned Concurrent Managers and defined work shifts, specialization rules & incompatibilities
  • Engaged in various sysadmin activities like creating users, responsibilities, assigning responsibilities to users and managing concurrent managers
  • Troubleshooting patch application procedure and resolving issues encountered during patch applicatio.
  • Invloved in 10g Application Server installation, configuration and troubleshooting
  • Worked on Discoverer upgrade from 4i to 10g
  • Worked on Discoverer 10g installation and configuration
  • Maintaining the web application in Oracle Application Server (10giAS)
  • DB Backup and verification of the same
  • RMAN setup and configuration
  • Performance Monitoring and Tuning whenever necessary
  • Providing 24x7 apps dba support during the implementation phase
  • Upgrade Planner, Shift Lead responsibilities, Handled first level of escalations, Single point of contact for the teams during Shifts
  • Worked in PRODUCTION Instance, Handled Severity 1 SRs and resolved critical issues
  • Engaged in various troubleshooting activities in day to day maintenance
  • Supported UAT Testing
  • Mentored junior engineers and shared technical skills and knowledge

Environment

Oracle applications 11.5.8/11.5.9/11.5.10, Oracle 9i, Sun solaris, HP-UX, Redhat Linux 3 & 4.

Hire Now