Senior Oracle PLSQL Developer (Remote)
We are looking for Senior Oracle PLSQL Developer for a global aerospace company. In this role, you will develop, optimize, and tune complex Oracle PL/SQL code and SQL queries, focusing on indexing, execution performance, and efficient data retrieval within enterprise Oracle databases.
This is an 12-month contract (extensions likely), 40-hour-per-week (4-day 10-hour shifts per week) role, this is a remote role in the US.
This is a W-2 role as a Stage 4 Solutions employee. Health benefits and 401K are offered.
Responsiblities
- 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.
Requirements:
- 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
Please submit your resume to our network at http://www.stage4solutions.com/careers/ (Please apply to the Senior Oracle PLSQL Developer (Remote) role).
Please feel free to forward this opportunity to others who may be interested.
Stage 4 Solutions is an equal-opportunity employer. We celebrate diversity and are committed to providing employees with an inclusive environment that is free of discrimination and harassment. All employment decisions are based on the job requirements and candidates' qualifications, without regard to race, color, religion/belief, national origin, gender identity, age, disability, marital status, genetic information or other applicable legally protected characteristics.
Compensation: $100/hr - $120/hr
#LI-SW1
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
