Oracle PLSQL @ Infosys

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