- stored procedures
Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
Responsible for Developing and Testing of client application code related to applications.
Created and generated various Database objects like tables, views, materialized Views, Procedures, Functions, partitioning tables, indexes, sequences, synonyms using TOAD.
Involved in writing PL/SQL packages, procedures, functions and complex queries.
Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
Web Service integration with oracle, Batch process designing and Bulk data loading process creation.
Data mapping process initialized and Architect the internal data structure for reporting.
Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
Nice to have Posgres SQL