Oracle PL/SQL Developer

LTM; Mumbai, Pune District; On-site; INR 900,000 - 1,200,000; Full time

Job summary

LTM in Pune/Mumbai is seeking an experienced Oracle PL/SQL Developer to join our backend DB development team. You will develop complex PL/SQL objects, optimize queries, and support large-scale enterprise applications.

Ideal candidates have 4–8 years of hands-on Oracle SQL/PL-SQL experience, strong tuning skills, and a solid understanding of database design and data modelling. Immediate joiners only, Pune or Mumbai location, notice period must be minimal.

Qualifications

• Strong experience in Oracle SQL and PL/SQL.
• Expertise in Stored Procedures, Functions, Packages, Triggers and Views.
• Performance Tuning and Query Optimisation.
• Database Design and Data Modelling.
• Joins, Indexes, Partitions and Cursors.
• Unix/Shell Scripting is a plus and Agile experience.

Responsibilities

• Develop and maintain Oracle PL/SQL packages, procedures, functions, triggers and views.
• Write and optimise complex SQL queries for business requirements.
• Perform query tuning and performance optimisation.
• Analyse and troubleshoot database-related issues.
• Work closely with application development and business teams.
• Create technical documentation and support deployment activities.

Skills

Oracle SQL

PL/SQL

Stored Procedures

Functions

Packages

Triggers

Views

Performance Tuning

Query Optimisation

Database Design

Data Modelling

Joins

Indexes

Partitions

Cursors

Unix Shell Scripting

Agile Methodology

Job description

Job Title: Oracle PL/SQL Developer

Experience: 4 to 8 Years
Location: Pune / Mumbai
Notice Period: Immediate Joiners Only

Job Description

We are looking for an experienced Oracle PL/SQL Developer with strong expertise in database development, performance tuning, and SQL optimisation. The candidate should possess hands-on experience in developing complex PL/SQL objects and supporting large-scale enterprise applications.

Key Responsibilities

• Develop and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Write and optimise complex SQL queries for business requirements.
• Perform query tuning and performance optimisation.
• Analyse and troubleshoot database-related issues.
• Work closely with application development and business teams.
• Create technical documentation and support deployment activities.
• Participate in code reviews and ensure adherence to development standards.

Mandatory Skills

• Strong experience in Oracle SQL and PL/SQL
• Expertise in Stored Procedures, Functions, Packages, Triggers, Views
• Performance Tuning and Query Optimisation
• Database Design and Data Modelling
• Joins, Indexes, Partitions, Cursors
• Unix/Shell Scripting (Good to Have)
• Experience in Agile methodology