5+experience as a Oracle SQL, PL/SQL developer.
Hands on with Tables, Constraints, Views, Synonyms and Sequences.
Extensive experience using Joins, Set Operators, Sub Queries, Co-Related Sub Queries, Inline Views, Indexes and Analytical Functions .
Worked with Bulk Collect and Bulk Bind to improve the performance of multi-row queries by reducing the context switching.
Experience working with cursor, parameterized cursor and ref cursor.
Worked with PLSQL collections.
Developed database objects like Procedures, Functions, Packages and Triggers.
Worked on Exception Handling Techniques. Good understanding of exception propagation.
Worked on Dynamic SQL.
Loaded data into database using SQL Loader.
Worked on External Tables for Migration.
Tuning SQL queries to improve response time using Explain Plan.
Good knowledge of Materialized View and Global Temporary Tables (GTT).
Good communication, interpersonal, analytical skills and strong ability to perform as part of a team.