Senior Oracle PL/SQL Performance Engineer - Remote

PlanIT Group; Northern (KY); Hybrid; USD 110,000 - 160,000; Full time

Job summary

PlanIT Group is seeking a Senior Oracle SQL/PL/SQL Developer to optimize enterprise Oracle databases and drive high-performance data retrieval. You will design, tune, and validate complex PL/SQL programs, baselining performance and iteratively delivering measurable improvements.

The role requires deep knowledge of Oracle indexing, diagnostic tools, and cross-functional collaboration with application teams to optimize .NET/Citrix environments.

Qualifications

• Senior Oracle SQL/PL/SQL Developer with proven track record of optimizing database code.
• Deep understanding of Oracle indexing strategies and data retrieval optimization is mandatory.
• Ability to baseline, measure, and test query execution metrics to support iterative tuning cycles.

Responsibilities

• Advanced Oracle engineering: design, develop, and maintain high-performance PL/SQL packages, procedures, functions, and triggers for enterprise databases.
• SQL tuning and optimization: analyze, rewrite, and optimize complex queries to minimize CPU, I/O, and memory use.
• Performance measurement: use Oracle diagnostic tools (Explain Plan, TKPROF, SQL Trace, AWR/ASH) to benchmark and improve performance.
• Indexing & storage strategies: apply B-tree, Bitmap, Function-Based, and Covered Indexes for efficient data access.
• Iterative tuning methodology: establish baselines, test hypotheses, document improvements.
• Application performance monitoring and tuning: tune applications including .NET, C#, and Citrix environments.
• Experience with Starburst and Trino SQL

Skills

Oracle SQL

PL/SQL development

SQL tuning

Performance benchmarking

Explain Plan / TKPROF / AWR

Indexing strategies

.NET / C#

Starburst & Trino SQL

Tools

Oracle

TKPROF

SQL Trace

AWR/ASH

Explain Plan

Starburst

Trino SQL

Job description

PlanIT Group is seeking a Senior Oracle SQL/PL/SQL Developer to optimize enterprise Oracle databases and drive high-performance data retrieval. You will design, tune, and validate complex PL/SQL programs, baselining performance and iteratively delivering measurable improvements.

The role requires deep knowledge of Oracle indexing, diagnostic tools, and cross-functional collaboration with application teams to optimize .NET/Citrix environments.