Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home

Jobs

Home
>
Jobs in Bengaluru
>
Infosys
>
PLSQL Lead

PLSQL Lead

Infosys

5 - 8 years

8 - 12 Lacs

Bengaluru

Posted:14 hours ago| Platform:

Apply

Skills Required

sql development toad sql tuning oracle development stored procedures oracle pl oracle sql queries sql coding svn database administration oracle cloud sql plsql database design git java data modeling oracle database architecture ocp

Work Mode

Work from Office

Job Type

Full Time

Job Description

Educational
BSc,BCA,Master Of Engineering,MSc,MCA,MTech,BTech,Bachelor of Engineering Service Line
Application Development and Maintenance Responsibilities
Roles and Responsibilities:Technical Leadership & Mentorship:Lead a team of PL/SQL developers, providing technical guidance, mentorship, and code reviews.Foster a collaborative environment and promote knowledge sharing within the team.Define and enforce PL/SQL coding standards, best practices, and performance optimization techniques.Assist in the professional development of team members.Design & Development:Design, develop, and implement complex PL/SQL packages, procedures, functions, triggers, and views.Create and optimize SQL queries for various database operations and reporting needs.Develop and maintain database schemas, tables, and indexes.Work closely with architects and business analysts to translate business requirements into technical specifications.Participate in all phases of the software development lifecycle (SDLC), including requirements gathering, design, development, testing, deployment, and support.Performance Tuning & Optimization:Identify and resolve performance bottlenecks in existing PL/SQL code and SQL queries.Utilize Oracle performance tuning tools (e.g., AWR, ADDM, Explain Plan, SQL Trace) to analyze and optimize database performance.Implement efficient data loading, transformation, and extraction strategies.Database Management & Support:Collaborate with database administrators (DBAs) for schema design, capacity planning, and database maintenance activities.Provide production support for PL/SQL applications, troubleshooting issues and implementing timely solutions.Ensure data integrity and security within the database environment.Documentation & Reporting:Create and maintain comprehensive technical documentation for PL/SQL code, database designs, and processes.Generate reports and provide insights on database performance and development progress.Collaboration & Communication:Effectively communicate technical concepts to both technical and non-technical stakeholders.Collaborate with cross-functional teams (e.g., Java developers, QA, Business Analysts) to ensure seamless integration and delivery. Additional Responsibilities:
EducationBachelor's degree in Computer Science, Information Technology, or a related field.CertificationsOracle Certified Professional (OCP) in PL/SQL or Database Administration is a plus. Technical and Professional :
5-8 years of extensive experience in Oracle PL/SQL development, including strong proficiency in writing complex stored procedures, functions, packages, and triggers.Expertise in SQL tuning and optimization for high-volume, high-performance applications.Solid understanding of Oracle database architecture, data modeling, and relational database concepts.Experience with various Oracle features such as Analytical Functions, Materialized Views, Partitions, and Indexes.Proficiency in using SQL Developer, Toad, or similar Oracle development tools.Experience with version control systems (e.g., Git, SVN). Preferred
Skills:

Technology-Oracle Cloud-Oracle Knowledge

More Jobs at Infosys

Automation Test Engineer_Java with Selenium

Chennai, Bengaluru, Hyderabad

3 - 8 yrs

INR 5 - 13 Lacs

Api Tester

Chennai, Pune, Bengaluru

6 - 8 yrs

INR 0 - 1 Lacs

Azure Developer- Bengaluru

Chennai, Bengaluru, Hyderabad

2 - 7 yrs

INR 5 - 15 Lacs

Python Developer-Bengaluru

Chennai, Bengaluru, Hyderabad

2 - 5 yrs

INR 4 - 8 Lacs

Scala Developer

Chennai, Bengaluru, Hyderabad

5 - 10 yrs

INR 6 - 14 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Java Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Java Skills

Practice Java coding challenges to boost your skills

Start Practicing Java Now

Infosys

IT Services and IT Consulting

Bangalore Karnataka

10001 Employees

4328 Jobs

Key People

Salil Parekh

CEO & Managing Director
Richard Lobo

Executive Vice President and Head of Human Resources
Kiran Kumar

Senior Vice President and Head of Digital Services

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

PLSQL Lead