Description

You will design, develop, and optimize complex Oracle PL/SQL solutions with a focus on performance and data integrity.

This role is remote.

Responsibilities

• Write and optimize complex Oracle SQL queries to minimize SGA, PGA, and TempSpace usage.
• Implement advanced PL/SQL concepts, including BULK COLLECT and FORALL, for efficient high-volume data processing.
• Store, query, and manipulate JSON data within Oracle database tables.
• Maintain and enhance existing PL/SQL packages, procedures, and triggers.

Required Skills

• 12+ years of hands-on experience with Oracle PL/SQL development.
• Expert-level proficiency in Oracle SQL, including query tuning and execution plan analysis.
• Deep understanding of Oracle memory structures (SGA, PGA) and space management.
• Strong experience with BULK COLLECT and FORALL for high-volume data handling.
• Proficiency in handling JSON data types and functions within Oracle.
• Ability to write clean, maintainable, and performant code.

Key Skills

Education

Any Graduate