Experience wif Designing and Optimizing underlying SAN architectures, RAID and disk configurations.

Extensive experience wif performance tuning in large data warehouse environments wif billions of rows.

Experience wif SQL Server Clustering, Virtualization, Load distribution and High availability solutions.

Extensive experience wif Capacity planning, Database design, Failover mechanisms.

Experience as a Techno Functional Consultant wif prior experience in the capacity of a BA/PM.

Involved in all stages of Software Development Life Cycle including Analysis, Design, Development, Documentation, Testing, Implementation and Support.

Expert in creating process models, data models, ER-diagrams, data Flow diagrams using Erwin and Rational Rose.

Extensive Experience wif Performance Tuning for Oracle RDBMS using Explain Plan and TKPROF along wif Optimizer Hints.

Expertise in creating DDL, DML and Transaction queries in SQL.

Involved in Table Partitioning, Optimizer hints and Query optimization.

Created Global Temporary Tables, Partition Tables and used it in various procedures.

Migrated Data from sources to the required target using SQL*Loader.

Involved in Logical & Physical Design, Backup, and Restore, Data Integration and DTS (Data Transformation Services) and creating Database Objects.

Validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle.

Extensive Experience wif SQL Server ETL tools SSIS and DTS.

Extensive experience in developing SQL*Loader control programs and PL/SQL.

Excellent SQL, PL/SQL and T - SQL skills and expertise in using TOAD and SQL Navigator.

Extensive experience in development of Stored Procedures, Functions, Packages and Triggers both at the backend and at the Application level.

Extensive experience in Bulk and Batch processing in SQL Server and Oracle Databases.

Senior Database professional wif 9 years of experience in Oracle and SQL Server Development (PL/SQL & SQL).

Toad for oracle cost