PL/SQL Senior Architect / Technical Lead- Immediate joiner-Bangalore

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

Job summary

Tata Elxsi in Bengaluru, India, seeks aSenior PL/SQL Architect to reverse-engineer Oracle applications, understand business logic in stored procedures, packages, functions, triggers, tables, and scheduler jobs. You will provide technical leadership and mentor development teams.

The role requires 10-15+ years in Oracle PL/SQL development and 3-5+ years as Technical Lead or Architect, with hands-on expertise in preferences and strong production support, troubleshooting, and performance tuning.

Qualifications

• 10-15+ years of experience in Oracle PL/SQL development.
• 3-5+ years in Technical Lead or Architect roles.
• Hands-on in 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

Skills

Oracle PL/SQL

Stored Procedures

Packages

Functions

Triggers

Views

Scheduler Jobs

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