Oracle PL​/SQL Developer Database Developer

Durham, United States

Contract: 6+ Months

Visa: USC/GC/H4 EAD, GC EAD

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.

• 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.

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

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

• Query optimization.
• Reading and analyzing execution plans
  .
• PGA memory tuning
  .

• 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.

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.
• 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.

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
.