PL/SQL 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 efficient 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