Over 12 years of professional experience in Oracle Database Administration, this includes Oracle Database (9i/10g/11g) and Fusion Middleware Products (10gAS). Worked on large production support and implementation projects with extensive hands on experience on Installation, Configuration, Upgrade (Database, Applications), Database performance/tuning, Database Cloning, Patch Application, Shell Scripting, and Proactive Health Check of the database.
Read More »
Jun 5, 2012|Database Development|$0|Completed
May 21, 2012|Database Development|$0|Completed
Implemented .Dataguard solution for more than 12 projects with Dataguard Broker configuration.
Upgraded oracle 9i to oracle 10g for more than 10 different projects .
Configure Oracle11g Gateway to communicate with SQL/SERVER database .
Apply patch set on oracle 9i and 10g . Recently applied patch set 10.2.0.4.2 on oracle 10g (10.1.0.2.0)
Established and configured Oracle 10g Application server environment on various projects to run MEDIX (ERP) application developed in 10g forms as fron-end and oracle 10g as backend..
Recover very important data which was deleted by one of a user due to human error by using FLASHBACK option .
Gain tremendous system performance by avoiding dynamic allocation.
Resolve hanging and slow performance problems by avoiding enq:TM-contention locks .
Tune up the LAB module of Medix ERP which was taking 10 minutes in searching of a single record . After tuning the system the same record can be searched within 2 seconds.
RIS (retail issue store) users complaining about the slow performance of the application. The issue was resolved by avoiding the data contention and refreshing the indexes and relocating the different db objects in different locations.
Resolve the problem when the cpu utilization getting higher and higher and approaching to 100 percnt .
Generate a script to re-create Indexes of an existing system with the help of DATA PUMPS.
Actively monitoring and involved...
Read More »