Oracle PL/SQL Developer

Closing Gap

Chennai District

In loco

INR 800.000 - 1.400.000

Tempo pieno

14 giorni+

Aumenta le possibilità di ricevere una risposta da questo datore di lavoro

Il tuo curriculum e una lettera di presentazione personalizzati, che corrispondono esattamente a ciò che sta cercando.

Supera i filtri ATS

Descrizione del lavoro

Closing Gap is looking for an experienced Oracle PL/SQL Developer in Chennai to design, optimize, and manage complex SQL queries and database objects. You will work on performance tuning, indexing, and dynamic SQL for both DML and DDL tasks, ensuring robust exception handling and reliable logging.

Ideal candidates will handle large data sets with cursors and collections, debug PL/SQL efficiently, and collaborate with application teams for seamless integration.

Competenze

  • Strong experience with Oracle SQL and PL/SQL.

Mansioni

  • Develop and optimize complex SQL queries with multiple table joins.
  • Design indexing strategies to improve query performance.
  • Write and execute dynamic SQL for DML and DDL operations.
  • Develop and maintain database objects such as packages, procedures, and functions.
  • Handle large datasets using cursors, loops, and collections.
  • Perform DML and DDL operations (INSERT, UPDATE, DELETE; CREATE, DROP).
  • Implement exception handling and error logging.
  • Debug, troubleshoot, and optimize PL/SQL code.
  • Collaborate with application teams for database integration.

Conoscenze

Oracle SQL
PL/SQL
Query optimization
Complex joins
Dynamic SQL
Performance tuning
Exception handling
Debugging

Strumenti

Git

Descrizione del lavoro

We are seeking an experienced Oracle PL/SQL Developer with strong expertise in SQL development, performance tuning, and database programming. The role requires hands‑on experience in writing complex queries, optimizing performance, and managing database objects in a production environment.

Key Responsibilities:
  • Develop and optimize complex SQL queries involving multiple table joins
  • Design and implement indexing strategies to improve query performance
  • Write and execute dynamic SQL for DML and DDL operations
  • Develop and maintain database objects such as packages, procedures, and functions
  • Handle large datasets using cursors, loops, and collections
  • Perform DML operations (INSERT, UPDATE, DELETE) and DDL operations (CREATE, DROP)
  • Implement exception handling and error logging mechanisms
  • Debug, troubleshoot, and optimize PL/SQL code
  • Collaborate with application teams for database integration
Required Skills:
Core Skills:
  • Strong experience in Oracle SQL and PL/SQL
  • Expertise in complex joins and multi‑table query design
  • Query optimization and indexing techniques
  • Experience with dynamic SQL
Technical Skills:
  • Cursor types: Implicit, Explicit, REF CURSOR, SYS_REFCURSOR
  • CASE and DECODE statements
  • Packages, stored procedures, loops, and collections
  • Exception handling and logging mechanisms
  • Strong debugging and performance tuning capabilities
Good to Have:
  • Experience with Java or backend integration
  • Exposure to migration or modernization projects
  • Familiarity with version control tools such as Git
  • Experience working in Agile/Scrum environments
Soft Skills:
  • Strong attention to detail
  • Proactive and ownership-driven approach
  • Good communication and stakeholder management skills
  • Ability to work in a fast‑paced environment
Ottieni la revisione del curriculum gratis e riservata.

o trascina qui il file.

Similar jobs

Offerte di lavoro simili che vale la pena confrontare

Oracle PL/SQL Developer
Oracle PL/SQL Developer

The Closing Gap • Chennai

In loco
INR 600.000 - 900.000
Oracle Developer
Oracle Developer

Comunus Technologies • Mumbai

In loco
INR 900.000 - 1.500.000
Hiring: Oracle Developer (PL/SQL)
Hiring: Oracle Developer (PL/SQL)

Aabasoft Inc. • Ernakulam

In loco
INR 800.000 - 1.400.000
Oracle PLSQL @ Infosys
Oracle PLSQL @ Infosys

Infosys • Hyderabad, Pune District, Bengaluru

In loco
INR 1.200.000 - 2.000.000
[9HP1YIU9] Database Developer - PLSQL
[9HP1YIU9] Database Developer - PLSQL

ZettaMine Labs Pvt. Ltd. • Mumbai

In loco
INR 1.200.000 - 1.800.000
PLSQL Developer
PLSQL Developer

Intellect Design Arena • Chennai District

In loco
INR 700.000 - 1.000.000
Oracle PL/SQL Developer-L3
Oracle PL/SQL Developer-L3

RENOVISION AUTOMATION SERVICES PVT.LTD • Mumbai

In loco
INR 900.000 - 1.300.000
Oracle PL/SQL Developer (Lead)
Oracle PL/SQL Developer (Lead)

Spydra • Karnataka

In loco
INR 1.800.000 - 2.800.000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

InfoBeans • India

In loco
INR 1.200.000 - 1.800.000
Oracle,PLSQL,ProC majors
Oracle,PLSQL,ProC majors

Qloron Pvt Ltd • Bengaluru

In loco
INR 1.200.000 - 1.800.000