What are the responsibilities and job description for the Sr. OTM Solutions Analyst position at Bayforce?
**NO 3rd Party vendor candidates or sponsorship**
Role Title: Sr. OTM Solutions Analyst
Client: Solution Chain and Transportation and Logistics Solutions
Employment Type: Contract-to-Hire
Duration: 6 month contract to hire
Preferred Location: 4 days onsite in Beachwood, OH
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.
