Lokesh Oracle

I possess over 4 years and 8 months of hands-on experience in Oracle PL/SQL Development and Production Support. My expertise lies in Software Development using Oracle SQL, PL/SQL and UNIX environments. Proficient in Oracle 11g, 12C and 19c, I excel in SQL and PL/SQL programming. Skilled in Optimizing performance for large datasets, leveraging PL/SQL collections and records.

Lead Engineer - HCL Technologies Ltd. - Bengaluru

(2025-01)

• Involved in end-to-end migration of databases from Oracle to PostgreSQL and MSSQL to PostgreSQL.
• Analyzed existing Oracle PL/SQL objects (tables, views, functions, triggers, packages, procedures, sequences, constraints) and converted them into equivalent PostgreSQL objects.
• Converted T-SQL/PL-SQL scripts into PostgreSQL-compliant SQL and PL/pgSQL.
• Addressed compatibility issues such as data types, functions, indexes, cursors, and exception handling.
• Designed and executed test cases for schema validation, data reconciliation, and functional verification.
• Coordinated with DBA teams, onshore/offshore developers, and business analysts to ensure timely delivery.
• Migrated databases from Oracle & MSSQL to PostgreSQL using pgAdmin.
• Actively participated in performance tuning by analyzing execution plans, optimizing SQL queries, and creating appropriate indexes.
• Developed and automated migration scripts to handle repetitive tasks, reducing manual effort and errors.
• Provided post-migration support, including defect resolution, query optimization, and performance fine-tuning in the PostgreSQL environment.
• Prepared technical documentation for migration procedures, challenges, and resolutions for future reference and knowledge sharing.
• Providing L2 Production Support for critical banking and migration applications.
• Handling incidents, service requests, and change requests using ServiceNow and JIRA.
• Performing root cause analysis (RCA) and fixing production issues within SLA timelines.
• Monitoring batch jobs, database performance, and resolving failures.
• Coordinating with business users and upstream/downstream teams for issue resolution.
• Supporting deployment activities and validating production releases.
• Writing SQL queries to troubleshoot data issues in production.
• Managing high-priority tickets (P1/P2) and ensuring quick resolution.

Software Engineer - Unosis IT Solutions - Bengaluru

(2021-09 - 2024-11)

• Engaged in the comprehensive life cycle of business application development using Oracle Relation Database Management System (RDBMS), including analysis, design, data modeling, and implementation.
• Took ownership of code modifications within Packages, Functions, and Stored Procedures to align with evolving business requirements, and crafted new Cursors to precisely retrieve relevant data.
• Conducted thorough unit testing to validate code changes against business specifications before promoting them to development and other testing environments.
• Orchestrated seamless code deployment to development servers and lower environments for testing and staging purposes through Jenkins pipeline setup.
• Facilitated end-to-end functional testing in the Test Environment by provisioning mock data, ensuring that code changes function accurately in production-like conditions prior to deployment to Production Servers.
• Implemented indexes on tables to optimize data retrieval speed and enhance overall database performance.
• Developed SQL*Loader scripts to efficiently load data into custom tables.
• Created both Materialized and regular views to fulfill diverse business requirements.
• Implemented Pragma Autonomous Transaction to mitigate the mutating problem in database triggers.
• Employed Oracle Hints for rule-based optimization to fine-tune procedures and SQL queries for maximum efficiency across various databases.
• Utilized Exception Handling extensively for error management, facilitating debugging and displaying appropriate error messages within the application.

B.E(Civil) - Civil Engineering - Mahendra Institute of Engineering and Technology (2016 - 2020)