PL/SQL Senior Architect / Technical Lead-Immediate joiner

Tata Elxsi; Bengaluru; On-site; INR 3,000,000 - 5,200,000; Full time

Job summary

Tata Elxsi is seeking a Senior PL/SQL Architect in Bengaluru to reverse-engineer Oracle applications and understand business logic in stored procedures, packages, functions, triggers, views, and scheduler jobs. You will provide technical leadership and mentor development teams.

Responsibilities include mapping applications to database structures, conducting code reviews, and guiding enhancements while supporting production issues and performance improvements.

Qualifications

• 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.
• Mentoring developers, conducting code reviews, and driving architecture decisions.

Responsibilities

• Application-to-Database mapping and analysis.
• Analyze stored procedures, packages, triggers, and tables.
• Analyze backend scheduler/jobs and impact.
• Design solutions and drive architecture decisions.
• Provide architecture documentation and readiness support.

Skills

PL/SQL

Leadership

Code Reviews

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