Consultant - Oracle PL/SQL Job

Job Summary

We are looking for an experienced Oracle PL/SQL Sr. Developer, with 5 to 8 yearsof experience, to support, enhance, and maintain database solutions for multiple enterprise applications. This role focuses on PL/SQL development, performance tuning, data integration, and production support, ensuring high data quality, reliability, and performance.

KEY RESPONSIBILITIES

• Design, develop, and maintain Oracle databases and schema objects
• Develop and optimize PL/SQL packages, procedures, functions, triggers, and views
• Write complex SQL queries to support application functionality and reporting
• Provide production support for multiple applications by troubleshooting data issues
• Perform query tuning and performance optimization using explain plans and indexing strategies
• Develop and maintain data integration processes and batch jobs
• Support data migration, transformation, and reconciliation activities
• Work closely with application teams to translate business requirements into database solutions
• Implement robust exception handling and logging in PL/SQL code
• Manage database security, roles, and user access controls
• Participate in code reviews, testing, and deployment activities
• Maintain technical documentation for database logic and processes
• Perform root cause analysis for production issues related to data.
• Document database structures, ETL processes, and development standards.
• Ontime Coordination and Status Reporting to the client.
• Good communication skills, with the ability to convey technical concepts to both technical and non-technical customers.

REQUIRED SKILLS & QUALIFICATIONS

• Strong experience with Oracle Database.
• Advanced proficiency in PL/SQL.
• Expertise in developing packages, stored procedures, functions, and triggers.
• Strong knowledge of SQL performance tuning.
• Experience with indexes, partitions, and query optimization.
• Understanding of database design principles and normalization.
• Experience handling large and complex datasets.
• Ability to debug and resolve production data issues.
• Knowledge of transaction management and locking mechanisms.
• Good problem solving and analytical skills.

SOFT SKILLS:

• Strong analytical and problem-solving skills
• Ability to support multiple applications simultaneously
• Good communication and teamwork abilities
• High attention to data accuracy and detail

PREFERRED QUALIFICATIONS

• Experience with Oracle Forms/Reports or application backend support
• Familiarity with Shell scripting or batch job automation
• Knowledge of data warehousing concepts
• Exposure to ETL tools (Informatica, ODI, etc.)
• Experience with Oracle SQL Developer, TOAD, or similar tools
• Understanding of backup, recovery, and RMAN basics
• Cloud exposure (Oracle Cloud / AWS RDS Oracle) is a plus

SOFT SKILLS