Ukesh

Production Support Engineer

Developed and maintained PL/SQL procedures, functions, packages, and triggers to support application requirements.. Created and optimized SQL queries for data retrieval, transformation, and reporting, improving query performance using EXPLAIN PLAN, indexes, and Oracle hints.. Designed and managed database objects including tables, views, indexes, sequences, and materialized views.. Worked with CLOB/BLOB data types, Ref Cursors, partitioned tables, and collections for complex data handling.. Performed data loading from flat files into Oracle tables using SQL*Loader and external tables.. Applied bulk binding and bulk collections to enhance performance and reduce context switching between SQL and PL/SQL engines.. Handled exception management for improved debugging and error tracking in applications.. Collaborated with developers to troubleshoot and enhance existing PL/SQL packages, reducing processing time through code optimization.. Participated in incident analysis and defect resolution using JIRA for defect tracking and reporting.. Conducted unit testing of PL/SQL packages, procedures, and triggers to ensure quality deliverables.. Supported production deployments, monitored batch jobs via Autosys, and analyzed logs for root cause identification.. Worked in an Agile environment, attending daily scrum meetings and contributing to sprint deliverables.