Around 5 Years of IT Experience in Oracle Development and Production support including analysis, modelling, design, coding, testing, administration, maintenance of oracle database systems.Developed Database objects including Tables, Clusters, Index, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problem. Sound understanding of DML, DDL, Joins, union, union all in SQL.Experience in Advanced PLSQL Concepts like Multi table insert, PLSQL Table, Cursors, Joins, V Arrays, Record types and Dynamic SQL for DML Operations for better performance.Experience in Modifying SQL Queries as per data needed for Retrieval.Skilled in analyzing production issues and providing prompt solutions based on ticket priority. Proficient in debugging SQL errors and optimizing queries for better performance. Knowledge of DevOps for creating releases and handling deployment for production issues. Working experience with Arcos. Experience in EOD (End of Day) and EOM (End of Month) batch processing. Strong analytical and problem solving abilities. Dedicated to providing 24/7 production support to clients.Experience in retrieving data from external data files and loading into oracle table using tools like UTL File, SQL * Loader and external tables.Experience in database development in Oracle PLSQL, Develop packages, procedures, functions, triggers and complex SQL, Materialized view, analytical functions, partitioning, indexes, procedure, function and Cursors.

Involved in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers, Packages and Written complex SQL (Sub queries and Join conditions) in PL/SQL. Troubleshoot and debug system data errors. Proficient knowledge in performance tuning and knowledge to work according to the Work Request and Change Request.