Sr. OTM Solutions Analyst

Bayforce•Beachwood, OH

35d•Onsite

About The Position

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 Haves

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

Responsibilities

Configure and enhance OTM (agents, workflows, statuses, and route groups)
Develop stored procedures, queries, triggers, and performance tuning using PL/SQL
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
Develop and support reporting and analytics using BI Publisher and Tableau
Conduct fit-gap analysis and design scalable fleet solutions with minimal customization