Oracle PL/SQL Developer

Sci Solutions Global • Durham, NC

5d • Onsite

About The Position

We are seeking 100% hands-on Oracle PL/SQL Developers with strong database development, performance tuning, and problem-solving skills. Candidates should be able to demonstrate practical PL/SQL solutions during the interview.

Requirements

• Strong Oracle SQL & PL/SQL development skills.
• Experience with complex stored procedures, packages, functions, and database business logic.
• Advanced SQL skills including window/analytical functions, joins, aggregations, set operators, and subqueries.
• Proficiency in database performance tuning, execution plans, query optimization, diagnostics, PGA, and partitioning.
• Experience with data modeling, data analysis, and data APIs.
• Experience with batch jobs using ETL/Informatica and Autosys.
• Strong communication and problem-solving skills.

Nice To Haves

• Java and mid-tier technologies.
• Messaging technologies and web containers.
• CI/CD, Agile, ATDD, and automated testing.
• Enterprise application development experience.

Responsibilities

• Develop complex stored procedures, packages, functions, and database business logic.
• Implement advanced SQL queries including window/analytical functions, joins, aggregations, set operators, and subqueries.
• Perform database performance tuning, analyze execution plans, optimize queries, and utilize diagnostics, PGA, and partitioning.
• Design and implement data models, conduct data analysis, and create data APIs.
• Develop batch jobs utilizing ETL/Informatica and Autosys.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed