Venkatesh M - Oracle Developer - Oracle Cloud Computing

Summary

Results-driven PL/SQL Developer with over 8.5 years of experience in designing, developing, and supporting Oracle database applications within enterprise environments. Proven track record in writing efficient PL/SQL code, developing complex stored procedures, and optimizing SQL queries to enhance performance. Expertise includes end-to-end development and L2/L3 production support, encompassing job monitoring, incident management, and root cause analysis. Recognized for strong problem-solving abilities, commitment to code quality, and effective cross-functional collaboration in Agile and ITIL-based settings.

Overview

8

years of professional experience

4

Languages

Work History

Senior Software Engineer

Oracle Cloud Computing

MYSORE

09.2021 - Current

Client: Mahindra & Mahindra.
Designed and developed complex PL/SQL packages, procedures, functions, and triggers for high-volume enterprise applications.
Designed and developed with Oracle Report and Jasper Report, also based on client business requirements.
Wrote and optimized complex SQL queries for reporting, data validation, and business intelligence.
Developed reusable code libraries and standardized naming conventions across modules.
Improved query execution time by up to 60% through indexing, query refactoring, and partitioning strategies.
Led L2/L3 support for critical production systems, ensuring 24/7 availability, and fast issue resolution.
Analyzed production incidents, performed root cause analysis, and implemented permanent fixes.
Maintaining a detailed study of the process changes by getting in touch with the Product Developers and sharing the knowledge with the team.
Analyzing stored procedures to identify the reason for errors, and writing the SQL queries to update the existing details and to retrieve from the DB as per customer requirements.
Data extraction from multiple databases and provision to the business team for analysis.
Coordinating with the APPS and DB teams for application slowness issues and table lock issues.
Fixing the bugs on time, and supporting the team to move with a smooth workflow.

Education

Computer Science & Bachelor Of Engineering - Computer Science

JNTU

Anantapur

04.2001 -

Skills

Programming languages: Core Java, HTML, CSS with PYTHON

Databases: Oracle and SQL,PLSQL,MySQL, Postgresql

Operating Systems: Linux, Unix and Windows Server 2012

Tools: Informatics ETL,Oracle

Accomplishments

1. Performance Engineering (The "Efficiency" Expert)

The 60% Win: "Successfully re-engineered legacy PL/SQL code and implemented Table Partitioning, resulting in a 60% reduction in query execution time for a multi-terabyte data warehouse.

3. Reliability & Support (The "Guardian")

Uptime Excellence: "Maintained 99.9% system availability for mission-critical financial applications by establishing proactive monitoring scripts and rapid L3 support protocols."
Risk Mitigation: "Reduced recurring production incidents by 40% through deep-dive Root Cause Analysis (RCA) and the deployment of permanent architectural fixes.

Software

PL/SQL, UNIX, PostgreSQL, My SQL

Core Java, Python

Power BI, Oracle Apps

Oracle(apps) Reports with Jasper Reports

Senior Database Developer with strong expertise in PL/SQL and growing proficiency in Data Engineering principles, including ETL pipeline design, data warehousing, and performance tuning for large-scale datasets

Interests

Learning New Languages/Skills: Shows a growth mindset, adaptability, and a desire for continuous improvement

Music

Timeline