Walk-in | PLSQL Lead

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

Job summary

Intellect Design Arena is seeking an experienced PL/SQL Developer to design, develop, test, and maintain advanced PL/SQL programs for multiple applications in Chennai. You will optimize queries, implement stored procedures, and collaborate with cross-functional teams to translate business requirements into robust database solutions.

The ideal candidate has 5–10 years of hands-on PL/SQL experience with Oracle databases (9i/10g/11g), strong SQL skills, and familiarity with Unix shell scripting.

Qualifications

• 5-10 years of PL/SQL development experience with Oracle databases (9i/10g/11g).
• Proficient in developing stored procedures, functions, packages and triggers using Oracle PL/SQL.
• Experience with Unix shell scripting is an added advantage.
• Strong understanding of SQL including syntax, data types and control structures.

Responsibilities

• Design, develop, test, and maintain complex PL/SQL programs for various applications.
• Develop stored procedures, functions, packages, and triggers using Oracle PL/SQL.
• Optimize database performance by analyzing queries and implementing optimization techniques.
• Collaborate with cross-functional teams to identify business requirements and implement solutions.
• Troubleshoot issues related to database performance tuning and query optimization.

Skills

PL/SQL development

Oracle databases

Stored procedures

Unix shell scripting

SQL language

Job description

Roles and Responsibilities

• Design, develop, test, and maintain complex PL/SQL programs for various applications.
• Develop stored procedures, functions, packages, and triggers using Oracle PL/SQL.
• Optimize database performance by analyzing queries and implementing optimization techniques.
• Collaborate with cross-functional teams to identify business requirements and implement solutions.
• Troubleshoot issues related to database performance tuning and query optimization.

Desired Candidate Profile

• 5-10 years of experience in PL/SQL development with expertise in Oracle databases (9i/10g/11g).
• Proficiency in developing stored procedures, functions, packages, triggers using Oracle PL/SQL.
• Experience with Unix shell scripting is an added advantage.
• Strong understanding of SQL programming language including syntax, data types, control structures, etc.