Talent.com
Oracle PL/SQL Developer
Oracle PL/SQL DeveloperT & T Consulting Services, Inc. • Silver Spring, MD, United States
[error_messages.no_longer_accepting]
Oracle PL / SQL Developer

Oracle PL / SQL Developer

T & T Consulting Services, Inc. • Silver Spring, MD, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.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_alerts.create_a_job]

    Oracle Developer • Silver Spring, MD, United States

    [internal_linking.similar_jobs]
    PL / SQL Developer

    PL / SQL Developer

    VirtualVocations • Arlington, Virginia, United States
    [job_card.full_time]
    A company is looking for a PL / SQL Developer to join a collaborative and fast-paced development team focused on supporting enterprise data solutions. Key Responsibilities Design, develop, and maint...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Oracle / APEX Developer Resource

    Oracle / APEX Developer Resource

    Human Capital Resources and Concepts • Washington D.C, DC, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    HCRC is seeking a talented and motivated Oracle / APEX Developer to join our team.This role will be responsible for designing, developing, and maintaining applications using Oracle Application ...[show_more]
    [last_updated.last_updated_30]
    Senior Oracle APEX Developer

    Senior Oracle APEX Developer

    Leidos • Fort Washington, MD, United States
    [job_card.full_time]
    Join Leidos as a Senior Oracle APEX Developer to support the ESA V program, which delivers essential IT applications and infrastructure services for various customers within the Department of Justi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Jr-Mid Oracle APEX Developer

    Jr-Mid Oracle APEX Developer

    SiloSmashers • Alexandria, VA, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    We are seeking an experienced Oracle APEX Application Developer to join our team.The ideal candidate will have a proven track record in Oracle APEX application development, strong PL / SQL skills, an...[show_more]
    [last_updated.last_updated_30]
    Oracle IDM / ADF - Washington, DC (Long-Term)

    Oracle IDM / ADF - Washington, DC (Long-Term)

    Two95 International Inc. • Washington, DC, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Oracle IDM (Oracle Identity Management).Job Overview & Responsibilities : -.The candidate will provide technical consulting / advisory, implementation, as well as general maintenance and operationa...[show_more]
    [last_updated.last_updated_30]
    Oracle Forms Developer

    Oracle Forms Developer

    Razor Talent • Rockville, MD, United States
    [job_card.full_time]
    Razor is seeking a Senior Oracle Forms Developer for a long-term, 100% remote federal government contract supporting the Department of Veterans Affairs. This position requires obtaining an Active Pu...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Principal SQL Developer

    Principal SQL Developer

    Macpower Digital Assets Edge • Washington, DC, United States
    [job_card.permanent]
    Provide technical leadership to design, develop, optimize, and secure enterprise data platforms supporting analytics and critical business applications for a public sector healthcare finance enviro...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Oracle ERP Reporting Developer

    Oracle ERP Reporting Developer

    LingaTech • Washington, DC, United States
    [job_card.full_time]
    This role is responsible for designing, developing, and supporting enterprise reporting and analytics solutions that enable business stakeholders to make data‑driven decisions across Oracle ERP, Pr...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Oracle APEX Developer SME

    Oracle APEX Developer SME

    Apex Systems • Washington, DC, United States
    [job_card.full_time]
    Apex Systems is seeking an Oracle APEX Developer SME who can work onsite in Washington, D.The ideal candidate will be personable and articulate and will focus on making sure that the customer's nee...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Apex Database Oracle Developer

    Apex Database Oracle Developer

    Aleto, Inc. • Arlington, VA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Junior Database Oracle Apex Developer Job Type : Full-Time Location : Remote Compensation / Salary : $110,000-$115,000K Authorization Status : Must be Authorized to Work in the U.C...[show_more]
    [last_updated.last_updated_variable_hours] • [new]
    Oracle DBA

    Oracle DBA

    Apolis • Washington, DC, United States
    [job_card.temporary]
    Washington DC - Hybrid at the Pentagon (2 days a week onsite).Seeking an experienced Oracle Database Administrator to join our on a program supporting one of our federal client's financial manageme...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Oracle / APEX Developer (0043)

    Oracle / APEX Developer (0043)

    OCT CONSULTING LLC • Washington, DC, United States
    [job_card.full_time]
    OCT Consulting is a business management and technology consulting firm that supports Federal Government clients.We provide consulting services in the areas of Strategy, Process Improvement, Change ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Oracle EBS Record to Report / GL Lead

    Oracle EBS Record to Report / GL Lead

    IBM • Alexandria, VA, United States
    [job_card.full_time] +1
    A career in IBM Consulting is built on long-term client relationships and close collaboration worldwide.You'll work with leading companies across industries, helping them shape their hybrid cloud a...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Database Administrator (SQL+Oracle)

    Senior Database Administrator (SQL+Oracle)

    Respec • Washington, DC, United States
    [job_card.full_time]
    Big challenges need bold thinkers.If you're someone who sees problems as opportunities, you'll thrive here.Here, your ideas drive real solutions. Since 1969, we've tackled complex challenges in ener...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    B015 - Oracle ERP CRS

    B015 - Oracle ERP CRS

    V-Soft Consulting Group • Washington, DC, United States
    [job_card.full_time]
    Primary Location : Washington, District of Columbia.V-Soft Consulting is currently hiring for an.Washington, District of Columbia. Bachelor's degree in computer science or related field OR 6+ years o...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    RUST Software Developers

    RUST Software Developers

    L3Harris Technologies • ALEXANDRIA, Virginia, United States
    [job_card.full_time]
    L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do.Our employees are unified in a shared dedication to our customers’ mission and quest ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Senior Java PL / SQL Developer / AI

    Senior Java PL / SQL Developer / AI

    PlanIT Group, LLC • Washington, DC, United States
    [job_card.permanent] +1
    Senior Java PL / SQL Developer / AI at PlanIT Group, LLC.Client seeks a Senior level technical or business area expert to address a task or environment need, providing advice on state-of-the-art soluti...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Backend Ab Initio / PL-SQL Developer 100% onsite

    Backend Ab Initio / PL-SQL Developer 100% onsite

    RIT Solutions, Inc. • Riverdale, MD, United States
    [job_card.full_time]
    Must be able to obtain and maintain a Public Trust.Must be on-site five days a week in Woodlawn, MD.Strong working knowledge of COBOL, JCL, Ab Initio, PL-SQL, Linux Scripting, and of DB2.PostgreSQL...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]