Job Title: Allocations Techno-Functional Engineer (PL/SQL Expert)
Location: India (Remote/In office 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're looking for an Allocations Techno-Functional Engineer to support and maintain a heavily customized BY/JDA Allocations environment. This role blends strong functional knowledge of retail allocations with deep PL/SQL expertise, and is critical to keeping a complex, highly customized allocations platform stable and performant.

What You'll Do
Support, maintain, and troubleshoot a heavily customized BY/JDA (Blue Yonder) Allocations module
Understand and work within the business process and logic of retail allocations (experience with any allocations platform — BY/JDA, Oracle Retail Allocations, or similar — is valuable)
Write and optimize Oracle PL/SQL, including stored procedures, materialized view refreshes, and batch job scripting




Diagnose and resolve Oracle errors (ORA-xxxxx) across the environment
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 (FAST vs. COMPLETE refresh)
Ramp up on client-specific customizations to the BY/JDA Allocations module
Respond to alerts during the extended on-call window (8:00 PM – 10:30 PM), in alignment with onsite support resource coverage

Required Qualifications
Strong hands-on expertise in Oracle PL/SQL (stored procedures, MV refresh, batch scripting, error diagnosis)
Proficiency in Shell scripting for batch orchestration and SSH-based operations
Working knowledge of Python for automation, data validation, and DAG support
Solid Oracle database operations experie

📌 Allocations Techno Functional Engineer with expertise in PL/SQL (India)
🏢 Samay Consulting
📍 India