Here is Oracle JD
Job Position – Senior Oracle PL/SQL Developer.
Oracle PL/SQL developer supporting the OTC Order to Cash system, which is an Oracle SQL application that utilizes stored procedures, batch processes, Oracle Forms UI, and Reports. Will work as part of a team with daily meetings.
Knowledge - Must Haves
1. Knowledge of Oracle Collections and Bulk Collect.
2. DB Type
3. Indexes
4. Triggers
5. Packages, Procedure and functions.
6. Oracle Forms.
7. Knowledge of Oracle 12c features
8. Experience with performance tuning
9. Some experience with Oracle Reports which OTC uses and is a frequent cause of tickets
10. Good interpersonal skills and communication
Nice to Have
1. MV
2. Dynamic SQL
Candidates should demonstrate a knowledge of debugging, as well as strategy and design.