Open to opportunities

Kotakonda Lokesh

@kotakondalokesh

Message

Oracle PL/SQL Developer delivering optimized SQL, ETL, and production support.

India

Message

What I'm looking for

I’m looking for a challenging Oracle PL/SQL Developer role where I can leverage 6+ years in SQL/PLSQL, ETL, and performance tuning to build scalable database solutions, improve efficiency, and deliver reliable production outcomes.

I’m an Oracle PL/SQL Developer and Production Support Engineer with 6+ years of experience in SQL, PL/SQL development, ETL, and data warehousing. I specialize in designing and delivering robust database objects—stored procedures, functions, packages, triggers, views, indexes, sequences, and synonyms—to meet complex business requirements.

I’m hands-on with performance tuning and query optimization using execution plans, indexing strategies, and advanced PL/SQL techniques like Bulk Collect and FORALL to efficiently process large volumes of data. I also manage end-to-end ETL workflows—data extraction, transformation, and loading—using SQL*Loader and PL/SQL to ensure data accuracy and integrity across systems.

In production, I take ownership of troubleshooting, debugging, and incident resolution while meeting SLA-driven support expectations. I perform incident analysis and Root Cause Analysis (RCA), execute impact analysis for change requests, validate database objects post-deployment, and use automated SQL and UNIX shell scripting for monitoring and batch job validation—continuously improving system stability and performance in Agile/Scrum environments.

Experience

Work history, roles, and key accomplishments

Current

PL/SQL Production Support

Current

Intechfy Solutions Pvt Ltd

Jun 2025 - Present (1 year)

Provided L2/L3 Oracle PL/SQL production support for a healthcare program, resolving high-volume job failures and incidents while maintaining strict SLA compliance. Automated monitoring and validation using SQL and UNIX shell scripting and produced RCA reports to improve system reliability.

Oracle PL SQL SQL Shell Scripting Data Validation Batch Job Monitoring Database Change Impact Analysis

Sr PL/SQL Developer

Intechfy Solutions Pvt Ltd

Nov 2023 - Jun 2025 (1 year 7 months)

Developed and maintained PL/SQL and SQL components for a web-based enterprise lending platform, supporting end-to-end monthly data loads and validations for accurate financial processing. Optimized batch workflows using UNIX scripting, SQL*Loader, and import utilities, and troubleshot database/performance issues across environments.

Oracle PL SQL SQL Data Loading SQL*Loader Batch Job Monitoring Performance Optimization Data Validation

PL/SQL Developer

Intechfy Solutions Pvt Ltd

Jun 2023 - Oct 2023 (4 months)

Built and supported PL/SQL procedures, functions, packages, and triggers for high-volume banking transaction processing. Improved performance by 30% through index creation and SQL/query optimization, while debugging production defects and coordinating JIRA-based issue resolution.

Oracle PL SQL SQL Query Optimization Indexing Stored Procedures Database Triggers Batch Job Troubleshooting

PL/SQL Developer

Intechfy Solutions Pvt Ltd

Mar 2020 - May 2023 (3 years 2 months)

Developed and maintained an Oracle data warehouse for retail analytics, implementing ETL pipelines to extract, transform, and load large datasets. Reduced batch job execution time by 40% using PL/SQL performance tuning (Bulk Collect/FORALL, explain plan, optimizer hints) and optimized query execution.

Oracle PL SQL SQL ETL SQL*Loader FORALL Performance Tuning Explain Plan Auto Trace Data Warehouse