Oracle PLSQL Programmer

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

Job summary

Infosys Hyderabad seeks an Oracle PL/SQL Developer to design, develop, and optimize Oracle database objects and support business-critical applications.

You will develop, maintain, and optimize PL/SQL code, create procedures, functions, packages, triggers, and views, and perform query tuning and performance optimization. Collaboration with development and support teams and involvement in deployments are key aspects of the role.

Qualifications

• Proficient in Oracle Database and PL/SQL with hands-on development experience.
• Experience in query optimization and performance tuning.
• Experience creating and managing stored procedures, functions, packages, triggers, and views.
• Knowledge of Unix/Linux shell scripting is a plus.

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

Banking/Finance Domain Experience

Production Support

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