PL/SQL Senior Architect / Technical Lead Profile

Job description

Key Skills: Oracle, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Views, Scheduler Jobs, Performance Tuning, SQL, Technical Leadership Roles & Responsibilities: • Analyze Oracle applications and understand business logic. • Review database objects such as procedures, packages, functions, triggers, tables, and views. • Analyze scheduler jobs and application dependencies. • Perform impact analysis and provide solutions for application changes. • Support production issues, troubleshooting, and root cause analysis. • Improve database performance and optimize SQL queries. • Prepare application and database mapping documents. • Create architecture, data flow, and support documentation. • Mentor developers and provide technical guidance. • Conduct code and design reviews. • Lead knowledge transfer and documentation activities. • Work with technical and business stakeholders. Experience Required: • 10 - 15+ years of experience in Oracle PL/SQL development. • 3 - 5+ years of experience as a Technical Lead or Architect. • Strong experience with Oracle 11g, 12c, or 19c. • Hands-on experience with PL/SQL procedures, packages, functions, triggers, and views. • Experience with Oracle Scheduler jobs. • Strong experience in production support and troubleshooting. • Good knowledge of performance tuning and query optimization. • Experience with SQL Developer, TOAD, or DBeaver. • Strong leadership, mentoring, and stakeholder management skills. Education: • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.