PLSQL Developer

Tata Consultancy Services Limited; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services Limited in Mumbai is seeking a Senior PLSQL Developer to design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, and triggers.

The role requires optimizing SQL queries, tuning performance, supporting production incidents, developing ETL processes, data migrations, and collaborating with development teams to ensure reliable database solutions and compliant deployment plans.

Qualifications

• Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, and triggers.
• Create and optimize SQL queries for high-performance database operations.
• Analyze business requirements and translate them into technical solutions.
• Perform database performance tuning, query optimization, and troubleshooting.
• Work closely with application development teams to integrate database solutions.
• Develop ETL processes and data migration scripts as required.
• Handle production support, issue resolution, and root cause analysis.
• Maintain database objects and ensure adherence to coding standards.
• Participate in code reviews and technical discussions.
• Prepare technical documentation and deployment plans.

Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, and triggers.
• Create and optimize SQL queries for high-performance database operations.
• Analyze business requirements and translate them into technical solutions.
• Perform database performance tuning, query optimization, and troubleshooting.
• Work closely with application development teams to integrate database solutions.

Skills

Oracle PL/SQL

SQL performance tuning

ETL processes

Data migration

Production support

Code reviews

Deployment planning

Troubleshooting

Database design

Job description

Role - PLSQL Senior developer

Location - Mumbai

Experience - 6+ Years

Desired Competencies (Technical/Behavioral Competency)-

1. Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, and triggers.
2. Create and optimize SQL queries for high-performance database operations.
3. Analyze business requirements and translate them into technical solutions.
4. Perform database performance tuning, query optimization, and troubleshooting.
5. Work closely with application development teams to integrate database solutions.
6. Develop ETL processes and data migration scripts as required.
7. Handle production support, issue resolution, and root cause analysis.
8. Maintain database objects and ensure adherence to coding standards.
9. Participate in code reviews and technical discussions.
10. Prepare technical documentation and deployment plans.