TATata Elxsi Limited
PL/SQL Senior Architect / Technical Lead
Bangalore ₹5-8 LPA Posted 11 Nov 2026
FULL TIME
Oracle 11g/12c/19c
Oracle PL/SQL Development
SQL Performance Tuning & Query Optimization
Stored Procedures & Packages
Triggers & Scheduler Jobs
Job Description
Experience Requirement:
- 10-15+ years of experience delivering solutions in Oracle PL/SQL development.
- 3-5+ years of experience working as a Technical Lead or Architect.
- Demonstrated, hands-on proficiency with Stored Procedures, Packages, Functions, Triggers, Views, and Scheduler Jobs.
- Strong background in production support, troubleshooting, impact analysis, and performance tuning.
- Proven ability to mentor developers, lead code reviews, and influence/drive architecture decisions.
Key Responsibilities:
- Application-to-Database mapping
- Analyze stored procedures, packages, triggers, and tables
- Review and assess backend scheduler/job components
- Perform impact analysis and develop solution design
- Create and maintain architecture documentation and ensure support readiness
Team Leadership & Guidance
- Coach developers on PL/SQL best practices
- Conduct code reviews and design reviews
- Provide guidance for enhancements and production support activities
- Lead RCA efforts 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
