SUMMARY:

Working towards a position that will enable me to use my strong organizational skills, educational background and ability to work well with colleague.

EXPERIENCE:

Confidential

Associate Consultant

Responsibilities:

• Have improved the performance of the SQL query based on AWR and ADDR reports.
• Have scheduled jobs in database and UNIX level for monitoring activities.
• Have configured Oracle ERP R11i and R12 for multi node shared file system.
• Troubleshooting, Load Balancing, Clustering, Deploying Applications, Performance Tuning and Maintenance WebLogic domain and application servers.
• Create, configure and tune WebLogic domains/applications for performance.
• Have installed, patched, upgraded and cloned Database version 11g along with Oracle ERP and other applications. WebLogic patching, administrating, AD utilities and ADOP and compilation of Java files.
• Have backup the database in different way using RMAN, Data pump and flash back recovery mode.
• Have configured Oracle cluster RAC Database, Dataguard, Goldengate and OEM setup.

Confidential

Responsibilities:

• Monitoring and diagnosing database performance through monitoring of alerts
• Apply and analysis Patch for database and Applications including mini pack and one - off pack
• Performance tuning of all long running sql and pl/sql query for any application program.
• Index creations, function, packages and stored procedure design for database
• Refreshing Materialized view and DB link for improving the performance.

Confidential

Responsibilities:

• Installation and maintenance of Oracle Products on LINUX platforms
• Monitor alert logs, space and object growth related problems in the databases.
• Planning and managing database backups. Analysis of trace and log files to determine and resolve potential problem areas.
• Monitored and diagnosed database performance through monitoring of alert files, trace files.
• Patch analysis for database and applications patches including mini patches, family packs, and one-of patches.
• Performed patch analysis for patches involving lot of pre-requisites.
• Installed OEM and Configured OEM for database, middleware, applications and host
• Installed 11g database Version R2c, Installed Grid Infrastructure
• Applied patches using OPatch
• Performance tuning of long running job based on the AWR and ADDM reports.
• Prepared and analyzed AWR and ADDM report on top activities, wait events and I/O contention.
• Deleting archive logs using RMAN and performing backup’s using RMAN
• Performing logical backup’s using exports and imports
• Scheduling DBMS jobs and Sizing Flash recovery area
• Adding disks to disk group in Automatic Storage Management.
• Deployment and troubleshooting of JAR, WAR, and EAR files in domain and clustered environments.
• Tuning JVM heap size to maximize the number of clients accessing the applications.
• Analyzing the Log Files, Thread Dumps, JVM Dumps, Exception Stack Traces of managed servers and admin servers.

Confidential

Senior Specialist

Responsibilities:

• Have refreshed Schema from production to non-production
• Have configured OEM and discovered database and applied Monitoring templates
• Have refreshed Non-production EBS R12.1.3 from Production
• Have built complete EBS R12.1.3 using Rapid clone
• Performance tuning of long running job based on the AWR and ADDM reports.
• Prepared and analyzed AWR and ADDM report on top activities, wait events and I/O contention.

Confidential

Associate

Responsibilities:

• Have applied RPC5 recommended patch collection of patch using adpatch
• Have installed oracle database 12c along with RAC and dataguard setup.
• Have created automation script for database and Application cloning using Unix Shell Scripting.
• Performance tuning of Web Logic server with respect to heap, threads and connection pools.
• Confidential Connection Pool setup for Oracle database.
• Monitoring WebLogic server health and security.
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console.
• Managing and Monitoring the JVM Performance by adjusting WebLogic heap size and garbage collection parameters.