• Oracle PL/SQL Developer

    T and T Consulting Services (Silver Spring, MD)


    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_