Oracle Sql Developer

Tata Consultancy Services; Chennai District, Kolkata District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced Oracle database professional in Chennai to design, implement and optimize database solutions. You will develop complex stored procedures, packages, functions and triggers, and drive performance improvements for large datasets.

The role requires hands-on PL/SQL, SQL tuning, data migration and validation, and a solid understanding of database design, normalization and indexing.

Qualifications

• Strong expertise in Oracle SQL and PL/SQL programming.
• Hands-on experience writing complex stored procedures, packages, functions and triggers.
• Proficiency in query optimization and performance tuning.
• Experience with data migration, data validation and large datasets.
• Understanding of database design, normalization and indexing strategies.
• Experience in Unix/Linux and shell scripting.
• Strong debugging, problem-solving and analytical skills.
• Experience working in Agile/Scrum delivery model.

Responsibilities

• Role involves developing and maintaining Oracle-based database solutions.
• Design and optimize database objects such as procedures, packages, functions and triggers.
• Improve query performance through optimization and indexing strategies.
• Execute data migration and validation for large datasets.
• Collaborate in an Agile/Scrum delivery environment.
• Troubleshoot and debug database-related issues to ensure reliability.

Skills

Oracle SQL

PL/SQL

Stored procedures

Performance tuning

Data migration

Data validation

Unix/Linux

Shell scripting

Debugging

Agile/Scrum

Indexing

Database design

Job description

Role & responsibilities

• Strong expertise in Oracle SQL and PL/SQL programming
• Hands‑on experience in writing complex stored procedures, packages, functions, and triggers
• Proficiency in query optimization and performance tuning
• Experience with data migration, data validation, and large datasets
• Understanding of database design, normalization, and indexing strategies
• Experience in Unix/Linux and shell scripting
• Strong debugging, problem‑solving, and analytical skills
• Experience working in Agile/Scrum delivery model