Oracle PL/SQL Developer

Project Overview:

We are seeking a highly skilled and experienced Oracle PL/SQL Developer with expert-level knowledge of Oracle Database Development Memory Management to join our core development team. The ideal candidate will be instrumental in designing, developing, and optimizing high-performance database solutions, focusing specifically on maximizing efficiency and scalability through deep memory utilization expertise.

Key Responsibilities: 

• Design and Development: Design, develop, test, and implement robust, high-volume, and high-performance PL/SQL stored procedures, functions, packages, and triggers.
  • Must be able to strictly adhere to and propose changes and improvements for the established set of development coding and naming standards.
  • Must author code that is clear, unambiguous, succinct and non repetitive.
• Performance Tuning: Serve as the subject matter expert in advanced Oracle PL/SQL performance tuning, with a primary focus on optimizing SQL execution and PL/SQL code by:
  • Analyzing and manipulating memory structures (e.g., Shared Pool, Plan Cache, Data Buffer Cache, PGA).
  • Making use of Bulk processing approaches where appropriate
• SQL Optimization: Write, review, and optimize complex SQL queries using Execution Plans and leveraging advanced techniques like hints, index optimization, and materialization to ensure fast data retrieval.
  • Initiate SQL changes based on objective, measurable data
• Troubleshooting: Diagnose and resolve complex production issues related to execution performance and memory contention. 
  • Must have expert knowledge of using the built in debugging methods provided by their development tool of choice.
• Data Modeling: Collaborate with data architects to refine data models, ensuring designs are optimized for PL/SQL access patterns and memory efficiency.
• Documentation: Create and maintain technical documentation, including specifications, design documents, and operational guides for database objects, code invocation, debugging and logging.

Required Skills & Qualifications:

• Experience: Minimum of 7 years of professional experience as an Oracle PL/SQL Developer or Database Engineer.
• PL/SQL Expertise: Expert proficiency in all aspects of PL/SQL programming, including bulk operations (FORALL, BULK COLLECT), collections, object-oriented features, and exception handling.
• Oracle Memory Management (Expert): Demonstrable expert-level understanding of Oracle Database architecture, including:
  • SGA (System Global Area) components: Shared Pool Library Cache (Plan reuse), Data Dictionary Cache (object reference resolution), Data Buffer Cache (data reuse) and Redo Buffer.
  • PGA (Program Global Area)and its impact on sort operations and hash joins.
    • bind variable values
    • in memory loads, e.g. PL/SQL collections
• JSON: Both construction and access of JSON data representations using Oracle’s provided utilities for the SQL (JSON_OBJECT, JSON_TABLE, JSON_ARRAYAGG ) and PL/SQL (JSON_OBJECT_T, JSON_ARRAY_T) engines.
• Database Version: Strong working experience with Oracle Database 12c, 19c, or later.

Soft Skills: Strong analytical, problem-solving, and communication skills; ability to work independently and collaboratively in an agile environment. Code Review and Git Repo Version Control experience.

Benefits: Competitive benefits package including health, dental, vision, life insurance coverage, 401(k) Plan, Training Programs, Accrued Paid Time Off (PTO) and Paid Holidays.

Equal Opportunity Employer/Veterans/Disabled