Overview :
A leading logistics and transportation organization is seeking an experienced OTM Solutions Designer to lead system configuration, optimization, and integration efforts within Oracle Transportation Management (OTM). This role focuses on enhancing fleet operations, improving performance, and ensuring scalability across enterprise systems.
Requirements :
- 7+ years of experience in OTM solution design and configuration
- Deep understanding of the OTM data model, fleet-specific tables, and driver / asset workflows
- Proficiency in OTM configuration and automation (agents, workflow logic, event triggers)
- Strong background 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
- Skilled in capacity planning and ensuring system scalability and resilience
- Strong analytical and problem-solving skills for complex OTM applications and infrastructure
Responsibilities :
Lead hands-on development within OTM Fleet Management modules, including driver management, power unit tracking, and dispatchingConfigure and enhance OTM components (agents, workflows, statuses, route groups)Develop and optimize PL / SQL procedures, triggers, and performance tuning scriptsIntegrate OTM with external systems (web services, XML, middleware, telematics / ELD)Monitor and troubleshoot OTM server-related issues, including log analysis and performance optimizationPerform root cause analysis for agent and workflow bottlenecks and integration delaysResolve issues related to thread management, agent execution, and database deadlocksConduct database and table tuning to improve OTM performanceCollaborate with infrastructure teams on server load balancing, patching, and upgradesApply knowledge of transportation operations, fleet optimization, and regulatory complianceDevelop and maintain reporting and analytics tools using BI Publisher or TableauConduct fit-gap analysis and design scalable fleet solutions with minimal customizationFamiliarity with OTM Cloud migration and roadmap is a plus