PROFESSIONAL SUMMARY:

• Having 9 Years of experience as an expert Oracle APPS DBA on Linux Red Hat, SUN/Solaris, IBM/AIX, HP - UX and Windows supporting Oracle Databases on RAC and non RAC versions from 11gR2, 10g, 9i, and Oracle Applications versions latest Release of Oracle Applications R12 (12.1.3), R12(12.2.1&12.2.3)11.5.10.2, Exadata, Web logic.
• Experienced in Exadata Database machines X-2, X3.
•  Expertise in ORACLE 11g upgrades and Cluster ware, RAC configuration in ASM platform.
• Exposure to Exadata platform migration with respect to core DBA support.
• Highly experienced in Oracle Applications E-Business Suite (EBS) Applications 11i (ERP) and R12 Running on Exadata DB & Exalogic MT, Installations , configuration, Cloning, Security, Patching, Upgrades and Maintenance using AD and other utilities.
• Excellent troubleshooting skills on RAC, Cluster ware.
• Excellent working experience in administrating Oracle 9i/10g/11g databases, which includes database Designing, creation, configuration, development, security and backup/recovery.
• Installed and supported Oracle Applications ERP servers on Single and Multi-node Configured and supported Oracle 11g and Real Applications Clusters (RAC) on EXADATA
• Experience with setup and configuration of Oracle Data Guard / logical Standby and physical Standby Databases with Oracle Applications 11.5.10 & R12
• Monitored and optimized the Performance of the Exadata database, Tuning Management, capacity planning , created New technologies and SQL tuning using utilities/tools like explain Plan, TKPROF, Auto trace, AWR Reports, STATSPACK, OEM, SQLTXPLAIN.
• Database upgrade and migration experience on various versions of Oracle Database ( 9i to 10g & 10g to 11g)
• Oracle Server Installations/Upgrades, Space Management, Capacity Planning, Backup & Recovery using Manual and RMAN , Disaster Recovery, Database Performance Tuning , Memory Tuning , Security Administration, Data Warehousing , Multithread Servers, Oracle Standby Server.
• Install/setup/configure Oracle Enterprise Manager (OEM) tools for monitoring of Oracle Database &

TECHNICAL SKILLS:

RDBMS: Oracle 9i, 10g, 11g.

RDBMS Tools : Oracle Enterprise Manager (OEM), SQL*Loader, Oracle Schema Manager, RMAN, SQL Trace, TKPROF, Stats Pack, TOAD, SQL Navigator

Applications: Oracle E-Business Suite 11i (11.5.10, 11.5.10.2) / R12 (12.1, 12.2.x) Web logic, SOA.

Operating System: Sun Solaris 2.8, Solaris 10, HP-UX, Windows NT4.0/2000, Linux RH X.0, IBM AIX .

Hardware : Sun Sparc v880, Exadata X2, X3.

Languages : SQL*Plus, PL/SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Implementation and project services

Responsibilities:

• On call support for Oracle 11i, R12 database and applications
• Handling the maintenance of Oracle Apps11i and R12 (single/multi node) on Linux platforms.
• Performing Maintenance activities using AD-Utilities
• Applied latest Oracle RUP patch for our customer environment includes database, E-Business Suite Payroll system
• Checking peregrine tickets and process them based on the priority
• Experienced on application patching, NLS patches, DB patching.
• Handling OEM alerts for all the Environments
• Checking RMAN backs ups which are scheduled through Crontab.
• Monitoring OEM for Locks and DB growth
• Data base migration from Physical to VM servers.
• Standby Build, DG broker setup and failover testing.
• Large Schema migration across database.
• Troubles shooting 11g R2 prod Instance with respect to cluster ware and RAC.
• Communicating within teams - DBA, Support and Infrastructure, for finding the root Cause.
• Providing RCAs Root Cause Analysis and relevant reports.
• Steps to be taken to avoid reoccurrence of issues.
• Giving ad hoc support to the R12 project team.

Exadata Implementation and production support

Responsibilities:

• On call support for Oracle 11i, R12 Exadata database and applications.
• Install/setup/configure maintain cluster ware software and RAC, ASM instances.
• Handling the maintenance of Oracle Apps11i and R12.1 (single/multi node) on Exadata platforms.
• Applied latest Bundle patches in Exadata databases.
• Implementing Exdata best practice & PA validations.
• Maintained databases running in EXADATA X2, X3.
• Maintained the Exadata storage cells.
• Implemented Smart scans, Flashe Cashe&HCC.
• Implemented oracle best practices with respect to Exadata.
• Running exacheck reports.
• ASM, RAC instance maintenance and patching.
• Checking peregrine tickets and process them based on the priority
• Experienced on application patching, NLS patches, DB patching.
• Administration of RAC prod instance running in 11g r2 cluster with ASM.
• Checking peregrine tickets and process them based on the priority
• Handling OEM &ILOM alerts for all the Environments
• Using RMAN for backup and recovery. RMAN Cloning and Incremental backups.
• Proficient in using AWR, ADDM, Stats pack for performance tuning purpose.
• Logical design of tables, identification and creation of indexes on key columns
• Partitioning on huge tables to improve performance
• Extensive Experience in ASM configuration and support.
• Weekly Production maintenance activities.
• Observing production profile, identifying potential threats of performance on day to Day basis.
• Growth monitoring, CPU and memory utilization reporting. Forecasting requirements.
• Scheduling required purge routines and housekeeping interface table data with the Help of technical support teams.
• Documenting issues, operational procedures, OATs for projects, SOPs etc.
• Training and mentoring team members.
• Logical Standby set up and administration.
• 11g RAC implementation with ASM, Datagaurd.
• 24X7 Production/On call support for Oracle Applications Database Administration.
• Sizing init parameters.
• Documenting issues, operational procedures, OATs for projects, SOPs etc.
• Creation of new RAC Instances for TEST & UAT.
• Accountable for quick workarounds. Also provide solution wherever feasible.
• Communicating within teams - DBA, Support and Infrastructure, for finding the root Cause.
• Providing RCAs Root Cause Analysis and relevant reports.

Confidential,

Production Support,JAPAN

Responsibilities:

• Installing, configuring, upgrading and patching of Oracle server software
• Handling the maintenance of Oracle Apps11i and R12 (single/multi node) on Linux platforms.
• Managing databases in Production, Development, Acceptance and Load test environments.
• Creating and managing users, profiles and roles.
• Administration of database objects, including tables, indexes, views, sequences, packages and procedures.
• Alone Implemented & Maintaining 11g four node RAC in production.
• Supported development teams in designing and implementing different database objects.
• Managing different configuration files and resolving connectivity issues.
• Automated archiving activity in production databases using scripts.
• Tuning the bad queries and helping application teams in query tuning.
• Database links were created to access the data from remote databases.
• Monitoring the database locks and distributed transaction related issues.
• RAC database and cluster administration.
• Migrated databases from Non ASM to ASM Using various methods.
• Implemented Partitioning on huge tables to improve the performance.
• Reorganization of data in database to avoid fragmentation, row chaining and row migration.
• Generating and analyzing Stats pack/AWR/ADDM reports as on when required.
• Upgrading and patching the databases.
• Performing regular database refresh tasks from Production to Dev/ Acc.
• Handling complete and incomplete recovery in case of database failure.

Confidential,

Oracle Apps DBA Administrator,NY

Responsibilities :

• Work on AD utilities (example: ADADMIN,ADPATCH, ADRELINK, AUTOCONFIG etc)
• Patching - in both application as well as database.
• Installation experience 11i on HP-UNIX environments.
• Cloning Applications environment & Database refresh on a monthly basis.
• Proactive Health check and troubleshooting capabilities in application and database.
• Relink /rebuild /regenerate /recompile all Oracle Apps objects as required.
• Responsible for backup & Recovery by using predefined RMAN & HOT BACKUP scripts.
• TAR support for critical issues with oracle for getting exact solution within times.
• 24/7 customer support in monitoring production and development environments Table space monitoring in RAW & COOKED file systems daily basis.
• Tracing and generating formatted output for oracle application support project issues.
• Setup the custom schemas basing on user requirements in application level.
• Monitoring table space usage and redo log growth especially monthly closing times.
• Managed ticket queues to provide responsive support to customers for operational issues.
• Monitoring and Trouble Shooting Performance issues occurred in 24/7 environments at user level as well as system level.
• Month end Closing support and Supporting Technical team/ or development team in code migration.
• Changing Apps & Module password at outage times.
• Experience with maintaining, monitoring and administration of physical database on windows.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes
• Checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Manage seismic data annotations from workspaces during the interpretation and validation process.
• Setup a crontab for Production Environment alerts related to TS issues, OS level space locking issues etc.
• Mobile server configuration for Production( 3 tier ), Development ( 2 tier ) ,test instances.
• Troubleshot Concurrent service and Concurrent manager issues
• Sync Split activity (hot and cold) through EMC Time Finder using BCV's.
• Used RMAN for backup and recovery of database.
• Mentored the in-house DBA to assume higher levels of responsibility.