Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Experience in numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, Testing and Implementation.
Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.
Strong Knowledge on Materialized Views and Dynamic SQL.
Expertise on Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.