Oracle PL/SQL Developer

SCI SOLUTIONS GLOBAL • Durham, NC

1d • 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

• 100% hands-on Oracle PL/SQL development experience.
• Strong database development skills.
• Proficiency in performance tuning.
• Strong problem-solving skills.
• Experience with complex stored procedures, packages, functions, and database business logic.
• Advanced SQL skills (window/analytical functions, joins, aggregations, set operators, subqueries).
• Experience with 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.

Nice To Haves

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

Responsibilities

• Develop and maintain complex stored procedures, packages, and functions.
• Implement database business logic.
• Write 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.
• Engage in data modeling, data analysis, and develop 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