Oracle PL/SQL Developer
The Closing Gap
- Chennai, Tamil Nadu
- Permanent
- Full-time
Location: Chennai
Experience: 4–6 Years
Work Mode: Work From Office
Open Positions: 5
Notice Period: Immediate to 15 DaysJob 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
- 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
- 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
- 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
- Strong attention to detail
- Proactive and ownership-driven approach
- Good communication and stakeholder management skills
- Ability to work in a fast-paced environment
Interested candidates can share their resumes at: hr@theclosinggap.net