Experience with various technologies such as Oracle, Structured Query Language(SQL), Procedural Language and Structured Query Language (PL/SQL), Oracle Application Express (APEX), Oracle Forms (11g/12g) and Oracle Reports (11g/12g).
Extensive experience in writing/debugging Oracle Back-end PL/SQL development by writing Packages, Stored Procedures, Functions and Triggers. Strong knowledge in using Oracle built-in packages, Cursor management and Exception handling.
Experienced in creating and maintaining Database Objects like Tables, Views and Materialized views, Indexes, Constraints, Sequences, Synonyms and Database Links and Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic.
Experienced in Tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds).
Experienced in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan.