We are looking for an experienced Oracle PL/SQL Developer with strong hands-on expertise in SQL/PLSQL development, database performance tuning, and production support. The candidate will develop database components, optimize complex queries, troubleshoot production issues, and work closely with application teams.

Key Responsibilities

- Develop and maintain complex PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Views, and Jobs.

- Write and optimize complex SQL using joins, subqueries, CTEs, analytical functions, MERGE, and set operators.

- Perform SQL/PLSQL performance tuning using execution plans and SQL optimization techniques.

- Optimize high-volume data processing using BULK COLLECT, FOR ALL, collections, and dynamic SQL.

- Design and maintain tables, indexes, constraints, sequences, and database objects.

- Analyze and resolve production issues, data issues, and performance bottlenecks.

- Perform root-cause analysis and develop permanent fixes for recurring issues.

- Create and execute database deployment and rollback scripts.

Mandatory Skills

- Minimum 2 years of hands-on Oracle PL/SQL development.

- Robust SQL and PL/SQL programming skills.





- Strong experience with Packages, Procedures, Functions, Triggers, Cursors, Collections, BULK COLLECT, FOR ALL, and Dynamic SQL.

- Strong knowledge of execution plans, indexing, query optimization, and SQL performance tuning.

- Good understanding of transactions, locking, concurrency, constraints, and data integrity.

- Experience handling large-volume data and performance-sensitive applications.

- Production support and troubleshooting experience.

- Good knowledge of Oracle 19c/21c or equivalent enterprise Oracle environments.

Pay: ₹300,000.00 - ₹800,000.00 per year

Benefits

- Cell phone reimbursement

- Flexible schedule

- Health insurance

- Leave encashment

- Paid sick time

- Provident Fund

Ability to commute/relocate

- Bengaluru, Karnataka (Bengaluru, Bengaluru Urban District): Reliably commute or planning to relocate before starting work (Required)

Application Question(s)

- What is your notice period?

- What is your current CTC?

- What is your expected CTC?

Experience

- PL/SQL: 2 years (Required)

Work Location: In person

📌 Oracle PL/SQL Developer (Bengaluru)
🏢 AGILETS PRIVATE
📍 Bengaluru