sharath g
Oracle SQL / PL/SQL Developer
About
Results-driven Oracle PL/SQL Developer with 4+ years of experience designing, developing, and optimizing SQL and PL/SQL solutions for high-volume banking and e-commerce platforms. Proven track record of improving query performance by up to 60%, sustaining 98%+ SLA compliance in production support, and delivering reliable ETL pipelines and database solutions for mission-critical systems. Hands-on expertise in stored procedures, functions, packages, triggers, cursors, exception handling, performance tuning, and Oracle database design, gained across Booking.com's hotel reservation platform and RAKBANK's retail and corporate banking applications.
Skills & Expertise
No skills listed yet
Work Experience
Senior Software Engineer
Randstad
Jul 2024 - Present
Developed and maintained Oracle SQL queries, PL/SQL stored procedures, functions, packages, triggers, and database objects supporting hotel reservations, room availability, pricing, payment processing, and booking lifecycle management. Designed and optimized complex SQL queries using joins, common table expressions (CTEs), analytical functions, and execution plans, improving query response time by 40-60%. Performed SQL and PL/SQL performance tuning through indexing, query optimization, partitioning, and execution plan analysis for high-volume booking transactions. Developed and supported ETL processes for loading, transforming, and validating hotel, customer, inventory, and booking data from multiple source systems while maintaining data integrity and consistency. Provided L2/L3 production support, performed root cause analysis (RCA), resolved critical database incidents, and maintained 98%+ SLA compliance with reduced mean time to resolution (MTTR). Implemented transaction management, exception handling, and data validation in PL/SQL programs to support reliable and accurate booking and payment processing.
Oracle SQL/PLSQL Developer
RSK Tech Systems Pvt Ltd
Jan 2023 - Jun 2024
Developed Oracle PL/SQL stored procedures, functions, packages, triggers, and cursors to automate banking operations including customer data processing, transaction validation, and regulatory reporting. Optimized complex SQL queries for banking transactions and reporting using query tuning, indexing strategies, and execution plan analysis to improve database performance. Redesigned and optimized database schemas to support retail and corporate banking applications, improving data storage efficiency and transaction processing. Implemented indexing strategies, query optimization, and PL/SQL tuning for high-volume banking transactions and data retrieval. Designed and supported ETL workflows and data warehousing processes for data integration, transformation, validation, and reporting. Prepared technical documentation for database objects, ETL workflows, deployment activities, and production support procedures. Automated database and ETL tasks using Unix/Linux and Shell Scripting to support deployment activities. Resolved database performance issues through SQL tuning, indexing, and PL/SQL optimization, contributing to reduced system downtime.
Technical Support Engineer
SHI Solutions Ind Ltd
Mar 2022 - Jan 2023
Provided L2 production support for core banking applications, ensuring application availability and timely resolution of production incidents within SLA. Monitored application health, database performance, batch jobs, and APIs using Kibana, Grafana, and monitoring dashboards to proactively identify issues. Investigated and resolved P1, P2, and P3 incidents related to fund transfers, payment failures, account updates, loan processing, and customer transactions. Executed Oracle SQL queries to validate customer records, account balances, and transaction history, and troubleshoot data-related production issues. Validated REST APIs using Postman, analyzed HTTP response codes, and verified request and response payloads during incident troubleshooting.
Education
Bachelor of Science (B.Sc.) - Kuvempu University
- 2019 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Open to Relocation
