T and T Consulting Services, Inc. ยท 1 month ago
Oracle PL/SQL Developer
DOC NOAA OCIO IMS , Silver Spring, MD, US
Full-time
Onsite
Senior Level
$115K/yr - $145K/yr
7+ years expT and T Consulting Services, Inc. is seeking a highly skilled and experienced Oracle PL/SQL Developer to join their core development team. The role involves designing, developing, and optimizing high-performance database solutions with a focus on efficiency and scalability, along with performance tuning and troubleshooting complex production issues.
ConsultingInformation TechnologySoftware
Responsibilities
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
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
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
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
Collaborate with data architects to refine data models, ensuring designs are optimized for PL/SQL access patterns and memory efficiency
Create and maintain technical documentation, including specifications, design documents, and operational guides for database objects, code invocation, debugging and logging
Qualification
Required
Minimum of 7+ years of professional experience as an Oracle PL/SQL Developer or Database Engineer
Expert proficiency in all aspects of PL/SQL programming, including bulk operations (FORALL, BULK COLLECT), collections, object-oriented features, and exception handling
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
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
Strong working experience with Oracle Database 12c, 19c, or later
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
Health
Dental
Vision
Life insurance coverage
401(k) Plan
Training Programs
Accrued Paid Time Off (PTO)
Paid Holidays
Company
T and T Consulting Services, Inc.
T and T Consulting Services, Inc.
51-200 employees
H1B Sponsorship
T and T Consulting Services, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (1)
2023 (2)
2022 (6)
2021 (3)
2020 (6)
Funding
Current Stage
Growth StageLeadership Team
Sophia Tong
CEO
Gene H.
Chief Information Officer
Recent News
Washington Business Journal
2025-01-10
2024-11-27
Company data provided by crunchbase