Oracle PL/SQL Developer Database Developer

Premier Inn Hotels LLC (UAE); Town of Texas, Northern (WI, KY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Premier Inn Hotels LLC (UAE) seeks a Senior Oracle PL/SQL Developer in the United States (Wisconsin) with 10–15 years of hands-on Oracle SQL/PL/SQL experience. This is a highly technical, non-management role requiring practical problem solving and strong coding skills.

The role focuses on designing complex database solutions, ETL workflows with Informatica, and collaboration with distributed teams. Candidates will be tested on real-world scenarios during interviews.

Qualifications

• 10–15 years of hands-on Oracle SQL/PL/SQL experience required.
• Deep, current PL/SQL development expertise essential.
• Not a management-focused position; hands-on engineering only.

Responsibilities

• Design, develop, test, and maintain complex Oracle SQL and PL/SQL solutions.
• Develop stored procedures, packages, and transactional data models.
• Analyze and optimize database performance and batch jobs.
• Translate requirements into scalable data-centric solutions; participate in design/code reviews.
• Develop automated test cases and support regression testing.
• Collaborate with distributed teams and provide technical mentorship.

Skills

Oracle SQL

PL/SQL

Data modeling

ETL tooling

CI/CD

ATDD

Regression testing

Performance tuning

Tools

Informatica

Autosys

Job description

West lake, United States | Posted on 09/03/2026

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.