PLSQL Developer

Job description

Country/Region: IN Requisition ID: 37225 Work Model: Position Type: Salary Range: Location: INDIA - HYDERABAD - BIRLASOFT OFFICE # **Title:** **PLSQL Developer** Description: ## **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