PL/SQL

SQL Performance Tuning
Installed BASE Experience(OIB/IB)
Order Management Experience(OM)
Job Description:
The candidate will be responsible for supporting PL/SQL development being part of an Agile team in a fast-paced Oracle EBS development environment. Responsibilities include program design, coding, testing, debugging and documentation of custom Oracle EBS technical components. The candidate must be able to work directly with technical and business representatives to understand requirements and should be able to translate these requirements to high performing technical solutions. Responsibilities also include training team members and increasing development capabilities of the development team through mentorship and best practices.
Qualifications
Must have experience working as a Technical team member in an Oracle EBS development environment, specifically with ‘Order Management’ and ‘Installed Base’ modules
Must be a great Team Player with excellent communication and collaboration skills
Must be extremely proficient in Oracle SQL and PLSQL
Must have experience with SQL Performance Tuning techniques using Explain Plans, Indexes, Optimizer Hints, SQL Profiles etc.
Should have experience working with the Oracle Concurrent Manager framework and setups (Concurrent Program/Executable definitions, Request Set definitions etc.)
Should have experience working with Menus, Functions, Responsibilities, Lookups, Value Sets, Profile Options, Request Groups etc.
Should be familiar with Oracle CRM entities such as Resources, Roles, Groups, Group Hierarchies etc. and the underlying tables behind these entities
Experience working with Bitbucket, Rally and STAT (for Code migration) is a plus.
Familiarity with developing software in an Agile environment (using Features, User Stories, Sprints, Standups, Retros etc.) is a plus
Job Types: Full-time, Contract
Pay: $68.01 - $69.86 per hour
Expected hours: 40 per week

Benefits:

• Health insurance

Compensation Package:

• Hourly pay

Schedule:

• 8 hour shift

Ability to Commute:

• Roseland, NJ 07068 (Preferred)

Ability to Relocate:

• Roseland, NJ 07068: Relocate before starting work (Preferred)

Work Location: In perso

Please refer the Job description for details