PL SQL Architect Lead-Immediate joiner

Tata Elxsi; Bengaluru; On-site; INR 4,200,000 - 6,400,000; Full time

Job summary

Tata Elxsi Bengaluru is seeking a Senior PL/SQL Architect to reverse-engineer Oracle applications, understand business logic in stored procedures, packages, functions, triggers and scheduler jobs, and provide technical leadership. You will map applications to the database, analyze backend components, mentor developers, conduct code reviews, and drive architecture decisions and performance tuning.

The role requires 10-15+ years in Oracle PL/SQL and 3-5+ years as a Technical Lead or Architect,

Qualifications

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

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

Tech Lead

Stored Procedures

Performance Tuning

Mentoring & Reviews

Team Leadership

Backend Analysis

SQL Tools

Tools

SQL Developer

TOAD

DBeaver

Job description

Role Summary Senior PL/SQL Architect responsible for reverse-engineering Oracle applications, understanding business logic implemented in stored procedures, packages, functions, triggers, tables, views, and scheduler jobs, while providing technical leadership and mentoring development teams.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