Summary:

An Oracle Applications Database Administrator offering more than Eight years of Oracle Database Installations, Upgrade, Cloning, Patching, Backup and Recovery, Troubleshooting and Support of Oracle 11i/R12 Applications with 11G/10G RAC Databases on Linux platform.

• Extensive experience in development/test and production environments.
• Extensive expertise as an Oracle Apps DBA supporting various products and different applications versions of Oracle Applications including version 11.5.5, 11.5.8, 11.5.9, and 11.5.10.2&12i On Linux, Solaris Platforms.
• Proficient in Oracle Apps DBA/ Oracle Apps DBA with RAC
• Experience in Installation, Administration and Maintenance of Oracle Apps11i(EBS)
• Installation of Oracle Applications (EBS) R12. Installation, administration and maintenance of RAC11gR2, 10gR1, 10gR2 on Linux and Solaris platforms
• Expertise on Backup and Recovery of Single and RAC Databases using RMAN
• Expertise on Patching and Cloning of Oracle Apps 11i/R12 and 10gR2/11gR1 RAC Database on Linux and Solaris Platforms
• Expertise in Oracle advanced Technology like RAC, ASM, Dataguard, OEM, Grid Control and Replication
• Installation, Administration and Maintenance of Oracle Application Server
• Expertise on Cloning of RAC clusterware and Database, Oracle Apps 11i/R12 Single node/Multi node, Oracle Apps 11i/R12(EBS) with RAC and ASM
• Load balancing of RAC Database, Load balancing of forms tier, and configuring parallel concurrent processing and Transaction manager
• Expert in Deploying Different fusion and Apps 11i applications
• Worked on Vertex Administration.
• Hands on QTP upload of Oracle Responsibilities
• Worked on Printer related setups from oracle applications side
• Good experience in the fusion Applications Deployment.
• Exposure to different Hardware like Compaq Server, IBM Server, Sun Fire v1280, Sun Fire v480, HP Blade Servers (BL e-class), DELL, EMC Storage and Fire wire
• Configuration and maintenance of Shared APPL TOP in Linux Platforms
• Experience in Application support activities to the offshore development team (Technical/Functional)
• Space Management, and performance management with respect to applications
• Proficiency in creating business and technical project documentation.
• Expertise is working with global and distributed project teams. Ability to work as a strong team leader to ensure quality and timely project execution

EDUCATION

Bachelors of Technology in Computer Science and Information Technology

CERTIFICATIONS

• Oracle Certified Professional (OCP) for Oracle E-Business Suite 11i DBA
• Oracle 9i Certified Associate Database Administrator (OCA)

PROFESSIONAL EXPERIENCE

Confidential,Los Angeles, CA Jun 2008 to Till Date

• Responsible for maintenance of various developments, test and 10gR2 upgrade instances.
• Responsible for supporting production environment and production path development environments.
• Responsible for maintenance of 11.5.10(EBS) upgrade assessment instances.
• Installed and configured RAC setup for 11i(EBS)
• Configured PCP(parallel concurrent processing ) in Multinode RAC environments
• Support development team for 10g and 11i (EBS) upgrades.
• Manage and executing daily DBA tasks for offshore installation, administration and maintenance of 10gR2 (10.2.0.3) RAC Database with 11i/12i (EBS) in a multi-tier architecture
• Administration and maintenance of Oracle Apps 11i(EBS) (11.5.10 ATG RUP4) with 10gR2 RAC
• Migration of single instance 9i and 10gR2 database to 10gR2 RAC (10.2.0.3) with/without ASM
• Maintenance of two nodes RAC 10gR2 (10.2.0.3) with 10gR2 streams
• Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, database and applications) using ADCLONE utility and ADCFGCLONE on single, multi and RAC to RAC cloning.
• Configured Concurrent managers and Apache web server for applications (EBS)
• Used AWR,TKPROF and ADDM for resolving performance issues
• Installed new languages and products for rollover to other countries
• Worked with Rapid Install, Data installer, AD Patch, AD admin, AD relink, AD splicer, Adctrl utilities for oracle applications (EBS) for maintenance
• Expert in Deploying Different fusion and Apps 11i applications
• Working on Vertex Administration.
• Working on QTP upload of Oracle Responsibilities
• Working on Printer related setups from oracle applications side
• Good experience in the fusion Applications Deployment.
• Upgraded CRS from 10.2.0.2 to 10.2.0.3. Configured OEM on RAC 10g database
• Designed Online/Off-line Backup and recovery strategy using RMAN. Upgraded Discoverer 4i to 10g. Implemented Shared Appltop.
• Created users and assigned the responsibilities to them. Enabled Multi-Org
• Extensively worked on Oracle Financial s (AP, AR, and GL)
• Developed scripts to Monitor Table space issues
• Applied Critical patches, one-off, Family pack patches on DEV, TEST and PROD, used OPATCH for applying database patches
• Experience in Creating Web logic Domains and extending them with managed servers for diff applications on demand.
• Enabled MWA server through telnet. Installed Oracle Application server 10g
• Administrating and responding to Oracle Tar’s
• Health check and troubleshooting

Environment: OracleDatabase11g/10g/9i, OracleApps11i (EBS), Fusion and OEM 10g Grid Control, Oracle Database9i/10gR2/11gR2, ASM, RMAN, SRVCTL, CLUVFY, OCRDUMP, CRSCTL, SQL*Plus, PL/SQL and its associated tools, Shell, Perl, OEL 5

Confidential,Dallas, TX September 2006 - May 2008

Roles and Responsibilities: I am responsible for:
• Installation, maintenance and administration of Oracle 9i and 10g RAC Databases.
• Installation (single & multi nodes), maintenance and administration of Oracle Apps. 11i.
• Upgrading single instance 9i Database to 10gR1, 10gR2 Databases.
• Cloning Apps 11i, 10g, 11g & 9i RAC Database.
• Adding / Deleting RAC nodes from existing RAC setup.
• Backup and recovery of 10g RAC and 11gR1 RAC Databases.
• Tuning the 11gR1 and 10gR2 RAC Databases and ASM instances.
• Administration of Single and RAC 11gR1 and 10gR2 ASM instances.
• Configuring high availability database configurations of Oracle 10g/9i with best solution.
• Configured parallel concurrent processing with Transaction manager and AQ.
• Configured load balancing and failover of Application Database connections, Web tier, Forms tier and concurrent process tiers.
• Configured Business continuity plan for Oracle E-Business Suite 11i with 10g R2 RAC with ASM.
• Analysis and evaluation of 10gR2 RAC Listener with virtual IP Address.
• E-Business Suite 11i Technology stack migration from Solaris to RHEL 4.0.
• Implementation of Shared Appltop/ Merging of existing Appltop’s.
• Testing of Oracle Apps 11i Responsibilities, module specification forms with RAC Database connections.
• Installed printers and registered them with Oracle Applications.
• Administering Oracle Applications 11i modules.
• Automation of Oracle Apps 11i Cloning.
• Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc.
• Duplication of Oracle 10g Apps Databases with ASM and Raw devices using RMAN.
• Managing Concurrent Processing and transaction managers.
• Installation and administration of Oracle Secure Backup.
• Backup and Recovery of Oracle Apps Databases and monitoring through OEM Grid Control.
• Integration of 4i and 10g Discoverer with Oracle E-Business Suite 11i.

Environment: OracleDatabase10g/9i, OracleApps11i (EBS), Oracle Database9i/10gR2, ASM, RMAN, SRVCTL, CLUVFY, OCRDUMP, CRSCTL, SQL*Plus, PL/SQL and its associated tools, Shell, Perl, OEL 5

Confidential,Hyderabad, India May 2005 – June 2006

As Oracle Applications DBA

• Interacted with the Client to plan the installation. Installed 11.5.10.2 Oracle Applications on single node and multi node.
• Created users and assigned the responsibilities to them. Enabled Multi-Org after interacting with functional team members
• Created new responsibilities and menus for multiple organizations
• Applied patches
• Enabled Mobile Web Application (MWA) server through telnet
• Created Cronjobs for database alerts
• Health checkup of oracle application instances (Vision, Test, Development and Production)
• Checking Alert log, Apache log, and concurrent manager log files daily
• Checking and compiling invalid objects, clearing cache and bouncing the Apache
• Administrating and responding to Oracle Tar’s
• Performing system administration and AOL
• Trouble shooting various issues during day-to-day activities
• Administering and maintaining 3 databases (Production, Test and Development)
• Supporting of various modules include AP, AR, GL, INV, I Store, WMS, PO, OM, Telesales, BOM, WIP etc
• Installed printers and registered them with Oracle Applications
• Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc
• Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc

Environment – Oracle Database 8i & 9i, Oracle Apps 11i, SQL*Plus, iSQL*PLUS, PL/SQL, Oracle Forms 6i and Reports 6i, Oracle Apps 11i AD Tools, Oracle 9i Dataguard, Oracle 9i/10gR1 RAC, RMAN, Red Hat Linux4 AS 21, SCO UNIX, WinXP

Confidential,DBA Feb 2004 - May 2005

Roles and Responsibilities: As the Database Administrator, I was involved in:

• Installation, configuration and administration of Oracle 8i/9i/10g Database.
• Installation, configuration and administration of 9i/10gR1 RAC Database.
• Administration and maintenance of Oracle Apps 11i.
• Patching, cloning and administration of Oracle Apps 11i environments using various AD tools.
• Performance tuning and Optimization.
• Implemented the Disaster Recovery using Oracle 9i Data Guard and Oracle 8i standby Database.
• Applying the latest Patches on the oracle database.
• Migrated the database from (SCO Unix ) Oracle 7.3.4 to Oracle 9i on RH Linux AS 2.1
• Implemented the Data Purging Technique.
• Implemented the Oracle Advanced Replication using Materialized Views.
• Integrated the oracle databases using Virtual Private Database.
• Implemented the security policy in the oracle database.
• Creating Tablespaces, creating data files, helping users in creating database objects, enrolling users, security, backup, recovery and tuning.
• Carrying out specific Benchmark SQL Queries, Query execution plans and locking issues.
• Tune SQL Statements to improve the performance.
• Writing SQL*Loader control scripts and stored procedures.
• Loading data into database using SQL Loader utility for telecom billing and processing the DETAILED CALL RECORDS.
• Imported tables from Oracle 9i to oracle 8i for BSNL Web server.
• Taking hot backup regularly.
• Managing Rollback Segments and Temporary segments.
• Verifying hot backup once in a month on test server.
• Maintained Local Reports Server and local Test beds of oracle 9i on RHEL 3.0.
• Oracle Database cloning and troubleshooting.
• Analysis of table’s w.r.t transactional nature and setting up storage parameters

Technologies – Oracle Database 8i & 9i, Oracle Apps 11i, SQL*Plus, iSQL*PLUS, PL/SQL & its associated tools, Oracle Forms 6i and Reports 6i, Oracle Apps 11i AD Tools, Oracle 9i Dataguard, RMAN, Red Hat Linux AS 2.1, SCO UNIX, WinXP, WinNT, TCP/IP, UDP, HTTP/HTTPS.