Job Title:
Oracle Retail Technical Consultant (Strong PL/SQL Expertise)

Location:
India (Remote/On-site as applicable)

Shift:
11:00 AM – 8:00 PM IST, plus on-call availability from 8:00 PM – 10:30 PM IST for alert response (in alignment with onsite support resource coverage)

Engagement Type:
Full-time with Samay Consulting

About the Role

We are looking for an Oracle Retail Technical Consultant with deep PL/SQL expertise to support a retail merchandising and allocations landscape. Hands-on experience with Oracle Retail (RMS/RPM/SIM) or Blue Yonder / JDA (any module) or a comparable retail merchandising, allocation, or planning platform. You will own the data feeds that move merchandise, inventory, and hierarchy data from Oracle Retail into BY/JDA Allocations, and you will also build and support custom extensions within Oracle Retail itself. Strong PL/SQL is the core requirement, along with good functional knowledge of retail supply chain processes.

What You'll Do
- Design, support, and troubleshoot the data feeds from Oracle Retail into BY/JDA Allocations,



including extract logic, interface tables, staging layers, reconciliation, and failure recovery
- Develop and maintain customizations within Oracle Retail, including custom PL/SQL packages, extensions to base functionality, custom tables and views, and batch programs
- Support, maintain, and troubleshoot a heavily customized BY/JDA (Blue Yonder) Allocations environment
- Write and optimize Oracle PL/SQL, including stored procedures, materialized view refreshes, and batch job scripting
- Diagnose and resolve Oracle errors (ORA-xxxxx) across both the Oracle Retail and Allocations environments
- Orchestrate batch jobs via Shell scripting, including trigger file management and SSH-based operations
- Build automation scripts, data validation tooling, and DAG support using Python
- Perform Oracle database operations including query tuning, index analysis, and materialized view strategy (QUICK vs. COMPLETE refresh)
-

📌 Oracle Retail Technical Consultant (India)
🏢 Samay Consulting
📍 India