Job Description

**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_**

Job Tags

Work experience placement,

Similar Jobs