Shantanu Koli

Application Support Engineer | Oracle PL/SQL · SQL Developer

Talent

PuneMember since July 2, 2026

Stored ProceduresFunctionsPackagesTriggersCursorsException HandlingViewsConstraintsIndexingExecution Plan AnalysisQuery OptimizationOracle 19cProduction SupportTechnical Documentation

Hire this person

Send a job offer directly to this candidate

Stored ProceduresFunctionsPackagesTriggersCursors

About

Highly motivated SQL & PL/SQL Developer with a robust foundation in Oracle Database Architecture (11g/12c/19c), query optimization, and transaction-driven systems. Experienced in designing relational database schemas and implementing business logic through stored procedures, packages, triggers, functions, and cursors. Proven ability to develop, optimize, troubleshoot, and maintain database applications while ensuring data integrity and performance.

Strong analytical thinking, documentation, and problem-solving skills with experience supporting business-critical database systems.

Experience

SQL Developer - Code Icons Technology - Pune

(2025-02 - 2026-05)

Developed and maintained Oracle PL/SQL objects including Stored Procedures, Functions, Packages, Triggers, Views, and Cursors.
Created and optimized SQL queries for reporting, validation, and business requirements; analyzed execution plans and implemented indexing strategies to improve query performance.
Performed database debugging, troubleshooting, and issue resolution; participated in deployment, testing, and production support activities.
Collaborated with development and business teams to implement database solutions; maintained technical documentation and ensured data integrity through constraints, transactions, and exception handling.