Oracle PL​/SQL Developer

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.

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

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

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