Oracle PL/SQL Developer

7 hours ago

Silver Spring, United States Maryland Staffing Full time

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

  • Oracle PL/SQL Developer

    2 weeks ago

    Silver Spring, MD, United States T & T Consulting Services, Inc. Full time

    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...

  • Oracle PL/SQL Developer

    7 days ago

    Silver Spring, MD, United States T & T Consulting Services, Inc. Full time

    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...

  • Oracle PL/SQL Developer

    2 weeks ago

    Silver Spring, MD, United States T & T Consulting Services, Inc. Full time

    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...

  • Oracle PL/SQL Developer

    6 days ago

    Silver Spring, MD, United States T & T Consulting Services, Inc. Full time

    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...

  • Database Developer

    2 weeks ago

    Suitland-Silver Hill, United States Bering Straits Native Corporation Full time

    SUMMARY Arcticom, a company within the BSNC family, is currently seeking a qualified Database Developer / Administrator (Oracle, PostgreSQL) in Suitland, MD. This full-time Database Developer / Administrator position offers a unique opportunity to work with both Oracle and PostgreSQL databases, with a strategic focus on future migration to PostgreSQL. The...

  • Application Database Administrator

    2 weeks ago

    Silver Spring, MD, United States Think Tank Inc Full time

    *US Citizenship Required *Position is Subject to Contract AwardREQUIREMENTS: Expertise in Agile Methodology Prior federal work experience Experience with ETL process Proficient with Oracle E-Business Suite, Oracle EBS Application Architecture, and SQL Familiarity with federal IT security controls and audit requests, including SSO and MFA Great communication...

  • Application Database Administrator

    2 weeks ago

    Silver Spring, MD, United States Think Tank Inc Full time

    *US Citizenship Required *Position is Subject to Contract AwardREQUIREMENTS: Expertise in Agile Methodology Prior federal work experience Experience with ETL process Proficient with Oracle E-Business Suite, Oracle EBS Application Architecture, and SQL Familiarity with federal IT security controls and audit requests, including SSO and MFA Great communication...

  • Application Database Administrator

    2 weeks ago

    Silver Spring, MD, United States Think Tank Inc Full time

    *US Citizenship Required *Position is Subject to Contract AwardREQUIREMENTS: Expertise in Agile Methodology Prior federal work experience Experience with ETL process Proficient with Oracle E-Business Suite, Oracle EBS Application Architecture, and SQL Familiarity with federal IT security controls and audit requests, including SSO and MFA Great communication...

  • Marine Development Analyst Level 1

    2 weeks ago

    Silver Spring, United States Think Tank, Inc. Full time

    *US Citizenship Required*Onsite at a NEFSCPOSITION DESCRIPTION:The Marine Development Analyst will support the Northeast Fisheries Science Center (NEFSC) by providing scientific and technical expertise related to the coexistence of fisheries and offshore development. The analyst will contribute to regional-scale ecosystem research and monitoring, evaluate...

  • Marine Development Analyst Level 3

    2 weeks ago

    Silver Spring, United States Think Tank, Inc. Full time

    *US Citizenship Required*Onsite at a NEFSCPOSITION DESCRIPTION:The Marine Development Analyst will support the Northeast Fisheries Science Center (NEFSC) by providing scientific and technical expertise related to the coexistence of fisheries and offshore development. The analyst will contribute to regional-scale ecosystem research and monitoring, evaluate...