Oracle Developer

Comunus Technologies; Mumbai; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Comunus Technologies in Mumbai, India seeks an Oracle Developer with 3-5 years of experience in Oracle Database development, PL/SQL programming, SQL optimization, and performance tuning. You will develop, maintain, and optimize database objects to support business applications.

Responsibilities include writing complex SQL, PL/SQL procedures, triggers, and packages; performing query optimization; analyzing execution plans; and collaborating with analysts and developers to ensure reliable database

Qualifications

• 3-5 years of hands-on Oracle SQL and PL/SQL development.
• Bachelor's degree in CS/IT or related.
• Strong analytical and problem-solving skills.
• Good communication and teamwork.

Responsibilities

• Develop, maintain, and optimize Oracle PL/SQL code.
• Write complex SQL queries, joins, and analytics.
• Develop stored procedures, functions, packages, and triggers.
• Handle cursors, collections, and exception handling.
• Perform SQL tuning and analyze execution plans.
• Create and maintain tables, views, indexes, sequences.
• Assist with data migration, validation, and troubleshooting.
• Collaborate with business analysts and developers.
• Prepare technical documentation and deployments.

Skills

Oracle Database

SQL Queries

PL/SQL

Procedures & Packages

Triggers

Cursors

Performance Tuning

DB Objects

Exception Handling

Execution Plans

Education

Bachelor's degree in CS/IT

Tools

Oracle Forms

Oracle Reports

Oracle EBS

Oracle APEX

Unix/Linux Shell

ETL & Data Migration

Java

Python

Agile/Scrum

Job description

Job Summary

We are looking for a skilled Oracle Developer with 3-5 years of experience in Oracle Database development, PL/SQL programming, SQL query optimization, and database performance tuning. The candidate should have hands-on experience in developing, maintaining, and optimizing database objects, writing complex queries, and supporting business applications.

Responsibilities

• Develop, maintain, and optimize Oracle PL/SQL code.
• Write complex SQL queries, joins, subqueries, and analytical queries.
• Develop and maintain stored procedures, functions, packages, and triggers.
• Work on cursors, collections, exception handling, and dynamic SQL.
• Perform SQL query optimization and performance tuning.
• Analyze execution plans and improve database performance.
• Create and maintain database tables, views, indexes, and sequences.
• Handle data migration, data validation, and database troubleshooting.
• Debug existing PL/SQL code and resolve production issues.
• Work closely with functional teams, business analysts, and application developers.
• Prepare technical documentation and support deployment activities.

Mandatory Technical Skills

• Oracle Database - Strong hands-on experience
• SQL - Complex queries, joins, subqueries
• PL/SQL
• Procedures, functions, packages
• Triggers
• Cursors
• Performance Tuning - Query optimization, execution plans
• Database Objects - Tables, views, indexes, sequences
• Exception Handling - PL/SQL exception handling

Good-to-Have Skills

• Oracle 11g / 12c / 19c
• Oracle Forms and Reports
• Oracle EBS knowledge
• Oracle APEX
• UNIX/Linux shell scripting
• Knowledge of ETL and data migration
• Basic knowledge of Java or Python
• Experience with Agile/Scrum methodology

Required Qualifications

• Bachelors degree in Computer Science, Information Technology, or a related field.
• 3-5 years of hands-on experience in Oracle SQL and PL/SQL development.
• Strong analytical and problem-solving skills.
• Good communication and teamwork skills.
• Ability to work independently and manage multiple tasks.