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