Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.Experience in SQL performance tuning using Cost-Based Optimization (CBO).Expertise in Dynamic SQL, Collections and Exception handling.Worked extensively on Ref Cursor, External Tables and Collections.Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.Partitioned large Tables using range partition technique.Loaded Data into Oracle Tables using SQL Loader.Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.Developed materialized views for data replication in distributed environments.Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).Good knowledge on logical and physical Data Modeling using normalizing Techniques.Strong experience in Data warehouse concepts, ETL.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).