SCI SOLUTIONS GLOBAL - Oracle PL/SQL Developer Database Developer

Database Developer is needed in Durham, United States.

Client: SCI SOLUTIONS GLOBAL

Location: Durham, NC, us

Contract: Contract

Job Description

We are seeking Senior Oracle PL/SQL Developers with approximately 10–15 years of experience and, most importantly, deep, current, hands-on PL/SQL development expertise.

This role is highly technical. Candidates should be able to demonstrate strong practical knowledge during technical interviews and provide thoughtful solutions to real-world, day-to-day engineering problems. This is not a management-focused position; the team is specifically looking for engineers who remain actively hands-on with Oracle SQL/PLSQL development.

Key Responsibilities

• Design, develop, test, and maintain complex Oracle SQL and PL/SQL solutions.
• Develop complex stored procedures, packages, database business logic, custom data types, and transactional data models.
• Perform advanced SQL development, data analysis, data modeling, and data manipulation.
• Design and implement data APIs and database-centric solutions.
• Analyze and optimize database performance.
• Develop and maintain batch processing jobs using technologies such as ETL/Informatica and Autosys.
• Translate business requirements, storyboards, and use cases into scalable and maintainable software solutions.
• Participate in application design, design reviews, and code reviews.
• Develop automated test cases and participate in regression testing.
• Contribute to engineering practices involving ATDD, CI/CD, and continuous delivery.
• Collaborate with distributed/global development teams.
• Provide technical guidance and mentorship to other team members.
• Contribute directly to the codebase while working with cross-functional teams and stakeholders.

Requirements

Must-Have Skills

Oracle PL/SQL Engineering

• Strong hands-on experience developing Oracle SQL and PL/SQL.
• Development of complex:
• Stored procedures
• Packages
• Database business logic
• Custom data types
• Transactional data models

Advanced SQL & Data Manipulation

• Analytical and windowing functions.
• Complex joins and aggregations.
• Set operators.
• Subqueries and query optimization.
• Strong data analysis and data modeling capabilities.

Database Performance Tuning

• Query optimization.
• Reading and analyzing execution plans.
• Database diagnostics.
• PGA memory tuning.
• Partitioning strategies.

Additional Technical Experience

• ETL / Informatica.
• Autosys and batch job development.
• Data API design and implementation.
• Understanding of scalable application design principles.
• Knowledge of mid-tier technologies such as Java.
• Familiarity with messaging technologies and web containers.
• Understanding of how mid-tier technologies interact with databases.
• CI/CD processes and tools.
• Agile software development.

Ideal Candidate

The ideal candidate is a senior-level engineer who is still 100% hands-on with PL/SQL and can confidently engage in deep technical discussions.

Candidates should be able to:

• Solve practical database and software engineering problems.
• Explain technical decisions and trade-offs.
• Demonstrate current, deep PL/SQL expertise.
• Work independently while collaborating effectively with a global team.
• Contribute to engineering excellence and continuous improvement.
• Mentor team members while remaining actively involved in development.

Important Details

• Strong preference for candidates with current, hands-on Oracle PL/SQL development experience.
• Candidates must be prepared for deep technical interview discussions and hands-on problem solving.

Additional Information

Contract: 6+ Months

Work Authorization: Any Visa Accepted

Location: Durham, NC

Visa: USC/GC/H4 EAD, GC EAD