07 Nov
|
Tata Elxsi
|
India
Shift Timings - Night Shift
Interview mode - Face to Face in any of our office location
Notice Period - Immediate joiners preferred
Role Summary
Senior PL/SQL Developer 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
6+ years of experience in Oracle PL/SQL development.
Hands-on expertise in Stored Procedures, Packages, Functions, Triggers, Views, and Scheduler Jobs.
Robust 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
📌 Pl/sql Developer Immediate Joinersf Interview Bengaluru (India)
🏢 Tata Elxsi
📍 India