Ukesh - Production Support Engineer at Swag Tech Solutions

Proficient in writing complex SQL queries for efficient data manipulation and reporting.

Expert in developing and maintaining PL/SQL scripts to streamline application functionalities.

Skilled in using Linux environments for software deployment and maintenance tasks.

Basic understanding of AWS services and their applications in cloud computing.

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.