PLSQL Developer

Elabs Infotech; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Elabs Infotech in Hyderabad is seeking an experienced Oracle PL/SQL developer to design, optimize, and maintain complex SQL queries and PL/SQL code. You will create stored procedures, functions, packages, triggers, and views, and work on data validation and efficient processing.

The role requires hands-on expertise with optimization, execution plans, indexing, and database troubleshooting, plus strong analytical problem-solving skills to deliver reliable database solutions.

Qualifications

• 612 years of relevant experience in Oracle PL/SQL development.
• Strong hands‑on experience with complex SQL queries and PL/SQL programming.
• Expertise in stored procedures, functions, packages, triggers, and cursors.
• Strong knowledge of SQL query optimization and performance tuning.
• Experience with execution plans, indexing, and database troubleshooting.
• Good understanding of database design and data analysis.
• Strong analytical and problem-solving skills.

Responsibilities

• Develop, maintain, and optimize complex SQL queries and PL/SQL code.
• Create and maintain stored procedures, functions, packages, triggers, and views.
• Perform SQL query optimization and database performance tuning.
• Analyze data and troubleshoot database-related issues.
• Work on database design, data validation, and efficient data processing.
• Review existing code and implement improvements for performance and maintainability.
• Collaborate with technical teams to understand requirements and deliver database solutions.

Skills

Oracle PL/SQL

Advanced SQL

Stored procedures

Performance tuning

Execution plans

Database design

Problem-solving

Job description

Role & responsibilities

• Develop, maintain, and optimize complex SQL queries and PL/SQL code.
• Create and maintain stored procedures, functions, packages, triggers, and views.
• Perform SQL query optimization and database performance tuning.
• Analyze data and troubleshoot database-related issues.
• Work on database design, data validation, and efficient data processing.
• Review existing code and implement improvements for performance and maintainability.
• Collaborate with technical teams to understand requirements and deliver database solutions.

Preferred candidate profile

• 612 years of relevant experience in Oracle PL/SQL development.
• Strong hands‑on experience with complex SQL queries and PL/SQL programming.
• Expertise in stored procedures, functions, packages, triggers, and cursors.
• Strong knowledge of SQL query optimization and performance tuning.
• Experience with execution plans, indexing, and database troubleshooting.
• Good understanding of database design and data analysis.
• Strong analytical and problem-solving skills.