• Analyzing and tuning SQL query using explain plan.

• Administering the database security, creating users, Gathering roles, privileges to users, extending the database storage capacity.

• Switch over and Switch back plan prepared for the Dataguard testing.

Am supporting various customers and differrent countries.

Supporting for PERU , Chile Regions.

Supporting the UCAL-University, INTERCORP, RIMAC, PONTIFICIA UNIVERSIDAD, ==> PERU Region Customers

HITES, SMU, FASHION PARK, PROVIDA ==> CHILE Region Customers.

Am supporting for University (Education Based), Financial related customers..

The project is aimed to provide complete database support using the Premia as an Enterprise-class insurance Management system that supports Underwriting, Claims and Re-insurance, backed by Comprehensive financial accounting, reporting and analysis.

I supported various L1 / L2 Activities.

• Installation and configuration of the Oracle Servers.

• Tuning of DB objects like tables, indexes (Analyzing of objects rows).

• Generating traces/ explain plan for longer queries/ batches using tools like trace TKPROF & Explain Plan.

• Troubleshooting of production database issues, monitoring alert logs.

• Prepared shell scripts for instance efficiency and CPU usage.

• Replicating Standby Database with Live Database

• Database Migration on 10g from Hitachi storage to EMC storage for development

• Database Upgradation from 10g (10.2.0.2.0) to 10g (10.2.0.5.0).

• Performing Backup and deciding Backup Strategy.

• Applying the weekly application releases to Testing and Production databases.

• Tuning of long running SQL queries using AWR or TOAD.

• Worked with Oracle Support extensively to resolve and identify patches.

• Backup and Recovery including RMAN based backup and recovery.

• Prepared easily and automatically from production backup.

• Provide support for server Upgradation and SAN migration

• Merged database schema's from one database to another database.

• Database Cloning using RMAN backup.

Salem Steel Plant, a special steels unit of Steel Authority of India Ltd., pioneered the supply of wider width stainless steel sheets / coils in India. The plant can produce austenitic, ferritic, martensitic and low-nickel stainless steel in the form of coils and sheets with an installed capacity of 70,000 tonnes / year in Cold Rolling Mill and 1,86,000 tonnes / year in Hot Rolling Mill. In addition, the plant has country's first top-of-the-line stainless steel blanking facility with a capacity of 3,600 tonnes / year of coin blanks and utility blanks / circles.

• Installation and configuration of the Oracle Servers.

• Creation and maintenance of different database entity included managing Tablespaces and organizing datafiles on servers.

• Tuning of DB objects like tables, indexes (Analyzing of objects rows).

• Prepared shell scripts for instance efficiency and CPU usage.

• Prepared easily and automatically from production backup.

• Applying the weekly application releases to Testing and UAT databases.

• Performing Backup and deciding Backup Strategy.

• Administrating database, managing users, profiles, Tablespaces, schema, rollback Segments.

• Establishing client server database connectivity.