PL/SQL Developer

JD for PL Sql Developer

Key Responsibilities

 Code Development: Write clean, optimized SQL and PL/SQL code.

 Database Objects: Construct database blocks like procedures, functions,

packages, and triggers.

 Performance Tuning: Analyze execution plans to optimize complex queries.

 Data Automation: Implement cursors, collections, and bulk bind techniques.

 Error Management: Build robust exception handling routines across

subprograms.

 Troubleshooting: Debug production issues and resolve runtime database

faults.

 Collaboration: Assist front-end developers with seamless data integration.

Technical Requirements

 Core Database: Strong knowledge of Oracle Database concepts and

architecture.

 Procedural Language: Proven skills in PL/SQL programming constructs.

 Query Components: Expertise in advanced joins, subqueries, and indexing.

 Scripting Skills: Basic proficiency with Unix/Linux shell scripting.

 Familiar Tooling: Experience using Oracle SQL Developer or TOAD.

 Data Architecture: Fundamental understanding of data modeling principles.



Education & Experience

 Experience Range: Exactly 2 to 3 years of software development experience.

 Academic Degree: Bachelor’s degree in Computer Science, IT, or equivalent

field.

Good-to-Have Skills

 Familiarity with code versioning tools like Git or SVN.

 Exposure to ETL processes or cloud platforms.

 Basic knowledge of scheduling utilities such as Control-M.

Pay: ₹366,071.69 - ₹407,197.94 per year

Experience:

PL/SQL: 2 years (Required)

Work Location: In person