PL SQL Architect-Bangalore/ Hyderabad-Immediate joiner

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

Job summary

Tata Elxsi in Hyderabad is seeking a Senior PL/SQL Architect to reverse-engineer Oracle applications, analyze business logic in stored procedures, packages, functions, triggers, tables and scheduler jobs, and provide technical leadership to development teams.

You will mentor developers, conduct code reviews, drive architecture decisions and deliver architectures documents and data flow diagrams to ensure readiness for production support.

Qualifications

• 10-15+ years of experience in Oracle PL/SQL development.
• 3-5+ years in Technical Lead or Architect roles.
• Hands-on with procedures, packages, functions, triggers, views.
• Strong production support, troubleshooting, and performance tuning.
• Mentoring developers and driving architecture decisions.
• Experience in code reviews and KT/documentation.

Responsibilities

• Analyze application to database mappings.
• Analyze stored procedures, packages, triggers, and tables.
• Analyze backend scheduler/jobs and provide analysis.
• Perform impact analysis and design solutions.
• Document architecture and support readiness.
• Mentor developers on PL/SQL best practices.
• Lead RCA and troubleshooting sessions.

Skills

Oracle PL/SQL

Performance Tuning

Leadership

Stakeholder mgmt

Tools

SQL Developer

TOAD

DBeaver

Job description

PL/SQL Senior Architect

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