Oracle PL SQL developer-Immediate joiner-Bangalore

Tata Elxsi; Bengaluru; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Tata Elxsi, Inc. in Bengaluru, India is seeking an experienced Oracle PL/SQL Lead to design and optimize database solutions for complex applications.

You will mentor developers, perform code reviews, and guide architecture decisions while ensuring robust production support, performance tuning, and timely delivery of critical data services.

This role focuses on application-to-database mapping, backend job analysis, and creating runbooks to ensure smooth operation and reliable data flows.

Qualifications

• 6+ years experience in Oracle PL/SQL development.
• 6+ years in Technical Lead or Architect role.
• Hands-on with Stored Procedures, Packages, Functions, Triggers, Views, and Scheduler Jobs.
• Strong production support, troubleshooting, impact analysis, and performance tuning.
• Experience mentoring developers, code reviews, and architecture decisions.

Responsibilities

• Map application to database.
• Analyze stored procedures, packages, triggers, and tables.
• Analyze backend scheduler and jobs.
• Perform impact analysis and design solutions.
• Document architecture and support readiness.

Skills

Oracle PL/SQL

Technical Lead

Architecture design

Performance tuning

Mentoring

Code reviews

Troubleshooting

Scheduler Jobs

Database analysis

Leadership

Tools

SQL Developer

TOAD

DBeaver

Job description

Experience Requirement

• 6+ years of experience in Oracle PL/SQL development.
• 6+years of experience as a Technical Lead or Architect.
• Hands-on expertise in Stored Procedures, Packages, Functions, Triggers, Views, and Scheduler Jobs.
• Strong experience in production support, troubleshooting, impact analysis, and 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 sessions
• Drive 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 Optimization
• SQL Developer, TOAD, DBeaver
• Leadership and stakeholder management