Job Title:
Allocations Techno-Functional Engineer (PL/SQL Expert)

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'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 setting
- 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 Orac

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