OTM Solution Analyst

**NO 3rd Parties or Sponsorship!

Role Title: Sr. OTM Solutions Analyst

Duration: 6 month contract to hire

Preferred Location: Remote, open to supporting EST time zone as needed

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