VS01488 - oracle/ plsql developer

E4 Software Services Pvt Ltd.; Belapur Bk; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading software development firm in India is seeking a skilled Oracle PL/SQL Developer to design and optimize database solutions. The ideal candidate will have strong expertise in developing stored procedures and writing complex SQL queries. Collaborate with application developers and DBAs to ensure data integrity and system performance. Competitive salary and professional growth opportunities are offered.

Qualifications

• Strong expertise in Oracle PL/SQL development.
• Proficiency in writing and optimizing SQL queries.
• Hands-on experience with performance tuning.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL stored procedures.
• Write and optimize complex SQL queries.
• Perform debugging and troubleshooting of PL/SQL code.

Skills

Oracle PL/SQL development

SQL query optimization

Performance tuning

Problem-solving

Analytical skills

Communication

Teamwork

Tools

TOAD

SQL Developer

Oracle utilities

Job description

Design, develop, and maintain Oracle PL/SQL stored procedures, packages, triggers, functions, and views.

Write and optimize complex SQL queries for performance and scalability.

Perform debugging, tuning, and troubleshooting of PL/SQL code and SQL queries.

Analyze requirements, design solutions, and prepare technical specifications.

Collaborate with application developers, DBAs, and business teams for data-related needs.

Implement data migration, ETL processes, and integration with external systems.

Ensure database security, integrity, and compliance with organizational standards.

Support production systems and provide on-call support when required.

Required Skills & Qualifications:

• Strong expertise in Oracle PL/SQL development (procedures, functions, packages, triggers, cursors).
• Proficiency in writing and optimizing complex SQL queries.
• Hands-on experience with performance tuning and query optimization.
• Familiarity with data modeling, database design concepts, and normalization.
• Experience with tools like TOAD, SQL Developer, or other Oracle utilities.
• Knowledge of ETL, data migration, and reporting.
• Good problem-solving and analytical skills.
• Strong communication and teamwork abilities.