Strong Experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle 10G, 11G, 12C and 19C
Expertise in SQL and PL/SQL programming, developing complex code units.
Experience in data migration/conversation using SQL*Loader.
Experience in Data Migration using import and export.
Expertise in creating the indexes on tables and partitioning the table for SQL tuning purposes.
Responsible for performance-tuning activities in the project.
Creating complex views, materialized views on multiple tables as per customer requirements.
Use PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass updates as a performance improvement process.
Ability to write complex SQL queries for reporting purposes.
Support the users of the application by using multiple SQL and PL SQL techniques.
Providing technical assistance, problem resolution and troubleshooting support.
Should have good experience in Client Interaction and Presentation Skills.