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.
Pay: ₹366,839.13 - ₹408,338.91 per year
Experience:
- PL/SQL: 2 years (Required)
Work Location: In person
