PLSQL Developer

highly skilled Oracle PL/SQL Developer

Key Responsibilities:

• Design, develop, and maintain

  PL/SQL procedures, functions, packages, triggers, and views

  .
• Work extensively on

  Oracle Manufacturing modules

  , including

  WMS, Inventory (INV), WIP, and BOM

  .
• Develop and support

  RICE components

  (Reports, Interfaces, Conversions, Extensions).
• Perform

  query optimization

  and

  performance tuning

  for PL/SQL code and database objects.
• Collaborate with functional teams to understand business needs and deliver technical solutions.
  
• Support

  production issues

  , including debugging, root cause analysis, and implementing fixes.
• Develop and maintain

  technical documentation

  for all customizations and integrations.

Required Skills:

• Strong hands-on experience in Oracle PL/SQL

  (stored procedures, functions, triggers, packages).
• Expertise in

  Oracle EBS Manufacturing modules

  , especially

  WMS

  .
• Good understanding of

  Inventory (INV)

  ,

  Work in Process (WIP)

  , and

  Bill of Materials (BOM)

  data models.
• Experience in developing

  interfaces, conversions, and custom reports

  .
• Solid knowledge of

  SQL performance tuning

  and

  query optimization

  .
• Exposure to

  Unix/Linux shell scripting

  .
• Excellent analytical, debugging, and communication skills.
  

Preferred Skills:

• Experience with

  Oracle Forms and Reports

  .
• Knowledge of

  Oracle Workflow

  ,

  BI Publisher

  , or

  OAF

  .
• Understanding of

  Supply Chain and Manufacturing business processes

  .
• Exposure to

  Oracle Cloud SCM / WMS

  is an added advantage.