Shivpriya M

I’m an Oracle SQL & PL/SQL Developer with 3.5 years of experience building and supporting database solutions across Banking, Insurance, and Loan Management System (LMS) domains. I focus on delivering efficient SQL programming and backend application support with strong attention to performance, scalability, and data integrity.

In my work, I develop and maintain Oracle SQL and PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Collections. I design and performance-tune complex queries and reporting logic using techniques like execution plan analysis (EXPLAIN PLAN), indexing strategies (B-Tree, Bitmap, Function-Based Indexes), partitioning, and optimization for high-volume batch and transaction processing with Bulk Collect and FORALL.

I also own production support outcomes—defect fixing, root cause analysis (RCA), incident management, and debugging to keep systems within SLA timelines. I bring practical release/deployment experience, using tools like Jira and Git, and I collaborate closely with Business Analysts, QA teams, and developers in Agile/Scrum to ship enhancements through sprint execution, UAT, and production change requests.