{"schemaVersion":"jobsearcher.job.v1","id":"fe54d3ea0f47a39218bb703a","url":"https://jobsearcher.com/jobs/fe54d3ea0f47a39218bb703a","canonicalUrl":"https://jobsearcher.com/jobs/fe54d3ea0f47a39218bb703a","title":"Oracle PL/SQL Developer","description":"USA Contract On-Site Flexibility/Remote: 100%\r\nPosition Summary & Core Requirements:We are seeking a Senior Oracle SQL / PL/SQL Developer with a proven track record of writing highly optimized database code. In this role, you will be responsible for engineering efficient data retrieval processes and fine-tuning complex queries within an Oracle environment. A deep, foundational understanding of Oracle indexing strategies and data retrieval optimization is mandatory. Beyond writing clean code, you must possess a rigorous, methodical approach to performance engineering. You should intimately understand how to baseline, measure, and test query execution metrics to support iterative tuning cycles.\r\nKey Responsibilities & Qualifications:Advanced Oracle Engineering: Extensive experience designing, developing, and maintaining high-performance PL/SQL packages, procedures, functions, and triggers for enterprise-scale Oracle databases.\r\nSQL Tuning & Optimization: Expert-level ability to analyze, rewrite, and optimize complex, slow-performing SQL queries to minimize CPU, I/O, and memory consumption.\r\nPerformance Measurement: Proficiency using Oracle diagnostic tools—such as Explain Plan, TKPROF, SQL Trace, Autotrace, and AWR/ASH reports—to measure, benchmark, and iteratively test query performance.\r\nIndexing & Storage Strategies: Solid understanding of Oracle indexing mechanisms (B-tree, Bitmap, Function-Based, Covered Indexes) and data access paths (Full Table Scans, Index Scans, Hash Joins) to maximize data retrieval efficiency. Database provisioning.\r\nIterative Tuning Methodology: Ability to establish performance baselines, formulate tuning hypotheses, execute controlled tests, and document measurable improvements.\r\nApplication performance monitoring and tuning: Experience tuning applications including .NET, C#, and Citrix environments.\r\nExperience with Starburst and Trino SQL#J-18808-Ljbffr","company":"Planit Group","rawCompany":"planit group","city":"Brooklyn","state":"NY","isRemote":false,"isActive":false,"createdAt":"2026-10-04T01:46:23.927Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1251.00","title":"Computer Programmers","slug":"computer-programmers"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Oracle PL/SQL Developer","description":"USA Contract On-Site Flexibility/Remote: 100%\r\nPosition Summary & Core Requirements:We are seeking a Senior Oracle SQL / PL/SQL Developer with a proven track record of writing highly optimized database code. In this role, you will be responsible for engineering efficient data retrieval processes and fine-tuning complex queries within an Oracle environment. A deep, foundational understanding of Oracle indexing strategies and data retrieval optimization is mandatory. Beyond writing clean code, you must possess a rigorous, methodical approach to performance engineering. You should intimately understand how to baseline, measure, and test query execution metrics to support iterative tuning cycles.\r\nKey Responsibilities & Qualifications:Advanced Oracle Engineering: Extensive experience designing, developing, and maintaining high-performance PL/SQL packages, procedures, functions, and triggers for enterprise-scale Oracle databases.\r\nSQL Tuning & Optimization: Expert-level ability to analyze, rewrite, and optimize complex, slow-performing SQL queries to minimize CPU, I/O, and memory consumption.\r\nPerformance Measurement: Proficiency using Oracle diagnostic tools—such as Explain Plan, TKPROF, SQL Trace, Autotrace, and AWR/ASH reports—to measure, benchmark, and iteratively test query performance.\r\nIndexing & Storage Strategies: Solid understanding of Oracle indexing mechanisms (B-tree, Bitmap, Function-Based, Covered Indexes) and data access paths (Full Table Scans, Index Scans, Hash Joins) to maximize data retrieval efficiency. Database provisioning.\r\nIterative Tuning Methodology: Ability to establish performance baselines, formulate tuning hypotheses, execute controlled tests, and document measurable improvements.\r\nApplication performance monitoring and tuning: Experience tuning applications including .NET, C#, and Citrix environments.\r\nExperience with Starburst and Trino SQL#J-18808-Ljbffr","datePosted":"2026-10-04T01:46:23.927Z","dateModified":"2026-10-04T01:46:23.927Z","hiringOrganization":{"@type":"Organization","name":"Planit Group","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Brooklyn","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"fe54d3ea0f47a39218bb703a"},"url":"https://jobsearcher.com/jobs/fe54d3ea0f47a39218bb703a"}}