TA

PL/SQL Senior Architect / Technical Lead

Tata Elxsi Limited
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

foundit: Fast. Faster. foundit. 10 lakh+ jobs, top recruiters hiring. Register nowSponsored
Join WhatsApp Channel