Position: Oracle EBS Technical Architect with SCM Exp
Location: Remote
Job Type: Contract
Duration: Long term
Pay Range: $/hr
Skills:
Must Have Technical/Functional Skills
Oracle EBS R12 (12.1/12.2) SCM internals; strong in OM, INV, WSH, PO, BOM, WIP, CST, QA.
CEMLI architecture; PL/SQL optimization; BI Publisher, Oracle Reports; OAF/Java customizations; Forms personalization; Workflows.
12.2 online patching (adop), editioning/EBR concepts, driver/file management.
Integrations: ISG (REST/SOAP), ORDS for REST, EDI (X12/EDIFACT), 3PL/TMS, file-based and middleware patterns (SOA/OIC/Mule/Kafka).
Performance: AWR/ASH, SQL Profiles, partitioning; concurrent manager tuning.
DB & App: Oracle DB 12c/19c, WebLogic, EBS tech stack administration concepts (working knowledge).
Good to have skills:
Exposure to ASCP/Demantra, EAM, Costing close performance improvements.
Experience with spin‑offs/divestitures: data carve‑out, object rationalization, cutover orchestration.
Cloud/OCI fundamentals (object storage, OAC, GoldenGate/ODI), security (IDCS/SSO).
Knowledge of tax engines (Vertex), shipping systems (FedEx/UPS/Loftware), and finance touchpoints (AR/AP/GL impacts).
Roles & Responsibilities
1) Architecture & Solution Design
Define and govern target technical architecture for Oracle EBS R12 SCM (OM, INV, WSH, PO, BOM, WIP, CST, QA, ASCP).
Lead fit–gap, solution blueprints, and HLD/LLD for RICEW (Reports, Interfaces, Conversions, Extensions, Workflows).
Establish coding standards (PL/SQL, OAF/Java, Oracle Forms, BI Publisher, Oracle Reports) and reusable patterns.
Guide 12.2.x online patching (adop) compliance: file system standards, editioning views, EBR-safe objects.
2) Integrations & Data
Architect integrations with 3PLs/Carriers, EDI (850/855/856/810), TMS/WMS, MES, CRM, Tax, Banking.
Ensure data quality, idempotency, and reconciliation frameworks; design error handling & reprocessing.
—