PLSQL Developer Area(s) of responsibility Experienced PL/SQL Developer with over 6 years of comprehensive expertise in SQL, PL/SQL, Shell scripting, and system analysis. Proven ability to design, develop, analyze, and optimize complex SQL queries and PL/SQL code, with a focus on performance tuning and effective database interactions. Adept at understanding and integrating with Oracle EBS functionalities and supply chain management systems.
Demonstrates strong analytical, problem-solving, and communication skills, with a flexible attitude towards rotational night shifts and continuous learning.
Technical
Skills SQL & PL/SQL (Expert Level): Development and analysis of complex, analytical SQL queries Indexing strategies for performance optimization Advanced PL/SQL features: collections, cursors, ref cursors, exception handling, dynamic SQL, SQL Loader,
and file handling Experience with Cursor and Ref Cursor management Package, Procedure, and Function development Writing high-performance SQL and PL/SQL code Performance tuning of SQL and PL/SQL operations Understanding and working with Oracle EBS functionalities Shell Scripting (Intermediate Level): File handling, loops, exception handling, parameter passing Developing scripts for automation and integration Connecting to Oracle databases and executing procedures/functions Overall System & Code Analysis: Systematic analysis of existing code and integrations Development of new integrations based on functional requirements Ability to quickly understand current architecture and optimize processes Experience Level Senior Level