Oracle PL/SQL Developer Database Developer

Premier Inn Hotels LLC (UAE); North Carolina; On-site; USD 120,000 - 170,000; Full time

Job summary

Premier Inn Hotels LLC (UAE) is seeking a Senior Oracle PL/SQL Developer in Durham, United States. The ideal candidate has 10–15 years of hands-on experience and deep Oracle SQL/PL/SQL expertise. This is a highly technical role focused on engineering with no management duties.

The position requires staying hands-on with PL/SQL, participating in design reviews, and collaborating with global teams to deliver scalable solutions. 6+ months contract with USC/GC‑EAD eligibility is mentioned.

Qualifications

• 10–15 years of hands-on Oracle PL/SQL experience.
• Strong problem-solving and interview-ready technical depth.
• Experience with ETL tools, batch jobs, and data APIs.
• Ability to design scalable database solutions.
• Willingness to mentor teammates.

Responsibilities

• Design, develop, test, and maintain Oracle SQL and PL/SQL solutions.
• Develop stored procedures, packages, database business logic, and data models.
• Analyze and optimize database performance.
• Implement data APIs and batch processing with ETL/Informatica and Autosys.
• Contribute to CI/CD and ATDD practices.
• Mentor team members and collaborate with distributed teams.

Skills

Oracle SQL

PL/SQL

ETL/Informatica

Autosys

CI/CD

Tools

Java

Job description

Durham, United States

Contract: 6+ Months

Visa: USC/GC/H4 EAD, GC EAD

Job Summary

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.

Must‑Have Skills

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

Advanced SQL & Data Manipulation

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

Database Performance Tuning

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

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.

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

Requirements

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.