Design PL/SQL procedures & functions, packages, triggers and other database objects to support various business functionalities.
Worked on patching the fixes to production databases (Releasing the new version to production).
Worked on resolving complex issues related to Oracle Database, which was out of the scope. Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and AUTOTRACE.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.