Talent.com
Oracle PL/SQL Developer
Oracle PL/SQL DeveloperT and T Consulting Services Inc • Silver Spring, MD, US
Oracle PL / SQL Developer

Oracle PL / SQL Developer

T and T Consulting Services Inc • Silver Spring, MD, US
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Description

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, US

    [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_variable_days] • [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]
    Technical Lead (Oracle Pl / Sql)

    Technical Lead (Oracle Pl / Sql)

    TechDigital Group • Washington, DC, United States
    [job_card.full_time]
    This position is for a highly motivated, driven individual with a passion for Application database development.The role is aligned with a project involving full software development lifecycle suppo...[show_more]
    [last_updated.last_updated_30] • [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]
    (3542) DevOps Engineer

    (3542) DevOps Engineer

    Iamus Consulting • Columbia, Maryland, United States
    [job_card.full_time]
    We are seeking a highly motivated and experienced DevOps Engineer to join our fast-paced development team.The ideal candidate will have strong working knowledge in Kubernetes and Container Orchestr...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Android Software Developer

    Android Software Developer

    SimVentions, Inc - Glassdoor 4.6 • La Plata, Maryland, United States
    [job_card.full_time]
    SimVentions is a 100% employee-owned business and has consistently been voted one of Virginia's Best Places to Work.We are looking for a mid-level Software Engineer to join our team! This individua...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    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_1_day]
    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]
    Database Developer / Administrator (Oracle, PostgreSQL)

    Database Developer / Administrator (Oracle, PostgreSQL)

    Bering Straits Native Corporation • Suitland-Silver Hill, Maryland, United States
    [job_card.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 / Admi...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    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]
    Oracle / APEX Developer (0043)

    Oracle / APEX Developer (0043)

    OCT Consulting, LLC • Washington, DC, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    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_30]