SUMMARY:

• Over 11+ years of experience in Oracle Application DBA and Oracle Core DBA.
• Experience in upgrade, migration, implementation, cloning, patching and support projects.
• Exceptional understanding of customer business process, skilled with the above - mentioned areas of expertise, which enables to provide cost effective and quality solutions and directions.
• Working experience on Confidential and Exalogic environments.
• Good experience in Standby database configuration and maintenance.

TECHNICAL SKILLS:

Hardware: Intel Xeon, Sun 440, IBM Pseries 5, Intel X86, AMD Based Servers.

Red Hat Linux, Solaris, HP: UX

Oracle Application DBA: R12, 11i

Databases: Oracle 11g, 10g, 9i

Programming Languages: SQL, C/C++, COBAL

Scripting Languages: Unix Shell scripting

Other Utilities: Toad, XManager, putty, SSH, VNC

EXPERTISE AREA:

• Installing Oracle Golden Gate on the Linux OS.
• Configuring the Manager, Extract, data pump and Replicat processes.
• Creating, editing and managing the parameter files for the golden gate processes.
• Performed the DML replication and DDL replication.
• Performed the Data filtration using the Where and Filter Clause and Data transformation using COLMAP
• Setup Bidirectional replication and handle the conflict issue.
• Configured the security feature using the trail file encryption and creating the USERIDALIAS.
• Troubleshooting the issue using the report files and ggserr.log file.
• Using the Logdump utility for reading the trail file for the troubleshooting purpose.

EXPERIENCE SUMMARY:

Confidential

Team Lead, Barberton, Ohio

Responsibilities:

• Oracle EBS R12.2(12.2.4) database migration from VMWare server to Oracle Confidential server.
• Cloning the application tier to the new Oracle PCA server.
• Created the physical standby from the VMWare database to Confidential server and switchover the standby to primary database during the Go-live phase.
• Converted the single node database to 4 node RAC database.
• Configured the database (12.1.0.2) and application (12.2.4) and enabled the autoconfig.
• Created the active physical standby database for the production database on the Confidential .
• Cloning the test and dev EBS R12.2 environment on the dual filesystem.
• Testing the ADOP patching cycle.
• Performed the application patching using the ADOP utility and fix the issue during the patching.
• Troubleshoot and worked with Oracle support on 24x7 severity 1 SRs for resolving the issue during the migration.

Confidential

Oracle DBA support, Charlotte, North Carolina

Responsibilities:

• Database migration from Linux server to Oracle Confidential server.
• Database management on ASM instance with Confidential server.
• Database upgrade from 11g (11.2.0.3) to 12c (12.1.0.2) and configuring Oracle application R12 (12.1.3) on the existing Linux server.
• Disaster recovery(DR) build and configuration.
• Data guard broker configuration for monitoring.
• Patching Oracle EBS application.
• Creating the container database (CDB) using DBCA.
• Monitoring the health check of the database and application and tuning the database for better performance.
• Basic knowledge on Golden gate for data replication.
• User JIRA/Service tickets handling for the production deployments.
• Working effectively with business users and technical team to resolve issues.

Confidential

Team Member, Charlotte, North Carolina

Responsibilities:

• Handling user’s tickets related to database, application and user performance issues.
• Cloning Oracle application and databases R12 and 11i environment.
• Patching application and performed RPC4 patching.
• Database upgrade from 11.2.0.3 to 11.2.0.4.
• Monitoring and Supporting OBIEE environment.
• Configuration printer in CUPS and EBS environment.
• Handling P1 and P2 tickets during Oncall support.
• Vertex and Cognos administration task.
• Database migration from X3 to X4 Confidential servers.
• Creating Jira story and completing for the project task tracking and planning.
• OBIEE,Vertex,Cognos administration
• Oracle Transport Management Administration activities.
• Configuring and maintaining data guard using physical standby database.
• Good Working experience in Confidential and Exalogic hardwares.

Confidential

Team Member

Responsibilities:

• Implementation of R12 12.1.3 EBS with 2 node RAC.
• Configuring and Administering Oracle 10g/11g Automatic Storage Management (ASM).
• Configuring External Web tier in E-Business Suite in demilitarized zone (DMZ).
• Installed the CPU patches and upgraded the JDK and JRE from 1.6.0 10 to 1.7.0 45.
• Cloning the R12/11i instances using the RMAN backups.
• Troubleshooting and resolving the performance issue in R12 and 11i environments.
• Monitoring database activities (Database status, space consumption, long transaction, server top sessions) using OEM and scripts.
• Clone database using RMAN Active Database feature.
• Performed the RMAN backup - Full and Incremental Backups and Automated the RMAN backup using shell scripting.
• Resolving block corruption issues during RMAN backup.
• Works with the end-users on the incidents (tickets).
• Working on the tablespace/datafile/temp space related issues.
• Applying the oracle EBS application patches based on the SR and users request.
• Developed Unix shell scripts for monitoring database.
• Converted non-autoconfig database tier to Autoconfig.
• Installed and configured oracle software and database tools.
• Working with Oracle support for troubleshooting the issues and resolving it.
• Working on the 24/7 production on-call support.

Confidential

Team Member

Responsibilities:

• Cloning database and application on the new hosts (new setup).
• Checking the storage for refresh on the target system and raising case with system administrator for the storage.
• Setting up cronjob for the refresh activity. (recovery cronjob)
• Refreshing databases and oracle applications on different file system and OS.
• Taking pre-refresh backups of the configuration files and taking logical backup of the tables.
• Refreshing the target system from the hot backup or from the Data Guard. Generating the dd script for the copy.
• Recovering database by applying the archives if the copy is from the hot backup.
• Removing the production database links from the target.
• Setting up the RAC environment. Converting Non-RAC into RAC environment.
• Configuring parallel concurrent processing (PCP).
• Completing the cloning post steps and doing the complete sanity check before releasing the target instance.
• Handling user’s issues/requests and troubleshooting.

Confidential

Team Member

Responsibilities:

• Refreshing databases on different file system and OS.
• Refreshing the target system from the hot backup or from the Data Guard.
• Setting up the RAC environment. Converting Non-RAC into RAC environment.
• Resolving the issue during cloning. Completing the post steps of cloning.
• Doing the first level sanity for the target system.
• Troubleshooting and resolving the user’s issues.

Confidential

Team Member

Responsibilities:

• Applied Patch set 9.2.0.7 for 9.2.0.3 database in Oracle Application 11i (11.5.9)
• Upgrading the Oracle 9i (9.2.0.3) database to 9.2.0.7 patch set.
• Upgrade Database from 9.2.0.7 to 10.2.0.3 in Oracle Application 11i (11.5.9).
• Creating listener using the Oracle Net Configuration Assistant.
• Upgrade the Database Using the Database Upgrade Assistant (DBUA).
• Modifying the Database Initialization Parameters for Oracle Applications Release 11i.
• Generating and Applying AutoConfig Configuration files.
• Gather statistics for SYS schema and compiling invalid objects.
• Applied the latest AD.I minipack.
• Applied Oracle E-Business Suite 11.5.9 Consolidated Update 2(CU2) patch.
• Applied Developer 6i Patch set.
• Preparing for the upgrade from 11.5.9 to 12.1.1
• Applied the TUMS patch and generated the TUMS report.
• Applied Technology Family Pack ATG PF.H.
• Applied Oracle Applications Technology ATG PF.H Rollup 6 (RUP6) patch.
• Generate message files, Compile APPS schema, Compile flexfield data, Compile menu information through adadmin utility.
• Splicing of Oracle XML Publisher through adsplice utility.
• Running AD preparation scripts (adgncons.sql, adcrtbsp.sql)
• Disable custom triggers, constraints, and indexes.
• Applied AD 12.1.1 upgrade driver.
• Running the American English upgrade patch driver.
• Backup the database and application as per the recommendation.

Confidential

Team Member

Responsibilities:

• Applied TUMS patch and generated the TUMS report
• Installing Maintenance wizard
• Generating authorizes keys.
• Creating oinstall & dba groups and creating oracle user.
• Install Oracle database 10.2.0.1 software.
• Install standalone Oracle 10g iAS Oracle home for Maintenance wizard.
• Create database using dbca.
• Create listener and tnsnames files through netca.
• Create tablespace for maintenance wizard schema objects.
• Installing Maintenance wizard by running setup.sh script.
• Install Oracle application R12 Technology stack.
• Only the database RDBMS technology stack and Application Technology stack are installed.
• Upgrade Steps
• Knowing the Patchset level of the target Application system by running patchsets.sh script
• Convert to Multi-org through adadmin.
• Applied the patches 11i.HR PF.I, 11i.AD.I.6
• Applied interoperability Developer6i patchset 19(6.0.8.28)
• Generating JAR files through adadmin
• Relink application programs through adadmin
• Applied TXK Autoconfig and Templates rollup patch S
• Applied ATG PF.H Rollup 6 patch.

Confidential

Team Member

Responsibilities:

• Implementation, configuration, setup and maintenance of Oracle database.
• Analyzed requirements and prepared database designs. Implemented and maintained database through DBA activities include database backup (Cold, Hot, Import/Export, incremental), database recovery, tuning, installation, database creation, logical and physical databases design.
• Database maintenance including backups, restores, imports, exports, database changes and updates across environments
• Restore and Recover database from OS hardware crash.
• Maintaining Tablespace usage: Creating tablespaces, datafiles
• Performed logical DB design, sizing of tables & Indexes, and indexing, foreign key constraints
• Cloning Oracle Application using Rapid Clone.
• Applying Application patches using adpatch.
• Tuning, Data Migration, loading with SQL Loader
• Worked with users to determine system requirements.
• Monitoring application performance, Performed troubleshooting of the database.
• Rebuilding fragmented indexes and partition indexes.
• Adding and resizing the datafiles to the tablespace whose usage is more than 90%
• Creating service request and Working with the Oracle support.

Confidential

Team Member

Responsibilities:

• Installation and upgrading of Oracle software from 10.2.0.1 to 10.2.0.4
• Creating Database 10.2.0.4 using DBCA.
• Metadata Repository Creation / Upgrade
• Data vault Installation and Security rule
• Create the schemas required for BPEL, ESB, and OWSM.
• Upgrade ORABPEL and ORAESB Schema's to 10.1.3.4
• Installation of Enterprise Manager Grid Agent
• RAC failover configuration
• Testing the Data Tier installation
• Oracle Application Server Infrastructure 10g 10.1.4.0.1
• Installation Oracle Internet Directory
• Installation Oracle Application Server Single Sign-On
• Installation Oracle Application Server Delegated Administration Service.
• Internet Directory Specify
• Testing the Oracle Internet Directory Instances
• Validate opmn component
• Upgrade Oracle Identity Management 10.1.4.0.1 to 10.1.4.2
• Upgrade Existing Infrastructure
• Specify OID Login
• Installing SOA Suite 10.1.3.1.0
• Oracle Application Server Patch Set 10g Release 3 10.1.3.4.0
• Upgrade ORABPEL and ORAESB Schemas to 10.1.3.4
• Install and Configure WebLogic Server Version 9.2
• Web and Application Tier Configuration
• Installing Enterprise Manager Grid Control 10.2.0.3
• Upgrading Enterprise Manager Grid Control from 10.2.0.3 to 10.2.0.4
• Oracle Application Server 10.1.2.2
• SOA Management pack Installation.
• Install and Configure Apache 2.2.10 (Reverse Proxy).

Confidential

Team Member

Responsibilities:

• Configure Primary and Standby database in Data Guard.
• Creating Physical standby database.
• Creating a Backup Copy of the Primary Database Data files.
• Creating a Control File for the Standby Database.
• Prepare an Initialization Parameter File for the Standby Database.
• Copy Files from the Primary System to the Standby System.
• Set Up the Environment to Support the Standby Database.
• Start the Physical Standby Database.
• Verify the Physical Standby Database Is Performing Properly.
• Switchovers Involving a Physical Standby Database.
• Failovers Involving a Physical Standby Database.
• Re-create and Re enable a Disabled Database.
• Managing Physical Standby Database.
• Configuring Data Guard Broker.
• Implementing Fast-start Failover.

Confidential

Team Member

Responsibilities:

• Applied the mandatory patch.
• Backup the database.
• Stopping all the Middle-Tier processes.
• Ensure that the Oracle Internet Directory and Database Processes are running.
• Perform the Upgrade by running mrua.sh script.
• Checking the portal version.
• Start all the Middle Tiers
• Taking the complete backup after upgrade.
• Taken the export/import of portal pages.