PLSQL Developer

Intellect Design Arena; Chennai District; On-site; INR 700,000 - 1,000,000; Full time

Job summary

Intellect Design Arena in Chennai, Siruseri (Work From Office) seeks an Oracle PL/SQL Developer with 4–8 years of hands-on experience in Oracle database development, SQL programming, and performance tuning.

You will develop and maintain database objects, write complex queries, and collaborate with cross-functional teams to ensure code quality and data integrity.

Qualifications

• 4–8 years of hands-on Oracle PL/SQL development experience.
• Strong SQL and PL/SQL programming skills.
• Experience with stored procedures, functions, packages, and triggers.

Responsibilities

• Develop, enhance, and maintain Oracle PL/SQL code.
• Write complex SQL queries, stored procedures, functions, packages, and triggers.
• Perform SQL query optimization and database performance tuning.
• Work with cursors, collections, exception handling, and dynamic SQL.
• Analyze and troubleshoot database-related issues.
• Optimize existing PL/SQL code to improve performance and efficiency.
• Collaborate with application developers, business analysts, and testing teams.
• Ensure code quality, data integrity, and adherence to development standards.

Skills

Oracle PL/SQL

Oracle SQL

Performance tuning

Stored procedures

Debugging

Analytical skills

Tools

SQL*Plus

Toad

PL/SQL Developer

Job description

Job Title: Oracle PL/SQL Developer

Experience: 4 - 8 Years
Location: Chennai , Siruseri ( Work From Office )
Employment Type: Full-time

Job Description

We are looking for a skilled Oracle PL/SQL Developer with 4 - 8 years of hands-on experience in Oracle database development, SQL programming, query optimization, and performance tuning. The ideal candidate should have strong expertise in developing and maintaining database objects and writing complex SQL queries.

Key Responsibilities

• Develop, enhance, and maintain Oracle PL/SQL code.
• Write complex SQL queries, stored procedures, functions, packages, and triggers.
• Perform SQL query optimization and database performance tuning.
• Work with cursors, collections, exception handling, and dynamic SQL.
• Analyze and troubleshoot database-related issues.
• Optimize existing PL/SQL code to improve performance and efficiency.
• Collaborate with application developers, business analysts, and testing teams.
• Ensure code quality, data integrity, and adherence to development standards.

Required Skills

• 4 - 8 years of hands-on experience in Oracle PL/SQL development.
• Strong knowledge of Oracle SQL and PL/SQL programming.
• Experience with stored procedures, functions, packages, and triggers.
• Good understanding of joins, subqueries, analytical functions, and complex SQL queries.
• Experience in query optimization and performance tuning.
• Knowledge of cursors, exception handling, collections, BULK COLLECT, and FORALL.
• Strong analytical and problem-solving skills.

Preferred Skills

• Experience with PostgreSQL databases.
• Exposure to database performance monitoring and troubleshooting.
• Experience working in Agile development environments.