VS01488 - oracle/ plsql developer

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

Job summary

A leading software development company in Maharashtra seeks a skilled PL/SQL Developer to design, develop, and maintain Oracle PL/SQL solutions. The ideal candidate will have strong expertise in PL/SQL and SQL query optimization, along with good problem-solving and teamwork capabilities. This role involves collaborating with developers and ensuring data integrity and compliance with standards.

Qualifications

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

Responsibilities

• Design and maintain Oracle PL/SQL stored procedures.
• Write and optimize complex SQL queries.
• Collaborate with developers and business teams.

Skills

Oracle PL/SQL development

SQL query optimization

Performance tuning

Data modeling

Teamwork

Tools

TOAD

SQL Developer

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.