Experience Requirement
- 7+ 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 managem