Now you can Instantly Chat with Pavana!
Skills
Positions
Portfolio Projects
Description
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..
Show More Show LessDescription
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.
Description
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.