PL/SQL Senior Architect / Technical Lead Profile

Careernet; Bengaluru; Hybrid; INR 3,500,000 - 5,500,000; Full time

Job summary

Careernet in Bengaluru is seeking an experienced Oracle PL/SQL professional to lead complex database development. You will analyze applications, review database objects, and optimize SQL while mentoring the team.

The role requires hands-on PL/SQL work, expertise with Oracle 11g/12c/19c, Scheduler jobs, production support, and strong leadership for stakeholder management.

Qualifications

• 10-15+ years of Oracle PL/SQL development experience.
• 3-5+ years in Technical Lead or Architect roles.
• Strong hands-on experience with Oracle 11g/12c/19c.
• Proficient in PL/SQL procedures, packages, functions, triggers, and views.
• Experience with Oracle Scheduler jobs.
• Solid production support and troubleshooting knowledge.
• Excellent performance tuning and SQL optimization skills.
• Experience with SQL Developer, TOAD, or DBeaver.
• Strong leadership, mentoring and stakeholder management abilities.

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.

Skills

Oracle

PL/SQL

Stored Procedures

Packages

Functions

Triggers

Views

Scheduler Jobs

Performance Tuning

SQL

Technical Leadership

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

SQL Developer

TOAD

DBeaver

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.