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