SUMMARY

• Over 7 years of experience as Oracle DBA. Worked extensively on Oracle 11g, 10g and 9i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• Expertise in installation, configuration and administration of Oracle 11g, 10g and 9i on SUN SOLARIS, LINUX, WINDOWS for OLTP and Data Warehousing .
• Expertise in installation, configuration and administration of Oracle EBS 11i and R12 on LINUX, WINDOWS.
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Implemented Oracle 11g Real Application Clusters (RAC), Oracle Automatic Storage Management (ASM) on LINUX platforms.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)and performed TSPITR.
• Having experienced in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Implemented Oracle SOA Suite 11g Active - Active setup with Dataguard Fast Start Failover.
• Installation of Oracle database 9i, 10g and 11g on Windows and Linux.
• Expertise in cloning, patching, backup, administering concurrent manager, troubleshooting database and apps related issues.
• Creating the database, managing database aspects like User Management, Creation of database objects, Tablespace Management and Security Administration like Privileges, Roles, Auditing, Profiling, and Authentication.
• Experience in upgrade of Oracle EBS from 11i to R12.
• Experience in installation, configuration and administration of Oracle UCM 10g,11g.
• Experience in upgrade of Oracle Universal Content Manager (UCM) from 10g to 11g.
• Experience in installation and administration of WebLogic11g,Oracle Application Server10g.
• Patching of Oracle Application Server from 10.1.3.1 to 10.1..3.3
• Experience in Oracle Database Upgrade from 10g to 11g
• Experience in the management of schemas, de-fragmentation and partitioning the tables & indexes to improve the performance
• Export/Import (datapump and exp/imp) of DB, schema, loading data from other sources like Excel, CSV and Flat files using Sql * Loader.
• Performance Tuning of Oracle Database using SQL TRACE, TKPROF, EXPLAIN PLAN, STASPACK and AWR
• Experience in maintaining Oracle EBS using Oracle AD utilities/tools adadmin, adpatch, admrgpch, adctrl, adautocfg, adclone etc.
• Strong problem solving skills, Hard Working, committed, self starter and a team player with Good communication skills.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, RAC 11g

Oracle ERP: Oracle EBS 11i and R12

Operating System: Solaris, Linux, Windows 2003/2008 Server

Middle Tier: Web Logic Server 11g, Oracle Application Server 10g

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, configured and administered Real Application Clusters (RAC) 11g
• Configured SOA 11g Cluster Active - Active Setup with Oracle Dataguard.
• Configured Oracle Dataguard (Active Standby), Dataguard Broker and Fast Start FailOver.
• Implementing Oracle Golden Gate 12c for Table replication in Bidirectional mode.
• Responsible for Production Database Code Releases
• Implemented Table Partitioning (Using Interval Partitioning Method), created script in PLSQL to drop partition and set up cronjob for running the script on weekly basis.
• Troubleshooting Performance issues using AQR and ASH reports
• Involved in upgrade of 10.2.0.3 RAC to 11.2.0.3 RAC
• Applied Latest PSU patch on Weblogic 11g Server and Bundle Patch on SOA Suite 11g
• Applied PSU and CPU patches to Oracle 10g/11g RAC and Standalone Databases
• Upgraded the oracle databases from versions 10g, 11gR1 to 11gR2 (11.2.0.3)
• Generating trace files and using TKPROF for diagnosing SQL Query performances
• Analyse database schemas, tables and indexes to improve database performance
• User creation and roles, privileges grant
• Monitor tablespace usage and allocating space as needed
• Developed Automated Shell script for schema refresh from one environment to another environment.
• Created purge scripts for table in SQL/PLSQL and set up a cronjob for running the purge scripts weekly and daily.
• Configure Weblogic Multi Datasource and GridLink Datasource to connect to Oracle RAC DB
• Performing RMAN backups (full/incremental) and crash recoveries.
• Performed general DBA activities like user management, tablespace management, security management of the databases
• Used import/export, Data Pump, to refresh databases, tables, schemas etc from production.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications
• Involved in Performance tuning of a database using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ADDM.

ENVIRONMENT: Oracle RAC 11g R2,Oracle SOA Suite 11g,Oracle 11gR2,Oracle WLS 11g,OEL 6 (64bit)

Confidential, Redwood City, California

Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle Database server 10g (10.2.0.1), Oracle Universal Content Server 10g(10.1.3.5) and Oracle Application Server 10g (10.1.3.1).
• Upgrade of Oracle Application Server from 10.1.3.1 to 10.1..3.3
• Upgrade of Oracle Database from 10g(10.2.0.1) to 11g(11.2.0.1)
• Upgrade of Oracle Database from 11.2.0.1 to 11.2.0.2
• Installed and configured Physical Standby Database with Oracle Dataguard.
• Applied Latest Security Patches (CPU) on Oracle Database Server
• Applied Latest Patch Set Update (PSU patches) on Oracle Web Logic Server
• Upgrade of Oracle Universal Content Server from 10g(10.1.3.5) to 11g(11.1.1.4)
• Installation and Configuration of Oracle Web Logic Server 11g (10.3.4) and Universal Content Server 11g
• Upgrade of Oracle Universal Content Management (UCM) 11g from 11.1.1.4 to 11.1.1.5
• Upgrade of Web Logic Server from 10.3.4 to 10.3.5
• Installed and Configured Oracle HTTP Server as Proxy to Application running on Web Logic Server for SSO Configuration.
• Upgrade of Oracle HTTP Server from 11.1.1.2 to 11.1.1.4 and 11.1.1.4 to 11.1.1.5.
• Configured IBR and URM with Oracle UCM by extending the domain
• Migrated Oracle Database 11g, Oracle UCM 11g and Oracle Weblogic Server 11g from OEL 5.3 32 bit to OEL 5.5 64 bit.
• Implemented Secure Socket Layer (SSL) for UCM application
• Implemented Single Sign On (SSO) for UCM application with Oracle Corporate SSO
• URL redirection in Oracle HTTP Server
• Created Shell Script for Startup and Shutdown of UCM Application
• Monitored and diagnosed database performance monitoring of alert files, trace files
• Proactive data base monitoring and performance tuning using Statspack, Explain plan, AWR, ADDM.
• Generating trace files and using TKPROF for diagnosing SQL Query performances
• Analyse database schemas, tables and indexes to improve database performance.
• User creation and roles, privileges grant.
• Monitor tablespace usage and allocating space as needed.
• Monitor oracle user sessions activities.

ENVIRONMENT: Oracle 10gR2,Oracle 11gR2,Oracle UCM 10g,Oracle UCM 11g,Oracle WLS 11g,Oracle HTTP Server 11g.OEL 5.5 (64bit),OEL 5.3 (32bit)

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Installation and configuration SOA 11g and EBS R12.1.1 in Production environment.
• Configured Materialized View for Table Replication
• Upgraded Oracle Database from 10g to 11g and migration of the database from HP-UX to Linux.
• Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Purging of SOA instances
• Creating database link to SQL Server from Oracle Server using DG4ODBC
• Improving the EBS performance
• Troubleshooting Concurrent Manager Issues
• Resizing data files, adding redo log groups, user management
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Monitored and diagnosed database performance through monitoring of alert files, trace files
• Daily monitor database tablesapce usage in production server as well as development and UAT environments
• Proactive data base monitoring and performance tuning using Statspack, Explain plan, AWR, ADDM.
• Performing Logical Backups
• Monitoring and Managing storage, Tablespaces, Segments and Extents.
• Security User Management, Privileges, Roles, Auditing, Profiling and Authentication.
• Incorporating users issues as per requests like locks, account locks, privileges and application issues
• Performed Point-in-Time recovery and incomplete recoveries.

ENVIRONMENT: Oracle 11g,Oracle EBS R12, Oracle SOA 11g, OEL 5.5 (64bit)

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Responsible for Complete Solution from Hardware sizing, System setup, Download the required Application & Database Patches, upgrade, validation and delivery of artifacts
• Come up with the Best possible Upgrade approach for Database, Application Stack upgrade on Dev, QA.
• The Project was implemented in 2 phases, 1st phase: upgrade of 10gR2 database to 11gR2 database, EBS 11i to EBS R12.1.1 on Solaris SPARC 64 bit server was carried out within 3 days.
• EBS 10gR2 (10.2.0.2) was upgraded to 11gR2 (11.2.0.3) database
• Install 11g software; upgrade the 10g db to 11g by dbua.
• EBS 11i application was upgraded to R12.1.1Installing the R12 filesystem, put the application is in maintenance mode, Apply all the pre upgrade patches, module specific patches and upgrade performance patches a on the systemApply R12 upgrade driverApply post upgrade and module specific patchesComplete the post upgrade steps.
• 2nd phase EBS R12.1.1 OS Platform Migration was carried out from Solaris SPARC (64 bit) to RHEL 5.3 (64 bit), 1 week after upgrade by
• Complete Database was exported/imported using oracle expdp and impdp.
• EBS Application was migrated by
• Installing the Application Tech stack on the target serverRunning the pre clone on the source system and copying the common top, appl top and few other directories from source system to target systemGenerate context file for the target system, run the Autoconfig on the target environment, download and apply customer specific manifest patch on the targetRun the Autoconfig on application tier to generate appsutil, transfer it to db tier, re run autoconfig on application tier, complete the post migration steps
• Application functional testing and validation
• Documentation of all the 3 different upgrade stages, processes and handing over the artifacts to client

ENVIRONMENT: Oracle 10gR2, 11gR2, DEV, STAGE, TEST Environments, SOLARIS SPARC 10 (64 bit), RHEL ES 5.3 (64 bit), EBS 11i, EBS R12.1.1.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle Database 11gR2 and Oracle Enterprise Manager Grid Control 11gR1.
• Installation and configuration of Oracle Weblogic Server 11g Release 1 (10.3.2) on OEL 5.3.
• Installation and Configuration of Remote Grid Agents through Agent Push method to remote Oracle Apps (both 11i, R12) databases and Application servers.
• Set Threshold values for important metrics, configure alerts for pro active monitoring, fine tune the database,
• Configure and Schedule jobs, reports.

ENVIRONMENT: Oracle Weblogic Server 11g, DB 11gR2, OEM Grid 11gR1, OEL 5.3

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Installation and configuration of 11i application on RHEL 4
• Performed patch analysis for patches involving pre-requisites for upgrade Developer 6i Version and 10g Release 2 interoperability patch for 11.5.10
• Apply Latest Autoconfig Patch.
• Apply application patches by adpatch.
• Install 10g software with new rdbms oracle home
• Upgrade database by DBUA

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Upgrade of Oracle Databases from 9i to 10gR2
• Configuration of Oracle Utility RMAN(Recovery Manager).
• Taking Database Cold backup and RMAN (Hot Backup and Incremental Backup).
• Oracle Database Manual, Hot Cloning using DBCA.
• Logical Backup (Schema level, User level, Table Level).
• Installation of Oracle EBS 11i, R12.
• Installation of Oracle Databases 9i,10g,11g.
• Database Patching Using OPatch.
• Tablespace management, user management
• Master of Computer Applications, Calicut University, India