Objective

Seeking for a position as an Oracle Applications Database Administrator with a medium to large International Corporation with team-based projects, where I can utilize my knowledge of technology in the development of custom business systems

Experience Summary

• Over 7 years of experience as an Oracle Apps DBA and Oracle Core DBA
• Experienced in 8i/9i/10g and 11g Database administration & Oracle Applications 11i and R12
• Experienced in various Unix Platforms and Windows System.
• Oracle Database Infrastructure experience on Single node and multi-node environments.
• Concurrent Manager Setup on Single node and RAC instances (PCP) and trouble shooting.
• Strong Experience in Cloning & Patching 11i, R12 Instance using Rapid and manual cloning.
• Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12.
• Applied patches to update and security fixes to Oracle E-Business Suite 11.5.x and R12.x

Multiple upgrades of Oracle Apps 11i, which includes database upgrade from 9i to 10g as well as application tier upgrade 
Administrating the oracle database and applications with the AD utilities. Adautocfg, adaimgr, adadmin, adpatch, adrelink

• Expertise in converting single instance database to Real Application Cluster (RAC)
• Automatic Storage Management (ASM).

Experienced working in OLTP environments 
Administrating the AOL/FND for setup the new user set user and system privileges.
Apply the patches like patch, mini pack, maintains pack to fix the bug.

• Application’s sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions, Profiles, Alerts.
• AD Utilities adadmin, adpatch, admrgpch, adctrl etc.
• Troubleshooting Login, Self Service Application, Concurrent Processing, Jinitiator and Network related issues.
• Backup and Recovery of the Oracle Databases using VERITAS Netback up, RMAN, Oracle Data-Guard and by designing own shell Unix Script.
• Hands on experience on Sun storage and NFS services.
• Installation and configuration of Single or multi node Application Middle Architecture with Load Balancing.
• VERITAS Storage Foundation for high availability.
• Disaster Recovery Policy Implementation for critical Applications.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Expert in SQL* Loader, export/import and data pump import to load data in to tables.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Solid experience on Various *ix platforms and Windows

Work Experience

Confidential, Redwood City, CA
Role: Oracle Applications DBA In Oracle On Demand 
Period: Mar’11 –Till date 
Environments : Linux, Hp-ux, AIX, Solaris ,Oracle database 9i,10g and 11g, Oracle EBS 11.5.x and R 12.x ,Discoverer 10g and 11g ,Weblogic

Description:
Currently working as a Production Support DBA in Oracle On Demand Command Center. The Command Center team specializes in expert level hosting system and application restoration to minimize outage downtime and maximize system availability. The Command Center is also responsible for first level outage reporting, root cause analysis, and corrective action identification. The Command Center develops and promotes long term solutions in the areas of operations process improvement, configuration management, and product enhancements to increase overall system reliability. 
Responsibilities:

• Supporting Oracle On-demand Customers running various versions of Database (Oracle 8i, 9i, 10g and 11g), Oracle Applications (11.5.x and R12.x).
• Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test, dev and stage Ondemand Customer environments.
• Daily responsibilities include trouble shooting and restoring Oracle Applications components Apache, Forms, Reports, Concurrent Managers, Workflow Managers, Discoverer plus/viewer, iAS, Single Sign-on
• Discoverer 10 g and 11 g
• Identifying, analyzing and resolving technical problems related to Oracle software systems.
• Restore failed services; find workarounds to reduce business outage situations.
• Worked on multi-node RAC DB and multi-node Mid-tier Apps.
• Performance tuning on DB and Applications.
• Performing dry run for disaster recovery test for Ondemand Customer instances.
• Monitor and Support Apps in new 11g RAC, 11g ASM.
• Integrating Oracle E Business Suite with Microsoft Active Directory.
• Performed Oracle Apps/Database performance Tuning.
• Handling Database locks and Sessions.
• Tuning of long running concurrent requests.
• Tuning of various database parameters ,JDBC and JVM parameters
• Hands on experience on various production issues
• Disk space checking, Alert log and Trace monitor.
• User managed Backup, restore and recovery (Hot and Cold backups).
• Apply patches to the database using opatch tool.
• Oracle Custom Application Creations Created Custom Application, menu, function and attached custom forms and custom reports. Also created custom table space and oracle database user.
• Handling the DBA Activities (Patching, Cloning, Installation, and Backup) Applied Application and database patches to fix the issue.
• Installed Needed Software on Client Machines for Technical and Function Training. Installed J2SE, Configure host file to access Application R12, added tnsname to access database using Toad.
• Maintain user security and created users for client to access Application. Created users and attached them needed responsibility by using Data Loader Tool
• Configure barcode printer with oracle application Attached the barcode printer to desktop and fetched barcode information from printer to form and save
• Hands on experience with Disaster Recovery
• Hands on experience in troubleshooting problems with web server, web listener, forms server, and concurrent managers, and database monitoring the concurrent Reports status if need monitor corresponding concurrent manager and fix the issue.
• Monitoring the file system, table spaces of database and increased as needed.
• Worked on XML publisher report SQL Query Development, Query Optimization, Report Template Design, and Registration with Applications. Developed the XML publisher graphical Reports for clients to show the data in graphical form.
• Oracle RDF Reports. Used Data Wizard according to the report’s requirements and developed the query developed the graphical Reports for clients to show the data in graphical form. Make the Conditional Formatting to data according to defined exceptions or conditions. Wrote and Called Stored Procedure from reports
• Form personalization Form folder Management, Custom Field validations, shown the customization on particular Responsibility.
• Hand on experience in configuring the MWA services with Oracle EBS
• Database recovery point in time recovery using RMAN
• Handling data block corruption.
• Basic knowledge of people soft applications

Company : Confidential, San Jose, CA 
Role : Oracle DBA. (PRODUCTION SUPPORT)
Period : Jan 10 – Mar’11.
Environment: AIX, Solaris, Linux, SQL, Oracle 9i/10g/11g, RAC-10g/11g,Solaris10,ASM, TOAD, Dataguard, RMAN

RESPONSIBILITIES

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Hands on experience working and managing VLDB’s up to 80TB.
• Performed cross platform migrations from Oracle 10g to Oracle 11g ( Solaris-Linux)
• Proficient in migrating data base from 9i/10g to 11g by applying latest patch sets..
• Configured RAC on Linux systems coordinating with network and system administration teams.
• Configured 11gR2 RAC on Solaris cluster environments, Installing Cluster ware and Grid infrastructure.
• Managed ASM on 11gR2 systems and registering cluster systems into ASM.
• Performed RAC node decommissioning on a 4-node RAC environment converting it to a 2-node.
• Involved in monitoring and maintenance of over 20 Oracle 11g/10g R2 and Dataguard instances
• Hands-on experience on pl/sql functions and procedures
• Hands -on experience with cursors and triggers, Exception handling
• Experienced working with various new features of oracle 11gR2.
• Configured and worked on 2,3,4 node RAC environments and high availability systems.
• Implemented Oracle advanced security across various database levels
• God knowledge on various production issues.
• Managed production and development databases timely.
• Used Data guard for data migration from various databases.
• Installation and maintenance of Oracle 10g and 11g database.
• Involved in the process of tuning and refining queries of various applications.
• Configuring and maintaining 10g/11g Data guard .
• Data guard rebuild by using RMAN incremental backup and hot backup.
• Created several single instance databases and converted them to Oracle RAC 11g adding services by cloning and database refreshes.
• Configured ASM for all the cluster databases and set archived destinations, FRA’s, Backup and log locations.
•  Configured CRS and added various databases and services on to the cluster.
• Implemented RMAN backup and setup shell scripts and crontab entries for all the development and production instances.
• Periodically set tape backups and optimized backup locations by moving old backups to compressed locations and further creating space for fresh backups.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Extensive usage of ADDM, AWR, ASSM, features of 10g and 11g.
• Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Restoration and recovery from backup.
• Cloning of application from production environment to test environment and application of patches.
• Moving data from development to production through transportable tablespace exports.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Implementing standby database and database replication to provide high availability of database.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Implementing the changes in various configuration parameters.
• Done extensive performance tuning and implmented major performance changes on various databases after capacity planning.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Experience with SQL*Loader, loading data from text files.

Company: Confidential, Dallas, TX
Title: Oracle Apps DBA 
Period: Oct 08 to Dec 09

Responsibilities as APPS DBA:

• Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, firefighting, developer/integrator relations, script development, and documentation.
• Design and Implementing Business Continuity Plan for Oracle ERP Application with Data Guard.
• Performed R12.1.0 to R12.1.2 and R12.1.2 to R12.1.3 upgrade on RHL 7.3.29 and Solaris version 10
• Performed 11.5.8 to 11.5.9 upgrade with migration from Windows NT to Sun Solaris 9.
• Oracle 11i experience includes, 11.5.8 install and upgrade to 11.5.10 with the Forms, Web Server, Reports and Concurrent Mangers on Sun Solaris node.
• Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Installed and configured an Oracle Applications Release 11i (11.5.10) environment with Oracle database 9i Release 1 (9.2.0.5).
• Installing and maintenance of Oracle Applications 11i on Windows NT, Windows 2000 and Sun Solaris
• Cloning of application and the database by using autoconfig and creating multiple instances in Order to support the Application developers to test various scenarios.
• Coordinating with Oracle Technical assistance Team to resolve any issue relating to ERP
• Using AD utilities to maintain applications by compiling Apps Schema, Maintain Application Object menu, maintaining snapshots of the application using adamin and adpatch utilities for application of patches.
• Configuring notification mails from application to send it across to the user Inbox in Microsoft exchange for users for Purchase Orders and Quotation approvals as per the hierarchy set in the application.
• Configuring and setting printer setting and printer style for check Printing and other application Program
• Application System administration tasks such as Defining Responsibilities, User session Limits, Managing Concurrent programs and requests Purge Obsolete workflow data, Organizing Programs into request groups, defining data groups, Managing concurrent Programs by defining managers, scheduling requests to run at regular intervals, Cost based Optimization in applications, gather schema statistics, gather table statistics, administration of workflow to administer the workflow enabled processes.
• Frequent Monitoring of alert log, system log, for information or errors and resolve the same based on the logs
• Monitoring database for fragmentation and de-fragmenting of tables. Reorganization of the tables, table space Refreshing development database from production for testing
• Online / Offline backup of database using the archive logs and the sun operating system backup using at command.
• Planning the Disaster recovery in the event of database crash to recover without any loss of any data.
• Analyze, drop and recreate indexes to improve performance both with enterprise Manager and manually through command Prompt.

Company: Confidential, Cedar Rapids, Iowa 
Title: Oracle APPS DBA 
Period: Feb 07 – Sep 08 

Responsibilities:

• Coordination with the Client and Development team
• Provisioning of the new Oracle Applications instance
• Enabling the PCP for the Concurrent manager
• Performed the upgrade of 11.5.10. to 12.0.6 on Solaris 9.
• Performed the upgrade of 11.5.6. to 11.5.7 on RHL 5.9
• Upgrading the Database from 9.2.0.7 to 10g R2 on RHL 5.9
• Creation of the application users, assigning responsibilities etc
• Have implemented RAC setup for the Applications
• Cloning the Oracle Applications
• Application of the patches (Database, Teckstack, Functional & CPU)
• Promotion of the custom code objects across the instances
• Cloning from ASM to Non ASM databases and vice versa
• Configured the Applications for Load balancing and failover options on RAC instances
• Troubleshooting the Apache, Concurrent manager, program issues etc.
• Enabling the new products with licensing, configurations etc.
• Import/Export of Oracle Databases
• Optimizing disk space and performance tuning Oracle databases
• optimizing performance of Oracle Databases
• Creating users and assigning them roles and privileges in Database level.
• Re writing PL/SQL codes in case of performance issues and providing support to developers
• Maintenance of database like resizing datafiles, adding datafiles, raising tickets for disk space issues Sizing database objects for effective space management and optimal performance

Company: Confidential
Title: Oracle Apps DBA
Period: OCT 2005 – JAN 2007

Responsibilities:

• Strong hands-on experience with Oracle 9i, 10g databases, RMAN, RAC, and Oracle Applications release 11.5.5.
• Solid experience in supporting several production and development Oracle databases.
• Extensive experience working with UNIX Shell scripts and Sun Solaris 9 environment
• Monitoring and managing large database backups and verifying several recovery scenarios.
• Oracle application 11i patching and rapid clone. .
• Administration, maintenance, and tuning of concurrent managers, monitor operations, schedule and purge requests.
• Extensively used Oracle AD utilities on a day-to-day basis
• Worked on Oracle export and import utilities to get objects from Production to Test and UAT environments.
• Creating and Managing Custom concurrent managers, Request groups, and Concurrent programs. Resolving Internal Concurrent Manager issues. Scheduling and running the purge program for deleting the Concurrent manager Data. Defining Custom manager and programs.
• Monitoring Concurrent managers.

- Monitoring application and database.

• User responsibility management.
• TAR Handle.
• Setting and Managing Users
• Setting profiles.

Company: Confidential
Title: ORACLE DBA
Period: Oct 04 – Sep 05

Responsibilities:

• Installation, configuration, and maintenance of Oracle 8i and 9i on both Windows NT and UNIX environments
• Create and Maintain Roles and assign necessary privileges to users according to business rules.
• Allocating system storage and planning future storage requirements for the database
• Implemented Database Backup (Physical and Logical) and Recovery strategy
• Configuring TNSNAMES.ORA and LISTENER.ORA for Client-Server connections
• Creating Database objects like (Tables, views, indexes, procedures, triggers etc) and also monitoring Alert Logs
• Using Database replication by shareplex.
• Creating & Maintaining Tablespaces.
• Choosing different types of data storages (Locally managed tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.
• Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack, Utlbstat, Utlestat, Diagnostic and tuning packages
• Plan and Implements backup and recovery of theoracle database Using Rman and Veritas Net backup.
• Creating and maintaining database cloning and database replication.
• Implementing Advanced Security in Databases using User, Roles etc
• Data loads using SQL*Loader, export-imports for backing certain tables.
• Backing up the production database, synchronizing the standby database by responding to any physical changes in the primary database.
• Back end Programming using SQL and PL / SQL and UNIX shell scripting.
• Modifies Oracle instance initialization parameters as necessary
• Coordination with front-end developers in designing complex queries.
• Tuning of all the queries using Explain Plan, Tkprof and perfstat tuning of other objects in the database, tuning of database, tune the memory structure.
• Media Recovery (e.g.ww2 Hard disk failure, Block Corruptions) using archived logs.

EDUCATION QUALIFICATION: Bachelor of Technology in Electronics and communications engineering