Senior Oracle PL/SQL Developer with 9+ Years Experience

ANKIT PATHAK

Senior Oracle PL/SQL Developer

PROFESSIONAL SUMMARY

Oracle PL/SQL Developer with 9+ years of experience across Banking, Financial, Recruitment, and Supply Chain domains, specializing in performance tuning, large-scale database optimization, and high-performance PL/SQL development TECHNICAL SKILLS

Database: Oracle 19c, PL/SQL, SQL,UNIX

Tools: PL/SQL Developer, Putty, GIT, JIRA, Beyond Compare, SVN, Eclipse, Win SCP, Oracle SQL Developer

Scripting & Languages: Unix Shell Scripting, Core Java,JDBC PROFESSIONAL EXPERIENCE

Deloitte USI Senior Database Developer Oct 2025–Present Dell Technologies Order Management Enterprise Supply Chain

Designed and implemented Range Partitioned Tables, reducing query execution time by 30-50 percent.

Analyzed AWR reports to optimize long-running SQL queries.

Developed and automated SQL*Loader-based data pipelines on UNIX for data ingestion and high-volume exports.

Utilized Bulk Collect and FORALL for high-performance bulk processing via collections.

IRIS Software Senior Database Developer

Bank of Montreal Jan 2024–Oct 2025

Designed PL/SQL procedures using REF CURSORS to stream result sets to Java (JDBC).

Implemented exception handling with error logging mechanisms, capturing failure details in audit tables.

Designed views and materialized views for fast retrieval of data.

Implemented audit triggers for data tracking and integrity. Citibank KYC Project Oct 2022–Dec 2023

Scheduled database jobs using DBMS_SCHEDULER.

+91-700*******

************@*****.***

LinkedIn

EDUCATION

B.Tech [CSE]

2011–2015

Aggregate -70% Marks

STRENGTHS

Problem Solving

Adaptability

Collaboration

Time Management

Critical Thinking

Handling Pressure

Leadership

Designed views and materialized views for optimized data retrieval, and developed PL/SQL packages to encapsulate business logic.

Wrote complex SQL queries using joins, subqueries, and correlated subqueries to extract critical data

Enhanced query performance by analyzing and optimizing execution plans using TKPROF. Tata Consultancy Services Database Developer March 2016– Sept 2022 Global Recruitment System

Created and maintained a wide range of database objects including tables, views, sequences, synonyms, stored procedures, functions, packages, cursors, ref cursors, collections, and triggers as per evolving business needs.

Led Level 3 production support team of 4 people, including error log monitoring, performance tuning, and timely issue resolution.

Worked with tools like Beyond Compare, Tortoise SVN and GIT for version control and collaborated closely with deployment and testing teams.

Worked with shell scripting for automation, contributed to ETL processes and participated in code debugging using PL/SQL Developer.

Coordinated with deployment, testing, and migration teams to streamline development processes and facilitate smooth database migrations and server patching.

Contact this candidate