SUMMARY

• Having around 6+ years of experience in Information Technology, out of which the last 3+ years on Oracle Applications DBA and 3 years as an Oracle DBA
• Expert in Installation, Upgrade of Oracle Applications 11.5.9 thru 11.5.10.2 and R12.0.4,1 thru 12.1.1, 1 2.1.3
• Appling patches to 11.5.9, 11.5.10.2 versions of E - Business Suite.
• Cloning Oracle 11i Instance using Rapid clone and manual cloning.
• Upgrading Oracle Applications dot release upgrades using maintenance packs.
• Administering Oracle 11i Instances using AD utilities
• Installation, configuration and performance tuning of Oracle 11g RAC.
• Experience in managing the concurrent managers the internal concurrent manager ICM.
• Proficient in Installation, Cloning, Patching, space management issues and user management issues related to Oracle Applications, registration of forms and reports, which were developed as part of customization process with Oracle Applications.
• Experienced in Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, and redo mechanisms.
• Highly skilled in Oracle DBA - Installation, Administration, Creating, Backup & Recovery Strategy Implementation, Performance Monitoring/Tuning and Database Security for Databases
• Specialized in creating the user and assigning the responsibilities to the users.
• Proficient in checking the log files for error massages.
• Experienced in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using Export/Import, Expert in disaster recovery.
• Strong knowledge in Migrating Oracle 8i to 9i and 9i to 10g.
• Setup Data guard (Physical Standby)on Linux using new features of 10g/11g.
• Strong technical and analytical skills with excellent interpersonal and communications abilities.
• Hot and cold Backup and recovery of Oracle 10g database using tools like RMAN.
• Scripting and scheduling of oracle database backup using RMAN.
• Cloning of database for development teams, import and export of data
• Proficient in use of tools like Oracle Enterprise Manager, SQL*Loader, Export/Import and Toad.
• Extensive knowledge in working with the tools like OEM, OAM, Export/ Import, SQL* Loader, SQL Analyze, TKProf, Explain Plan, TOAD and Oracle Supplied DBMS PACKAGE
• Oracle Applications 11i & R12
• Oracle XML publisher
• Oracle Discoverer 10g & Oracle Workflow 2.6

TECHNICAL SKILLS

Operating System: HP-UX, Linux, Unix, Sun Solaris & Windows2005/2008R2

Databases: ORACLE 9i,10g/11g, Real Application Clusters (RAC 10g/11g)

Applications: Oracle E-Business Suite 11i, r12.0.4,R12.1.1,R12.1.3 Oracle Workflow

Application Server: Oracle Application Server (9iAS) /10gAS

Tools: SQL PLUS, SQL*Loader, Export & Import utility, Data Pump, RMAN, Data Guard 9i/10g,Tkprof, TOAD, Statspack, Discoverer, SQL Navigator, Oracle Application Manager, XML Publisher, Data Guard and OEM.

Languages: SQL, PLSQL, C, C++, VB, ASP, HTML, JSP, JavaScript & Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, San Jose CA

Oracle Applications DBA

Responsibilities:

• Database administration.
• Schema and user management
• Oracle applications Upgrading 11.5.10.2 to R12.1.1
• Oracle applications database upgrade to 10.2.0.3 to 11.2.0.3
• Memory management (monitoring the usage of table spaces and their size, monitoring the space and memory usage of segments like tables indexes)
• Monitored the Applications and database using OAM.
• Managing concurrent manager and troubleshooting
• Application Tuning AWR,ADDM,ASH, SQL Tuning Advisor
• XML Publisher Output post processor configuration.
• Gathered database/Objects statistics using DBMS UTILITY and DBMS STATS, packages
• SQL performance tuning
• Trace analysis and TKPROF
• Implemented Shared APPL TOP.
• Explain plan analysis
• Rebuilding indexes and Gathering statistics
• Reorganizing the tables and schemas
• Performance impact analysis for new code promotion.
• Monitoring the alert logs regularly.
• Used EXPLAIN PLAN, SQL TRACE for performance tuning.
• User Administration. (Creating users, roles and profiles).
• RapidClone, adpatch, adadmin, adsplice, adctrl, adaimgr, admrgpch utilities for Oracle Applications
• Analyze the code and help developers to tune the code.
• Cloning (Post-Clone Verifications)
• Analyze the patches before applied in Production
• Registering, Tuning for Concurrent programs.
• Database Tuning using AWR, STATSPACK utility.
• Concurrent manager/requests maintenance & tuning.
• Registered printer in Apps and solving printer problems using sudo command.
• Checking the invalid objects & recompiling the invalid objects by using utlrp.sql

Environment: Solaris 10, Linux, Oracle 10g/11gR2, Oracle Applications 11.5.10.2/ R12.1.1, Putty,, TOAD 11,RMAN, Physical Standby

Confidential, New York, NY

Oracle Applications DBA

Responsibilities:

• Creating Development, Testing and production Environments.
• Installed Oracle Applications 11i on Single-node Install & Multi-node Install
• Establishing and administrating multiple environments for Production, Development, Test and Staging Instances.
• Error handling from databases to applications and rectifications.
• Planning and Administration of backups and recoveries strategies.
• Expert in PL/SQL with ability to tune complex queries.
• Have done tuning of Oracle Applications, Concurrent managers, Apache Server, Forms Servers, Reports servers.
• Installed and configured Oracle10g RAC.
• Have done the capacity planning before implementing the architecture and installation for R12.
• In depth knowledge and experience with RapidInstall, RapidClone, adpatch, adadmin, adsplice, adctrl, adaimgr, admrgpch utilities for Oracle Applications.
• Performed Oracle Application upgrades from Oracle Apps 11.5.9 to 11.5.10
• Installation, configuration, maintenance, cloning and patching procedures.
• Database and Application cloning.
• Monitoring and handling Concurrent Managers related issues.
• Registration of Printers, Printer Types, Printer Styles.
• Taking periodic backup of Applications & Databases
• Monitoring DB processes activities at OS level using top, glance, w command etc.
• Script writing and execution on LINUX and Windows environments
• Autoconfig configuration.
• Assigning the Program to Concurrent Manager (scheduling)
• Doing the scheduled backups and execution of point-in time database recoveries
• Auditing the Database at the user, object, session and privilege levels.
• Performance Tuning the SQL queries using EXPLAIN PLAN, SQL TRACE and TKPROF.
• Database Tuning using AWR, STATSPACK utility.
• Reorganizing the database to reduce disk contention, migration and chaining.
• Monitoring the instance statistics and tuning the database to improve performance.
• Creations Users and Assigning the Responsibilities
• Registering Concurrent Programs.
• Used RMAN for backup and restore.

Environment: Oracle 10g/11g Oracle applications (11.5.10, 11.5.10.2), Oracle Application Server 10.1.2, HP-UX, Solaris 10, VERITAS Netbackup, RMAN, Oracle10g RAC

Confidential, San Deigo, CA

Oracle Applications DBA

Responsibilities:

• Oracle Applications 11i Installations, Managing configuration, Cloning, Security, Patching, Upgrades, Maintenance using AD and other utilities
• 24x7 Production Oracle Applications Administration.
• Responsible for managing production, development & test databases and applications.
• Upgraded Oracle 11i applications version from 11.5.9 to 11.5.10.2
• Applied patches using ADPATCH, ADCTRL, ADADMIN utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG commands.
• Automation of tasks like backup/refresh and other jobs using.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one of Patches etc).
• Oracle Applications Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Registered printer in Apps.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Created new application messages and then generated message file for application.
• Created new concurrent managers, Purged concurrent requests table.
• Analyzed the database using Oracle STASPACK, TKPROF, SQL Trace and Explain Plan.
• Wrote stored procedures, packages, triggers and functions using PL/SQL.
• Provided application support to users and created a log of all the problems with solutions for future reference.

Environment: Oracle Apps (11.5.9, 11.5.10, 11.5.10.2), Oracle RAC 9i/10g, Sun Solaris, Oracle Database 9i/ 10G, OEM, Toad, SQL Navigator

Confidential, MN

Oracle Apps DBA

Responsibilities:

• Installation, upgrade and configuration of database and 11i
• Oracle Applications 11i Installations, Managing configuration, Cloning, Security, Patching, Upgrades, Maintenance using AD and other utilities.
• Installed & configured Oracle Applications 11i on single node and Multinode Database and checking all applications working properly or not.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management, and Security Administration.
• Upgraded the test instances to 11.5.10 and documenting all the steps.
• Applied patches for bug fixing, upgrading products and Oracle applications and checking the log files for error messages.
• Periodic cleaning of Log/Output files.
• Backup and recovery of the databases. Developing cold and hot back backup strategy and making necessary scripts.
• Application user creation / responsibilities assignment, applying minipacks, Maintenance pack, family pack and one-off patches
• Cloning of oracle database and application
• Database upgrade & application upgrade
• Applied patches using ADPATCH, ADADMIN, ADCTRL, ADMRGPCH utilities
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan
• Concurrent manager/requests maintenance & tuning,
• Remedy and ticket resolving
• Preparation of technical documents, writing shell, sql scripts for Apps and Core DBA activities.
• Handling Production Database and ERP issues and database changes/fix
• Use RMAN for backup/recovery, setup a companywide centralized repository.

Environment: Oracle Application 11i (11.5.10, 11.5.10.2) with two node installation under Linux, HP-UX, RMAN, TOAD, OEM, SQLPLUS, UNIX Shell Scripts.

Confidential, Minneapolis, MN

Oracle Applications DBA

Responsibilities:

• Installation of Oracle Applications Oracle Apps 11i (11.5.8, 11.5.9, 11.5.10)
• Cloning of Oracle Applications 11i.
• Applying family packs and one of patches for bug fixing.
• Upgraded Oracle Applications from 11.5.9 to 11.5.10 and used staging to reduce the downtime for production.
• Taking care of backups using RMAN, hot and cold backup under UNIX.
• Creation of several packages, stored procedures, database triggers, functions & materialized views etc.
• Maintain database security, user roles and access profiles.
• Use Oracle RMAN for backup/recovery.
• Performance tuning of very large Oracle Reports, SQL &PL/SQL code for better performance.
• Troubleshooting issues and coordinating with Oracle for TAR Support.

Environment: Oracle E-business Suite 11i, 9iRAC database, Linux, Windows NT, HP-UX

Confidential

Oracle DBA/Oracle Apps DBA

Responsibilities:

• Database Administration (Space, Distribution, Recovery)
• Monitoring the alert logs regularly
• Creating, checking, extending table space.
• Administered database security, created users, granted/revoked roles & privileges.
• Extended databases storage capacity, monitored and reduced database fragmentation.
• Managed data files, rollback segments, extents, segments, indexes.
• Implemented sound backup, recover and restore policies.
• Extensively used SQL Loader to load data from flat files to the Oracle Database.
• Used RMAN to restore and recover database.
• Used Flashback, Export/Import, data pump utilities. sed EXPLAIN PLAN, TKPROF, SQL TRACE for performance tuning.
• Database Backup Strategy and Archive log mode
• User Administration. (Creating users, roles and profiles)

Environment: Oracle8i/9i and Windows 2000 server, Linux

Confidential

Oracle DBA

Responsibilities:

• Responsible for, both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
• Configured and Installed Oracle Application 11i using Rapid Install.
• Upgrading the Base install 11.5.5 to 11.5.6 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM.
• Setting up of printers In the Apps.
• Maintenance of concurrent processing requests and concurrent managers.
• Tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH and ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Debugged Oracle Reports and Oracle Forms programs.
• Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Assists in design tasks such as debugging, specifications development and system integration testing.

Environment: Linux 2.4, Oracle database 7i&8i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader