Note: The job is a remote job and is open to candidates in USA. Stage 4 Solutions is hiring a Senior Oracle PL/SQL Developer for a global aerospace company. The role focuses on developing, optimizing, and tuning complex Oracle PL/SQL code and SQL queries, improving indexing and execution performance, and engineering efficient data retrieval processes within enterprise Oracle databases.
Responsibilities
- 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
Skills
- Must be a U.S. Citizen
- 8 + years of experience as Oracle pl/sql developer
- Advanced Oracle Engineering: Extensive experience designing, developing, and maintaining high-performance PL/SQL packages, procedures, functions, and triggers for enterprise-scale Oracle databases
- SQL Tuning & Optimization: Expert-level ability to analyze, rewrite, and optimize complex, slow-performing SQL queries to minimize CPU, I/O, and memory consumption
- Performance 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
- Indexing & 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
- Iterative Tuning Methodology: Ability to establish performance baselines, formulate tuning hypotheses, execute controlled tests, and document measurable improvements
- Application performance monitoring and tuning: Experience tuning applications including .NET, C#, and Citrix environments
- Experience with Starburst and Trino SQL
- Bachelor's degree
Benefits
- Health benefits
- 401K
- Remote role in the US
Company Overview