Oracle PLSQL @ Infosys

Infosys; Hyderabad, Pune District, Bengaluru; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

Infosys in Hyderabad is seeking an experienced Oracle PL/SQL Developer to build and optimize database objects for business-critical applications. You will develop, maintain and tune PL/SQL code, write complex SQL, and collaborate with application teams.

The role emphasizes performance tuning, query optimization, and production support, with opportunities to work on data migration and Oracle Forms & Reports in a banking/finance context.

Qualifications

• Experience developing and maintaining Oracle PL/SQL code.
• Experience with query tuning and performance optimization.
• Ability to analyze requirements and translate to database solutions.
• Experience in production support and incident resolution.

Responsibilities

• Develop, maintain, and optimize Oracle PL/SQL code.
• Create and manage Stored Procedures, Functions, Packages, and Triggers.
• Write complex SQL Queries, Views, and Materialized Views.
• Perform query tuning and database performance optimization.
• Analyze business requirements and translate them into database solutions.
• Troubleshoot production issues and provide fixes.
• Work closely with application development and support teams.
• Participate in code reviews and deployment activities.

Skills

Oracle Database

PL/SQL

SQL

Stored Procedures

Functions

Packages

Triggers

Views

Performance Tuning

Query Optimization

Tools

Unix/Linux Shell Scripting

SQL Loader

Data Migration

Oracle Forms & Reports

Job description

Job Description

We are looking for a skilled Oracle PL/SQL Developer with strong experience in database development, query optimization, and performance tuning. The candidate will be responsible for developing and maintaining Oracle database objects and supporting business-critical applications.

Key Responsibilities

• Develop, maintain, and optimize Oracle PL/SQL code.
• Create and manage Stored Procedures, Functions, Packages, and Triggers.
• Write complex SQL Queries, Views, and Materialized Views.
• Perform query tuning and database performance optimization.
• Analyze business requirements and translate them into database solutions.
• Troubleshoot production issues and provide fixes.
• Work closely with application development and support teams.
• Participate in code reviews and deployment activities.

Mandatory Skills

• Oracle Database
• PL/SQL
• SQL
• Stored Procedures
• Functions
• Packages
• Triggers
• Views
• Performance Tuning
• Query Optimization

Preferred Skills

• Unix/Linux Shell Scripting
• SQL Loader
• Data Migration
• Oracle Forms & Reports
• Banking/Finance Domain Experience
• Production Support

Tech Stack

• Oracle 11g / 12c / 19c
• Oracle PL/SQL
• SQL
• Stored Procedures
• Functions
• Packages
• Triggers
• Views
• Materialized Views
• Indexes
• Execution Plans
• Performance Tuning
• Query Optimization
• SQL Loader
• Unix/Linux