PLSQL lead

Infosys; Bengaluru; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Infosys in Bengaluru, Karnataka seeks an experienced PL/SQL Lead to guide a team of developers, design robust Oracle database solutions, and optimize performance. The role emphasizes production support, code reviews, and stakeholder collaboration.

You will mentor engineers, drive best practices, and coordinate across development, testing, and deployment cycles in an Agile environment.

Qualifications

• Strong experience in Oracle Database and PL/SQL development with expertise in Procedures, Packages, Functions, Triggers and Views.
• Proficient in SQL querying and performance tuning and in database design and data modeling.
• Hands-on production support and issue troubleshooting with incident management.
• Knowledge of version control tools such as Git and familiarity with Unix/Shell scripting.
• Good communication, stakeholder management, and ability to work in Agile/Scrum settings.
• Exposure to ETL/Data Migration projects and to Cloud platforms / AI-assisted development tools.

Responsibilities

• Lead the design, development, and maintenance of Oracle PL/SQL applications.
• Develop and optimize complex stored procedures, packages, functions, triggers, and views.
• Perform query tuning and database performance optimization.
• Analyze business requirements and provide scalable database solutions.
• Lead code reviews and ensure adherence to coding standards and best practices.
• Troubleshoot production issues and provide root cause analysis.
• Coordinate with cross-functional teams during development, testing, and deployment.
• Mentor team members and provide technical guidance.
• Drive continuous improvements in database architecture and development processes.

Skills

Oracle PL/SQL

SQL Performance Tuning

Data Modeling

Production Support

Stakeholder Management

AGILE/SCRUM

Education

MCA / MTech / BE / BCA / BTech

Tools

Git

Job description

Job Description

We are seeking an experienced PL/SQL Lead with strong expertise in Oracle Database, PL/SQL development, query optimization, and production support. The candidate will be responsible for leading a team of developers, designing database solutions, ensuring application performance, and collaborating with business and technical stakeholders.

Roles Responsibilities

• Lead the design, development, and maintenance of Oracle PL/SQL applications.
• Develop and optimize complex stored procedures, packages, functions, triggers, and views.
• Perform query tuning and database performance optimization.
• Analyze business requirements and provide scalable database solutions.
• Lead code reviews and ensure adherence to coding standards and best practices.
• Troubleshoot production issues and provide root cause analysis.
• Coordinate with cross-functional teams during development, testing, and deployment.
• Mentor team members and provide technical guidance.
• Drive continuous improvements in database architecture and development processes.

Technical Requirement

• Primary skills:Technology->Oracle->PL,SQLAdditional Responsibility
• Strong experience in Oracle Database and PL/SQL development.Expertise in Stored Procedures, Packages, Functions, Triggers, and Views.Strong SQL querying and performance tuning experience.Experience in database design and data modeling.Hands-on experience in production support and issue troubleshooting.Knowledge of version control tools such as Git.Strong analytical, problem-solving, and debugging skills.Excellent communication and stakeholder management skills.Experience with Unix/Shell Scripting.Exposure to ETL/Data Migration projects.Knowledge of Oracle Forms/Reports or Oracle APEX.Experience with Agile/Scrum methodologies.Exposure to Cloud platforms and AI-assisted development tools.Educational RequirementMCA,MTech,Bachelor of Engineering,BCA,BTechPreferred SkillsTechnology->Oracle->PL/SQLService LineApplication Development and Maintenance