Chelsoft Solutions
PL SQL Developer Roseland, NJ (W2 only)
The candidate will be responsible for supporting PL/SQL development as 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 translate these requirements into high-performing technical solutions. Responsibilities also include training team members and increasing development capabilities of the development team through mentorship and best practices. Responsibilities Support PL/SQL development as part of an Agile team in a fast-paced Oracle EBS environment; design, code, test, debug and document custom Oracle EBS technical components. Collaborate directly with technical and business representatives to understand requirements and translate them into high-performing technical solutions. Mentor and train team members to increase development capabilities and promote best practices.
Work arrangements
Hybrid work arrangement: 3 days per week in Roseland, NJ. Interview will be conducted in one round (virtual). Must Haves
Oracle EBS PL/SQL SQL Performance Tuning (Explain Plans, Indexes, Optimizer Hints, SQL Profiles, etc.) Oracle Analytic Functions
Nice to Haves
Oracle Rest Data Services (ORDS) APIs Oracle Concurrent Manager Oracle CRM Oracle SOA Experience with Bitbucket, Rally and STAT for code migration is a plus Experience developing in an Agile environment (Features, User Stories, Sprints, Standups, Retros) is a plus
Qualifications
Must have experience working as a technical team member in an Oracle EBS development environment Must be a strong team player with excellent communication and collaboration skills Must be highly proficient in Oracle SQL and PL/SQL Must have experience using Oracle Analytic functions to write high-performing SQL queries Must have experience with SQL Performance Tuning techniques using Explain Plans, Indexes, Optimizer Hints, SQL Profiles, etc. Should be familiar with Oracle REST Data Services (ORDS) APIs Should have experience 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 Should have a high-level understanding of Oracle SOA Gateway, REST/SOAP API Architectures and JSON data formats Experience with Bitbucket, Rally and STAT for code migration is a plus Familiarity with developing software in an Agile environment (Features, User Stories, Sprints, Standups, Retros) is a plus
Seniority level
Entry level Employment type
Contract Job function
Information Technology Industries
IT Services and IT Consulting
#J-18808-Ljbffr
The candidate will be responsible for supporting PL/SQL development as 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 translate these requirements into high-performing technical solutions. Responsibilities also include training team members and increasing development capabilities of the development team through mentorship and best practices. Responsibilities Support PL/SQL development as part of an Agile team in a fast-paced Oracle EBS environment; design, code, test, debug and document custom Oracle EBS technical components. Collaborate directly with technical and business representatives to understand requirements and translate them into high-performing technical solutions. Mentor and train team members to increase development capabilities and promote best practices.
Work arrangements
Hybrid work arrangement: 3 days per week in Roseland, NJ. Interview will be conducted in one round (virtual). Must Haves
Oracle EBS PL/SQL SQL Performance Tuning (Explain Plans, Indexes, Optimizer Hints, SQL Profiles, etc.) Oracle Analytic Functions
Nice to Haves
Oracle Rest Data Services (ORDS) APIs Oracle Concurrent Manager Oracle CRM Oracle SOA Experience with Bitbucket, Rally and STAT for code migration is a plus Experience developing in an Agile environment (Features, User Stories, Sprints, Standups, Retros) is a plus
Qualifications
Must have experience working as a technical team member in an Oracle EBS development environment Must be a strong team player with excellent communication and collaboration skills Must be highly proficient in Oracle SQL and PL/SQL Must have experience using Oracle Analytic functions to write high-performing SQL queries Must have experience with SQL Performance Tuning techniques using Explain Plans, Indexes, Optimizer Hints, SQL Profiles, etc. Should be familiar with Oracle REST Data Services (ORDS) APIs Should have experience 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 Should have a high-level understanding of Oracle SOA Gateway, REST/SOAP API Architectures and JSON data formats Experience with Bitbucket, Rally and STAT for code migration is a plus Familiarity with developing software in an Agile environment (Features, User Stories, Sprints, Standups, Retros) is a plus
Seniority level
Entry level Employment type
Contract Job function
Information Technology Industries
IT Services and IT Consulting
#J-18808-Ljbffr