PLSQL Developer

Evoke HR Solutions Pvt. Ltd.; Mumbai; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Evoke HR Solutions Pvt. Ltd. is seeking an experienced PL/SQL Developer to design, optimize, and maintain database applications in a Mumbai setting. You will work on complex PL/SQL programs, stored procedures, and triggers, focusing on performance tuning and scalable solutions.

The role involves analyzing execution plans, refining queries, and collaborating with development teams to ensure robust database functionality and adherence to coding standards.

Qualifications

• Solid experience with PL/SQL programming and database objects.
• Experience in tuning and optimizing SQL queries.
• Ability to analyze execution plans and identify bottlenecks.
• Strong knowledge of functions, packages, and triggers.
• Experience in data validation and production support.

Responsibilities

• Develop and maintain complex PL/SQL programs, stored procedures, functions, packages, and triggers.
• Perform SQL and PL/SQL performance tuning and optimize database queries.
• Analyze execution plans and identify performance bottlenecks.
• Develop efficient and scalable database solutions.
• Troubleshoot database issues and provide technical solutions.
• Perform data validation, debugging, and production support activities.
• Collaborate with application and development teams to resolve database-related issues.
• Follow coding standards and best practices for database development.

Skills

PL/SQL

Stored Procedures

Performance Tuning

SQL Queries

Functions

Packages

Triggers

Query optimization

Execution plans

Job description

We are looking for an experienced PL/SQL Developer with strong expertise in PL/SQL, Stored Procedures, and Performance Tuning to develop, optimize, and maintain database applications.

Key Responsibilities:

• Develop and maintain complex PL/SQL programs, stored procedures, functions, packages, and triggers.
• Perform SQL and PL/SQL performance tuning and optimize database queries.
• Analyze execution plans and identify performance bottlenecks.
• Develop efficient and scalable database solutions.
• Troubleshoot database issues and provide technical solutions.
• Perform data validation, debugging, and production support activities.
• Collaborate with application and development teams to resolve database-related issues.
• Follow coding standards and best practices for database development.

Mandatory Skills:

• Strong experience in PL/SQL
• Stored Procedures
• Performance Tuning
• SQL Queries
• Functions, Packages, and Triggers
• Query optimization and execution plans