PL/SQL Senior Architect / Technical Lead Profile

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.