Oracle PL/SQL Developer

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

Job summary

A leading technology company in Chennai is seeking an experienced Oracle PL/SQL Developer. In this role, you will develop and optimize SQL queries, design indexing strategies, and manage database objects. The ideal candidate should have 4-6 years of experience in SQL development and strong skills in performance tuning. This position requires collaboration with application teams to ensure efficient database integration. Interested candidates can share their resumes at [e-mail].

Qualifications

• 4-6 years of experience in Oracle SQL and PL/SQL development.
• Proven expertise in performance tuning and database programming.
• Experience handling large datasets effectively.

Responsibilities

• Develop and optimize complex SQL queries involving multiple table joins.
• Design and implement indexing strategies to improve query performance.
• Collaborate with application teams for database integration.

Skills

Oracle SQL and PL/SQL

Complex joins and multi-table query design

Query optimization techniques

Dynamic SQL

Job description

Job Title: Oracle PL/SQL Developer

Location: Chennai

Experience: 4–6 Years

Work Mode: Work From Office

Open Positions: 5

Notice Period: Immediate to 15 Days

Job Overview

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

Application

Interested candidates can share their resumes at: [e-mail]