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 - ₹507,197.94 per year
Experience:
- PL/SQL: 1 year (Required)
Work Location: In person
