PLSQL Developer-PRI

Tata Consultancy Services; Bengaluru; On-site; INR 1,200,000 - 2,500,000; Full time

Job summary

Tata Consultancy Services in Bengaluru is seeking a PL/SQL Developer with 5-10 years of Oracle SQL/PL/SQL experience to join the data team. You will develop, optimize, and maintain PL/SQL code and design database objects to support business applications.

Responsibilities include performance troubleshooting, data integrity, and collaboration with cross-functional teams in an agile environment. Strong analytical skills are essential.

Qualifications

• Strong experience in Oracle SQL and PL/SQL.
• Expertise in writing Stored Procedures, Functions, Packages, Triggers, and Cursors.
• Experience in Query Optimization and Performance Tuning.
• Strong understanding of Database Design and Data Modeling.
• Experience in handling large data volumes and complex SQL queries.
• Knowledge of Indexing, Partitioning, and Oracle Database concepts.
• Good problem-solving and analytical skills.

Responsibilities

• Develop, maintain, and optimize PL/SQL code.
• Design and implement database objects and scripts.
• Analyze and troubleshoot database performance issues.
• Work with cross-functional teams to understand business requirements.
• Ensure data integrity, quality, and security.
• Participate in code reviews and testing activities.

Skills

Oracle SQL

PL/SQL

Stored Procedures

Functions

Packages

Triggers

Cursors

Query Optimization

Performance Tuning

Data Modeling

Database Design

Large Data Volumes

Indexing

Partitioning

Problem Solving

Tools

Unix/Linux Shell Scripting

ETL/Data Migration Tools

Agile Tools

Job description

Position: PL/SQL Developer
Experience: 5-10 Years
Location: Bangalore

Required Skills:

• Strong experience in Oracle SQL and PL/SQL.
• Expertise in writing Stored Procedures, Functions, Packages, Triggers, and Cursors.
• Experience in Query Optimization and Performance Tuning.
• Strong understanding of Database Design and Data Modeling.
• Experience in handling large data volumes and complex SQL queries.
• Knowledge of Indexing, Partitioning, and Oracle Database concepts.
• Good problem-solving and analytical skills.

Responsibilities:

• Develop, maintain, and optimize PL/SQL code.
• Design and implement database objects and scripts.
• Analyze and troubleshoot database performance issues.
• Work with cross-functional teams to understand business requirements.
• Ensure data integrity, quality, and security.
• Participate in code reviews and testing activities.

Preferred Skills:

• Experience with Unix/Linux Shell Scripting.
• Exposure to ETL/Data Migration projects.
• Experience working in Agile environments.