SUMMARY:

• Oracle applications DBA offering close to 10 years of expertise in Oracle Database maintenance support, Oracle software installations, backup, recovery and patch installations. Experienced in oracle applications installations, upgrades, system monitoring, Performance tuning and troubleshooting.
• Experienced in upgrading Oracle Applications from 11.5.10.2 to R12.
• Installed and administered 11i/R12 Oracle Applications.
• Experienced in Oracle Internet Directory Administration /SSO Oracle Identity Management and integration with Ebusiness suite R12.
• Experienced in Oracle Fusion middleware technologies such as Discoverer , SOA suite 11g and hyperion
• Installed and upgraded discoverer from 4i to 10g and to 11g and integration with R 12.1.1
• Troubleshooting and Managing Configurations of the Oracle E-business Technology Stack mainly the Web server, Forms server, Reports server, Discoverer server and Concurrent Processing Server.
• Experience in working with AD utilities like ADADMIN, ADMERGE, ADPATCH and ADCTRL.
• Extensive experience in cloning Oracle E-business suite using RAPIDCLONE and some custom scripts.
• Tuning APACHE, JSERV for 11i E-business suite environment.
• Experience in third party software's like Vertex 3.2.2 and Markview.
• Extensive experience in tuning the database with STATSPACK/AWR, TKPROF, 10046 TRACE EXECUTION PLANS, SQL PROFILES, STORED OUTLINES, SQL PLAN BASELINES, SQL HINTS.
• Extensive knowledge of Oracle database upgrade, cloning, patching Opatch and administration.
• Strong experiences in RAC, RMAN and Data Guard configuration.
• Experienced in oracle web Logic and Exadata.
• Good Knowledge on Golden gate.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O and Sizing of tables.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache and redo mechanisms.
• Experience in upgrading oracle Real applications Cluster from 10.2.0.4 to 11.2.0.4 with EBS 12.1.1.
• Worked in various Operating system environments like IBM-AIX, SUN SOLARIS, Enterprise LINUX X86, and HP-UX.

Technical Skills

• Oracle ERP: Oracle Apps versions 11.5.9, 11.5.10.2, R12.0.6, R12.1.1, R12.1.3 with Oracle Financials, Manufacturing, HRMS modules.
• Databases: Oracle 11gR2, 11gR1, 10gR2, 10gR1, 9i, SQL Server 2000
• Languages: PL/SQL, SQL, Python, UNIX Shell Scripting.
• Operating systems: Windows 2000/NT/XP/2003, RHEL Linux 4 5, HP-UX 11.11, 11.13, Solaris 9/10, AIX 5.3.
• Database Tools: Oracle Enterprise Manager, Oracle Grid Control, SQL Analyzer,TOAD, Oracle SQL Developer.
• Back up Tools: RMAN, SQL Loader, Export/Import, Data pump, HP data Protector.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps DBA

Responsibilities:

• Monitoring Maintaining Critical Production database with Oracle E-business suite 11i applications.
• Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging environments..
• Perform Oracle Apps/Database performance Tuning.
• Performed Informatica upgrade from release 8.6 to 9.6.
• Migrated Oracle application 11.5.10.2 from HP UX 11.13 to Oracle enterprise Linux and upgraded the database to 11.2.0.4 from release 10.2.0.4
• Provide support to Webmethods IS which is integrated with different applications such as EBS R11, Cognos 8.2, Informatica 9.6, Amdocs and Inquira BI.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and monitoring the concurrent reports status if needed monitor corresponding concurrent manager and fix the issue. Monitoring the tablespaces of database and increased if needed.
• Working on Upgrading 2TB EDW 10g database to 2 node 11.2.0.4 RAC environment using transportable tablespaces.

Environment: Oracle 9i/10g/11g, Enterprise Linux 5, 10g RAC, Oracle EBS release 11.5.10.2, Webmethods 8.2, Cognos 8, Informatica 9.6, and Microsoft Sql Server 2008

Confidential

Oracle Apps DBA

Responsibilities:

• Involved in Upgrade planning of oracle production 10.2.0.4 database to 11.2.0.4 database.
• Worked on multi-node RAC DB and mutli-node Mid-tier Apps.
• Monitor and Support Apps in new 11g RAC, 11g ASM.
• Apply patches to the database using opatch tool and using ADPATCH for e-business suite patching.
• Oracle Custom Application Creations, Created Custom Application, menu, function and attached custom forms and custom reports. Also created custom tablespace and oracle database user.
• Maintain user security and created users for client to access Application. Created users and attached them needed responsibility by using Data Loader Tool.
• Installed Oracle Desktop Software on desktop Oracle Report Builder, Oracle Form Builders, Oracle XML Publisher and Oracle 10g Developer Suite.
• Form personalization, Form folder Management, Custom Field validations, shown the customization on particular Responsibility.

Environment: Oracle 9i/10g/11g, Enterprise Linux 5, 11g RAC, Oracle EBS release 11.5.10.2

Confidential

Oracle Apps DBA

Database Size: Range from 100 GB to 3 TB more than 200 Databases

Responsibilities

• Daily administration of Oracle Applications R12 and R11.
• Providing DBA support 24x7 to 32 US based Clients.
• Cloned production R12 EBS to non-production EBS.
• Involved in administering more than 200 Production databases on RHEL and OEL.
• DB Upgrade of Oracle Applications 11.5.10CU2 from 9.2.0.5 to 11gR2 11.2.0.4 ,12.1.3.
• Running autoconfig, setting up DMZ, Discoverer, Oracle Sysadmin activities and other maintenance activities
• Cloned Multi node system to single node system Rapid Clone with SSO/OID enabled instances.
• SSO/OID integration with Oracle Apps R11.5.10.2
• Database Refreshes from Prod to Dev. using Rapid Clone. Troubleshooting day-to-day users Issues in various modules.
• As a System Administrator, managed and control security of applications, setup new users, setting user profiles.
• Collect and analyze performance statistics for resource consumption and performance improvement. Managing Tablespaces, Data files, Rollback segments and Temporary Tablespaces.
• Patching and cloning for Multi-node environments at various release levels like 11i, R12
• Oracle Application upgrade from 11.5.10.2 to 12.1.3
• Dev and Test Database Refresh using RMAN Duplicate .
• Work Flow, Concurrent Manager, Printer set up/ configuration and troubleshooting of E-business suite R11,R12.
• EBS Sysadmin tasks such as creating and managing users, responsibilities, profile etc.
• Applied database updates to third party softwares like Vertex.
• Monitoring and administering EBS Concurrent managers issue
• Monitoring and Optimizing the performance of the databases and tune database server performance initialization parameters
• Understanding the requirements, complete setup and provided upgrade plan
• Upgrading individual Oracle eBiz Tech Stack Components.
• Configuration of Parallel Concurrent Processing PCP E-business suite R11,R12.
• Setup and configured Oracle 9i/10g Physical Standby database Data Guard to ensure high availability, where the standby database was used for disaster recovery as well as to offload the running of huge reports in E-business suite R11,R12.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Explain Plan 10046 , Stats pack, AWR, ADDM, ASH and monitor the database performance on daily basis.
• Administered the RAC using various utilities like SRVCTL, CRSCTL, ASMCMD and EM Database Control for R12 EBS.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Oracle support Services are utilized to troubleshoot the problems and issues.
• Performing general administration tasks using tools like OEM GC and Toad.
• Configuring TNSNAMES.ORA, LISTNER.ORA for SQL NET connectivity.
• Recover databases and clone applications Using RMAN.

Environment: Oracle 9.2.0.5, 10.2.0.4 11.1.0.7, 11.2.0.4 RHEL 5, IBM AIX 5.3, Sun Solaris 10, SQL Plus, SQL Loader, PL/SQL Developer, OEM, TOAD, MS SQL Server 2000, OBIEE 10.1.3.3/10.1.3.4

Confidential

Oracle Apps DBA

Database Size: 11 TB

Responsibilities:

• Managing day-to-day operational aspects of a project and scope.
• Patching on 11.5.X /R12 CPU, Product Family, Mini, Maintenance, One of One, Database
• Cloned E-Business RAC Database/Single and Multi Node with different combinations
• Troubleshooting Concurrent service and Concurrent manager issues
• Part of Oracle on demand internal project for speeding up cloning processes.
• SSO/OID integration with Oracle Apps R11.5.10.2
• Implementing backup strategy for database and application.
• Auto clone speed up for Pfizer E-Business suite R12.1.3 .
• Monitoring and optimizing the performance of the database.
• Analyzing and reorganizing objects e.g. tables, indexes and resolving row chaining row
• migration issues for better performance.
• Monitoring the growth of database, data files, allocating space for future requirements
• Tuning optimizations for good throughput to enhance the performance of the database by
• tuning SGA. Analyzing tables, resolving lock contention, SQL tuning using explain plan auto trace utilities.
• Capacity Planning and prepare system for future growth.
• Discover upgrade from 4i to 10g Pfizer .
• RAC Database upgrade plan for Pfizer 10g to 11g.

Environment: Environment: Oracle 9i/10g/11g, Linux, IBM AIX, 11g RAC, RMAN, 10g/9i Data Guard, OAM 11g, Oracle EBS release 11.5.10 to 12.1.3.

Confidential

Oracle Apps DBA

Database Size: 600 GB

Responsibilities:

• Daily administration of Oracle Applications R12 and 11gR1/11gR2.
• Day to day production support to 11i instances.
• Upgraded discoverer from 4i to 10g and integration with R11.5.10.2.
• Upgraded oracle database from 10gR2 to 11gR2.
• Resolved critical Concurrent manager issue after the Production EBS database upgrade.
• Applying India localization patches on EBS R11.
• Build new instances whenever business needs.
• Interface with on site team to debug performance related issues.
• Patching, Cloning for EBS R11 using Rapidclone and adpatch utilities.
• Involved in time-to-time troubleshooting Oracle Databases.
• Monitoring performance related issues and DB locks
• Production Migration MD120 for custom code.
• Part Of upgrade team which undertook RAC database upgrade from 10.2.0.4 to 11.2.0.2
• Performed iterations on Test and QA prior to upgrade

Environment: Oracle 9i/10g/11g, Linux, OEM GC, TOAD, RAC, RMAN, Data Guard, Oracle EBS release 11.5.10.2

Confidential

Oracle Apps DBA

Database Size: 500GB

Responsibilities:

• Cloning of Oracle Applications with Rapid Clone and AUTOCONFIG to Dev/Test environments.
• Installation of oracle applications Release 12 on Single Node, Two Node, multi node servers.
• Installed NLS patches for R12 and R11.
• Installed 10g and 11g discoverer and configured them with apps.
• Application tuning and monitoring concurrent manager for issues.
• Optimizing database performance by analyzing objects, generating statistics and creating indexes and views.
• Import/Export of data as per user request.
• Performing pre-patch analysis and pre-config analysis
• Patching with adpatch and use of other EBS utilities like ADADMIN, ADPATCH, ADRELINK, and ADCTRL.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs,Trace files and to work proactively on alerts for the file system and CPU issues.
• System administration activities such as creating executable, programs, request sets and attaching program to request group.
• Troubleshoot problems with web server, web listener, forms server concurrent managers, workflow and database.
• Generating tkprof Report with Explain plan for analysis
• Applying latest releases of the patches from Oracle to the instance to resolve few applications issues.
• Cloned Multi node system to single node system Rapid Clone .
• Cloning the instances from production to test, development instance to test simulate few technical challenges, coordinate with testing and development teams.

Environment: Oracle 10.2.0.4 RHEL 5, Windows XP, SQL Plus, Import/Export, TOAD, Oracle EBS

Release 12.1.1

Confidential

Oracle Apps DBA

Database Size: 400GB

Responsibilities:

• Perform server installations, configuration, upgrades, and maintenance of Data. Environment multiple Oracle Servers, distributed database systems, Oracle replication across multiple locations tuning the server environment, including the CPU and RAM, Monitoring and tuning disk I/O subsystems .
• Maintenance of installed Oracle Applications 11.5.10.2 and supporting multiple production, development and test instances of varied complexity including multiple tier, PCP and RAC environments.
• Installation, configuration, patching, administration maintenance support in two nodes Oracle Application 11.5.9.
• Upgraded Oracle applications 11.5.9 to 11.5.10 and to 11.5.10.2
• Performed cloning rapid clone and db refresh as per requirement.
• Performed patching using adpatch and localization patches using Inpatch.
• System Administration - add a user, responsibility, printer setup.
• Upgraded Oracle 9.2.0.5 database to oracle 10.2.0.4 in Test, Development and Production environment running on HP UX 11.11 PA RISC .
• Implemented 2 node RAC using RHEL 4, Oracle 10.2.0.4 and oracle clusterware using raw devices for storage VA-7110 .
• Upgraded Oracle Discoverer 4i to release 10.1.2.3 on HP UX PA RISC and Itanium based servers.
• Configured STANDBY DATAGUARD database for PROD instance on HP UNIX 11.11.
• Migrated Production and Test databases from HP UX11.11 PA RISC to HP UX 11.31 Itanium .
• Performance Tuning of Database by optimizing SQL and PL/SQL scripts, SGA tuning and tuning of initialization parameters.
• Installed oracle 10g on Linux RHEL 5 / HP UNIX 11.11 Servers.
• Adjusting database size and restricting maximum size appropriately.
• Managing data storage, including data file placement, compression and migration.
• Applying application release upgrades.
• Planning and implementing Oracle software installations, upgrades, and patches.
• Refreshing development/test databases from copies of production instance.
• Assisting in resolving common performance issues like inefficient use of SQL queries.
• User Management and gathering statistics on Database Objects.
• automatic database backup procedures using cold backup strategy as well as using Oracle Export utility
• Good understanding of database cloning refresh using Oracle export and import utility and also using cold database backup.

Environment: Oracle 9i/10g, HP-UX, Windows Server 2003, MS SQL Server 2000, Oracle EBS release 11.5.10 to 11.5.10.2