Oracle PL / SQL Developer

Compunnel, Inc.; Oregon (WI); On-site; USD 90,000 - 115,000; Full time

Job summary

A technology consulting firm is seeking an Oracle PL/SQL Developer to join an Agile team in a fast-paced environment. The role requires designing, coding, and mentoring in Oracle EBS solutions. Candidates must have strong skills in Oracle SQL and PL/SQL, with experience in performance tuning and Agile methodologies. The position involves collaboration with technical and business stakeholders to deliver effective solutions and support team development. This is an opportunity to enhance your expertise in a dynamic setting.

Qualifications

• Experience as a technical team member in an Oracle EBS development environment.
• Exceptional proficiency in Oracle SQL and PL/SQL.
• Strong SQL performance tuning experience using Explain Plans and indexes.

Responsibilities

• Support PL/SQL development within an Agile Oracle EBS development environment.
• Design, develop, test, debug, and document Oracle EBS technical components.
• Collaborate with teams to understand requirements and deliver solutions.

Skills

Oracle SQL

PL/SQL

Agile methodologies

SQL performance tuning

Team collaboration

Tools

Bitbucket

Rally

STAT

Job description

We are seeking an Oracle PL/SQL Developer to join an Agile development team in a fast-paced Oracle EBS environment.

The role involves designing, coding, testing, debugging, and documenting custom Oracle EBS technical components.

The candidate will collaborate with technical and business stakeholders to translate requirements into high-performing solutions and will also support team development through mentoring and best practices.

Key Responsibilities

• Support PL/SQL development within an Agile Oracle EBS development environment.
• Design, develop, test, debug, and document custom Oracle EBS technical components.
• Collaborate with business and technical teams to understand requirements and deliver effective technical solutions.
• Train team members and mentor junior developers to enhance overall development capabilities.
• Use Oracle Analytic functions to build high-performance SQL queries.
• Apply SQL performance tuning techniques using Explain Plans, indexes, optimizer hints, SQL profiles, and related tools.
• Work with Oracle Concurrent Manager setups including program/executable definitions and request set configurations.
• Manage Oracle EBS components such as menus, functions, responsibilities, lookups, value sets, profile options, and request groups.
• Utilize Oracle REST Data Services (ORDS) for API setup and configuration.
• Work with Oracle CRM entities including resources, roles, groups, and hierarchies.
• Apply knowledge of Oracle SOA Gateway, REST/SOAP architectures, and JSON data formats.
• Use tools such as Bitbucket, Rally, and STAT for code migration.
• Participate in Agile ceremonies including stand-ups, sprints, retrospectives, and user story grooming.

Required Qualifications

• Experience as a technical team member in an Oracle EBS development environment.
• Strong team collaboration and communication skills.
• Exceptional proficiency in Oracle SQL and PL/SQL.
• Experience using Oracle Analytic functions for high-performance SQL development.
• Strong SQL performance tuning experience using Explain Plans, indexes, optimizer hints, and SQL profiles.
• Expertise in setting up and configuring Oracle REST Data Services (ORDS) APIs.
• Experience working with Oracle Concurrent Manager frameworks and configurations.
• Knowledge of menus, responsibilities, functions, lookups, value sets, profile options, and request groups in Oracle EBS.
• Familiarity with Oracle CRM entities and underlying data structures.
• High-level understanding of Oracle SOA Gateway, REST/SOAP API architectures, and JSON formats.
• Experience with Agile development processes.
• Experience with tools such as Bitbucket, Rally, and STAT (preferred).

Preferred Qualifications

• Experience with Agile methodologies including features, user stories, sprints, and retrospectives.
• Experience with performance tuning and high-volume Oracle EBS solutions.