Oracle PL/SQL Developer

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

Job summary

Infosys seeks an Oracle PLSQL Developer with 2-3 years of hands-on experience in Oracle Database and PL/SQL. You will develop, test, and optimize PL/SQL programs and complex SQL queries in a fast-paced enterprise environment.

Join a team focused on reliability, performance, and collaboration with developers, analysts, and QA to deliver robust database solutions and migration support.

Qualifications

• 2-3 years of hands-on experience in Oracle Database and PL/SQL Development.
• Strong knowledge of SQL, PL/SQL, stored procedures, functions and triggers.
• Experience in performance optimization and data modeling concepts.
• Familiarity with Oracle development tools such as SQL Developer or TOAD.
• Understanding SDLC and Agile methodologies.

Responsibilities

• Develop, test, and maintain Oracle PL/SQL programs, packages, procedures, and views.
• Write and optimize complex SQL queries for data retrieval and reporting.
• Perform database design, development, and data modeling activities.
• Analyze and troubleshoot database issues and provide timely resolutions.
• Support data migration, integration, and ETL processes.
• Ensure database performance, security, and availability.
• Participate in code reviews and adhere to standards.
• Collaborate with developers, business analysts, and QA teams.
• Prepare technical documentation and support deployment activities.

Skills

Oracle PL/SQL

SQL

Performance tuning

SDLC & Agile

Data modeling

PL/SQL debugging

SQL Developer / TOAD

Education

Bachelor's Degree

Master's Degree

Tools

SQL Developer

TOAD

Job description

Oracle PLSQL Developer • Primary skills:Technology->Oracle->PL,SQL

Educational Qualification Bachelor's Degree: B.E / B.Tech or equivalent Master's Degree: MCA / M.Tech / M.Sc or equivalent (preferred)

The ideal candidate will possess strong Oracle PL/SQL development skills, a passion for database technologies, and the ability to deliver reliable, high-performance database solutions in a fast-paced enterprise environment.

Key Responsibilities

• Develop, test, and maintain Oracle PL/SQL programs, packages, procedures, functions, triggers, and views.
• Write and optimize complex SQL queries for data retrieval, reporting, and application support.
• Perform database design, development, and data modeling activities.
• Analyze and troubleshoot database-related issues and provide timely resolutions.
• Support data migration, data integration, and ETL processes.
• Ensure database performance, integrity, security, and availability.
• Participate in code reviews and adhere to database development standards and best practices.
• Collaborate with application developers, business analysts, and QA teams during development and testing phases.
• Prepare technical documentation and support deployment activities.

Required Skills

• 2-3 years of hands-on experience in Oracle Database and PL/SQL Development.
• Strong knowledge of SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, Views, and Cursors.
• Experience in writing complex queries and performance optimization techniques.
• Understanding of database normalization, indexing, and data modeling concepts.
• Familiarity with Oracle development tools such as SQL Developer, TOAD, or equivalent.
• Experience in debugging, troubleshooting, and performance tuning of PL/SQL code.
• Knowledge of database security principles and data management practices.
• Good understanding of software development lifecycle (SDLC) and Agile methodologies.