Oracle PL/SQL Developer

Closing Gap; Chennai District; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Closing Gap is looking for an experienced Oracle PL/SQL Developer in Chennai to design, optimize, and manage complex SQL queries and database objects. You will work on performance tuning, indexing, and dynamic SQL for both DML and DDL tasks, ensuring robust exception handling and reliable logging.

Ideal candidates will handle large data sets with cursors and collections, debug PL/SQL efficiently, and collaborate with application teams for seamless integration.

Qualifications

• Strong experience with Oracle SQL and PL/SQL.

Responsibilities

• Develop and optimize complex SQL queries with multiple table joins.
• Design indexing strategies to improve query performance.
• Write and execute dynamic SQL for DML and DDL operations.
• Develop and maintain database objects such as packages, procedures, and functions.
• Handle large datasets using cursors, loops, and collections.
• Perform DML and DDL operations (INSERT, UPDATE, DELETE; CREATE, DROP).
• Implement exception handling and error logging.
• Debug, troubleshoot, and optimize PL/SQL code.
• Collaborate with application teams for database integration.

Skills

Oracle SQL

PL/SQL

Query optimization

Complex joins

Dynamic SQL

Performance tuning

Exception handling

Debugging

Tools

Git

Job description

We are seeking an experienced Oracle PL/SQL Developer with strong expertise in SQL development, performance tuning, and database programming. The role requires hands‑on experience in writing complex queries, optimizing performance, and managing database objects in a production environment.

Key Responsibilities:

• Develop and optimize complex SQL queries involving multiple table joins
  
• Design and implement indexing strategies to improve query performance
  
• Write and execute dynamic SQL for DML and DDL operations
  
• Develop and maintain database objects such as packages, procedures, and functions
  
• Handle large datasets using cursors, loops, and collections
  
• Perform DML operations (INSERT, UPDATE, DELETE) and DDL operations (CREATE, DROP)
  
• Implement exception handling and error logging mechanisms
  
• Debug, troubleshoot, and optimize PL/SQL code
  
• Collaborate with application teams for database integration
  

Required Skills:

Core Skills:

• Strong experience in Oracle SQL and PL/SQL
  
• Expertise in complex joins and multi‑table query design
  
• Query optimization and indexing techniques
  
• Experience with dynamic SQL
  

Technical Skills:

• Cursor types: Implicit, Explicit, REF CURSOR, SYS_REFCURSOR
  
• CASE and DECODE statements
  
• Packages, stored procedures, loops, and collections
  
• Exception handling and logging mechanisms
  
• Strong debugging and performance tuning capabilities
  

Good to Have:

• Experience with Java or backend integration
  
• Exposure to migration or modernization projects
  
• Familiarity with version control tools such as Git
  
• Experience working in Agile/Scrum environments
  

Soft Skills:

• Strong attention to detail
  
• Proactive and ownership-driven approach
  
• Good communication and stakeholder management skills
  
• Ability to work in a fast‑paced environment