Sr. OTM Solutions Analyst

About the Role

Role Title : Sr. OTM Solutions Analyst

Duration : 6 month contract to hire

Preferred Location : 4 days onsite in Beachwood, OH

Responsibilities

• 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.

Qualifications

• 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.

Preferred Skills

• 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.

Pay range and compensation package $55-$60 / hr W2