Oracle PL SQL Developer-Bangalore-Immediate joiner

Tata Elxsi; Bengaluru; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Tata Elxsi, Inc. in Bengaluru is seeking an experienced Oracle PL/SQL developer to drive robust data layer design and optimization. You will own the PL/SQL codebase, mentor junior developers, and participate in code and design reviews to ensure quality and maintainability.

Responsibilities include mapping applications to databases, analyzing stored procedures, triggers, and scheduler jobs, and contributing to architecture decisions and production support activities to ensure smooth operations.

Qualifications

• 6-8+ years of experience in Oracle PL/SQL development.
• Hands-on expertise in stored procedures, packages, functions, triggers, views, and scheduler jobs.
• Strong experience in production support, troubleshooting, impact analysis, performance tuning.

Responsibilities

• Application-to-Database mapping and analysis.
• Analyze and optimize stored procedures, packages, triggers, and tables.
• Backend scheduler/job analysis and fix.
• Provide impact analysis and design solutions.
• Prepare architecture documentation and support readiness.

Skills

Oracle PL/SQL

Mentoring developers

Code reviews

Architecture decisions

Performance tuning

Tools

SQL Developer

TOAD

DBeaver

Job description

• 6-8+ years of experience in Oracle PL/SQL development.
• Hands-on expertise in Stored Procedures, Packages, Functions, Triggers, Views, and Scheduler Jobs.
• Strong experience in production support, troubleshooting, impact analysis, performance tuning.
• Proven experience in mentoring developers, conducting code reviews, and driving architecture decisions.

Key Responsibilities

• Application-to-Database mapping
• Stored procedure, package, trigger, and table analysis
• Backend scheduler/job analysis
• Impact analysis and solution design
• Architecture documentation and support readiness

Team Leadership & Guidance

• Mentor developers on PL/SQL best practices
• Conduct code reviews and design reviews
• Guide enhancement and production support activities
• Lead RCA and troubleshooting sessionsDrive KT and documentation initiatives

Deliverables

• Application to DB Mapping Matrix
• Stored Procedure Inventory
• Trigger Inventory
• Job Inventory
• Business Rules Catalog
• Architecture and Data Flow Diagrams
• Support Runbooks and KT Documents

Required Skills

• Oracle 11g/12c/19c
• PL/SQL Packages, Procedures, Functions
• Triggers, Views, Scheduler Jobs
• Performance Tuning and Query Optimisation
• SQL Developer, TOAD, DBeaver
• Leadership and stakeholder management