PL/SQL Senior Architect / Technical Lead

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

Job summary

Tata Elxsi in Bengaluru seeks a Senior Oracle PL/SQL Lead to drive database architecture and deliver scalable backend solutions. You will mentor developers, conduct code reviews, and own performance tuning, with hands-on work on stored procedures, packages, triggers, and scheduler jobs, while aligning with architecture decisions and production support.

You will lead design reviews, guide enhancements, and ensure robust data interfaces, data models, and runbooks for ongoing operations and KT

Qualifications

• Experience: 10-15+ years in Oracle PL/SQL development.
• 3-5+ 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.
• Mentoring developers, code reviews, and driving architecture decisions.

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
• 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
• 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

Skills

Oracle PL/SQL development

Team leadership

Mentoring developers

Code reviews

Performance tuning

SQL Developer tools

Architectural decisions

Tools

SQL Developer

TOAD

DBeaver

Job description

Tata Elxsi offers comprehensive services in Media and Communications, including research, strategy, design, software development, validation, and deployment. With global presence and deep expertise, we specialize in 5G services, Edge computing, and connectivity solutions.

Experience Requirement:

• 10-15+ years of experience in Oracle PL/SQL development.
• 3-5+ 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