PL SQL Architect Lead-Immediate joiner

Job description

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