Senior Oracle SQL / PL/SQL Developer

PGS Worldwide is seeking a Senior Oracle SQL / PL/SQL Developer for a one year contract supporting a leading aerospace & defense company. We are seeking an experienced developer with a proven track record of writing highly optimized database code and engineering efficient data retrieval processes within an Oracle environment. A deep understanding of Oracle indexing strategies, data retrieval optimization, and methodical performance engineering is required. This is a fully remote, full-time telework position.Required SkillsExtensive experience designing, developing, and maintaining high-performance PL/SQL packages, procedures, functions, and triggers for enterprise-scale Oracle databasesExpert-level ability to analyze, rewrite, and optimize complex, slow-performing SQL queries to minimize CPU, I/O, and memory consumptionProficiency with Oracle diagnostic tools including Explain Plan, TKPROF, SQL Trace, Autotrace, and AWR/ASH reportsStrong understanding of Oracle indexing mechanisms, including B-tree, Bitmap, Function-Based, and Covered IndexesStrong understanding of data access paths, including Full Table Scans, Index Scans, and Hash JoinsExperience with database provisioningAbility to establish performance baselines, formulate tuning hypotheses, execute controlled tests, and document measurable improvementsExperience with application performance monitoring and tuningExperience tuning applications including .NET, C#, and Citrix environmentsExperience with Starburst and Trino SQLU.S. citizenship required due to system data accessWhat You'll DoEngineer efficient data retrieval processes within an Oracle environmentFine-tune complex and slow-performing SQL queriesDevelop and maintain high-performance PL/SQL code for enterprise-scale Oracle databasesMeasure, benchmark, and iteratively test query performance using Oracle diagnostic toolsAnalyze indexing strategies and data access paths to maximize data retrieval efficiencyEstablish performance baselines and conduct controlled tuning testsDocument measurable performance improvementsTune application performance across .NET, C#, and Citrix environmentsWork Schedule / Shift4/10s First ShiftFull-time teleworkAdditional InformationSecurity Clearance: NoneU.S. citizenship required due to system data accessJob ID: 22538"Military veterans and transitioning military members are encouraged to apply to all PGS Worldwide positions. All of our jobs are military-friendly, and we work with leaders in Aerospace who rely on your military expertise to support mission-critical programs nationwide. As a Veteran Founded company, we know that the military has given you the skills and training you need to succeed in positions like this, and we want to support your success in the civilian sector however we can. We thank you for your service and humbly offer our own in return by helping you take your career to the next level."