Lead PL / SQL Developer

Prime Vendor : Dale Work Force

Title : Lead PL / SQL Developer

Client : ADP

Location : Roseland, NJ 3x on site Tuesday, Wednesday, Thursday

Rate : Up to 65 per hour c2c

Position Summary :

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

• Technical team member in an Oracle EBS development environment
• Proficient in Oracle SQL and PLSQL
• Oracle Analytic functions to write high performing SQL queries.
• SQL Performance Tuning techniques using Explain Plans, Indexes, Optimizer Hints, SQL Profiles etc.
• Configuring Oracle REST Data Services (ORDS) APIs
• Oracle CRM entities such as Resources, Roles, Groups, Group Hierarchies etc. and the underlying tables
• Understanding of Oracle SOA Gateway, REST / SOAP API Architectures and JSON data formats
• Experience working with Bitbucket, Rally and STAT (for Code migration) is a plus.