Role Title : OTM Consultant
Employment Type : Contract
Duration : 6-Month Contract (with potential extension)
Location : Remote – Mexico
About the Role :
We’re looking for an experienced Oracle Transportation Management (OTM) Technical-Functional Consultant to support two major initiatives :
- Leading an on-premise upgrade to OTM v6.5.3 across three environments by year-end.
- Developing and enhancing OTM functionality for our Epes General Commodity business model.
This role is ideal for a professional who can bridge the gap between technical expertise and functional understanding—driving innovation, ensuring system performance, and leading upgrades from end to end.
What You’ll Do :
Own the OTM upgrade process across multiple environments.Design, develop, and implement new OTM functionalities and enhancements.Conduct comprehensive testing for upgrades, integrations, and configurations.Optimize SQL queries, stored procedures, and database performance.Collaborate with infrastructure teams on server, database, and middleware support.Troubleshoot technical and functional issues post-upgrade and ensure stability.Provide documentation and knowledge transfer to internal teams.What You’ll Bring :
7+ years of OTM experience with at least 2 full lifecycle upgrades (preferably to v6.5.x or higher).Strong mix of 60% technical / 40% functional expertise.Deep knowledge of OTM architecture, workflows, and integrations.Hands-on experience with Oracle DB administration , SQL / PLSQL tuning, and backup / recovery.Familiarity with infrastructure and middleware supporting OTM environments.Excellent analytical, troubleshooting, and communication skills.Background in logistics, transportation, or supply chain environments preferred.