Oracle Transportation Management (OTM) Consultant

Role Title : Sr. OTM Solutions Analyst Employment Type : Contract-to-Hire Duration : 6 month contract to hire Preferred Location : 4 days per week onsite in Cleveland, OH (open to assist with relocation) Role Description : Configure and enhance OTM (agents, workflows, statuses, and route groups). Strong PL / SQL skills for developing stored procedures, queries, triggers, and performance tuning. Integrate OTM with external systems (web services, XML, middleware, telematics / ELD). Monitor and troubleshoot OTM server-related issues, including application performance, log analysis, and environment stability. Perform root cause analysis for performance bottlenecks in agents, workflows, and integrations. Diagnose and resolve thread management, agent delays, and deadlocks within OTM. Conduct database tuning and table optimization to improve OTM performance. Collaborate with system administrators and DBAs on server load balancing, patching, and upgrades. Solid understanding of transportation, truckload operations, fleet optimization, and compliance. Develop and support reporting and analytics using BI Publisher and Tableau. Conduct fit-gap analysis and design scalable fleet solutions with minimal customization. Requirements : 7+ years hands-on development in OTM Deep knowledge of the OTM data model, fleet-specific tables, and driver / asset workflows. Proficiency in OTM configuration and automation (agents, workflow logic, event triggers). Strong skills in server performance tuning and OTM environment optimization. Advanced PL / SQL debugging and query optimization for high-volume transactions. Ability to analyze and resolve deadlocks, agent execution delays, and thread contention. Proficiency in capacity planning, ensuring system scalability and resilience. Strong problem-solving mindset for complex OTM application and infrastructure issues. Nice to Have : Familiarity with OTM Cloud migration and roadmap preferred. Fleet Management modules, including driver management, equipment / power unit tracking, dispatching, and the ability to translate business requirements into scalable OTM fleet solutions.