Oracle PLSQL Senior Developer

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

Job summary

Infosys in Bengaluru, India seeks an experienced Oracle PL/SQL developer to design, implement, and optimize database components. The role focuses on building robust PL/SQL packages and supporting data-intensive features across applications.

You will tune SQL queries, ensure data integrity, and collaborate with technical and business stakeholders to translate requirements into reliable, scalable database solutions. Strong debugging, logging, and documentation practices are expected.

Qualifications

• Bachelor’s degree or equivalent in a technical field; Master’s degree optional.
• 3–5 years of hands-on Oracle PL/SQL development experience.
• Strong SQL skills including joins, subqueries, aggregations, and basic query optimization.
• Experience writing maintainable code with proper error handling, logging, and documentation.
• Ability to troubleshoot data issues and collaborate effectively with technical and business stakeholders.

Responsibilities

• Develop, enhance, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Analyze and tune SQL queries and PL/SQL for performance, scalability, and stability.
• Deliver with cross-functional teams, participate in code reviews, support deployments and production issue resolution.

Skills

Oracle PL/SQL

SQL

Error handling

Logging

Documentation

Data troubleshooting

Stakeholder communication

Education

BE/BTech/BSc or Master’s equivalent (MTech/MCA/MSc)

Tools

Git

Unix/Linux Shell Scripting

Job description

Primary skills:Technology->Oracle->PL,SQL

Primary skills:Technology->Oracle->PL,SQL

Key Responsibilities

• Database Development & Enhancement
  • Develop, enhance, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
  • Implement SQL/PLSQL logic to support application features, reporting, and data processing needs.
  • Translate functional requirements into technical designs and well-structured database components.
• Performance & Reliability
  • Analyze and tune SQL queries and PL/SQL code for performance, scalability, and stability.
  • Identify bottlenecks using execution plans and apply indexing/rewriting strategies where appropriate.
  • Ensure data integrity and consistency through validations, constraints, and robust exception handling.
• Delivery & Collaboration
  • Participate in code reviews, follow coding standards, and maintain clear technical documentation.
  • Support deployments across environments and assist with production issues, root-cause analysis, and fixes.
  • Collaborate with cross-functional teams to clarify requirements, estimate work, and deliver on timelines.

Minimum Qualifications

• Bachelor’s degree or equivalent (BE/BTech/BSc) or Master’s degree equivalent (MTech/MCA/MSc).
• 3–5 years of hands‑on experience with Oracle PL/SQL development.
• Strong proficiency in SQL, including joins, subqueries, aggregations, and query optimization basics.
• Experience writing maintainable code with proper error handling, logging, and documentation practices.
• Ability to troubleshoot data issues and collaborate effectively with technical and business stakeholders.

Preferred Qualifications

• Experience designing data models and working with complex schemas in Oracle databases.
• Exposure to performance tuning techniques (execution plans, indexing strategies, query refactoring).
• Familiarity with ETL/data processing patterns and batch job design using PL/SQL.
• Experience with version control and structured release practices in enterprise environments.
• Strong communication skills to explain technical trade-offs and support requirement discussions.

Good to have skills

• Oracle Performance Tuning
• Data Modeling
• ETL Concepts
• Unix/Linux Shell Scripting
• Git