Oracle PL/SQL Developer

The Closing Gap; Chennai; On-site; INR 600,000 - 900,000; Full time

Job summary

The Closing Gap in Chennai seeks an experienced Oracle PL/SQL Developer to join our data team. You will write complex queries, tune performance, and manage database objects in a production environment.

You will optimize SQL, implement indexing strategies, and collaborate with application teams to ensure reliable, scalable data solutions.

Qualifications

• Proven experience writing complex SQL queries and PL/SQL code in production DBs.
• Experience with performance tuning and index design.
• Familiarity with dynamic SQL, DML and DDL.
• Ability to collaborate with application teams.

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.

Skills

Oracle SQL

PL/SQL

Complex joins

Query optimization

Dynamic SQL

Tools

Cursor types: implicit/explicit/ref cursor/sys_refcursor

CASE and DECODE

Packages/procedures/loops/collections

Exception handling/logging

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