"Alerted.org

Job Description

We are seeking a Senior IT Solutions Analyst with strong Oracle Transportation Management (OTM) development experience to join our Cleveland team. This is a techno-functional role focused on designing, developing, and implementing solutions for transportation and logistics systems. You will become the face of the system, collaborating with operations and technical teams to ensure seamless integration and performance.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

Must-haves:

• 8+ years in OTM development

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

Job Requirements

• Development Focus: Approximately 70% of the role is hardcore development

• Upgrade Path: Current upgrade from OTM 6.4.3 (on-prem) to OTM 6.5.3, with cloud migration planned for 2027

• Hands-on expertise in OTM Fleet Management modules, including driver management, equipment/power unit tracking, dispatching, and the ability to translate business requirements into scalable OTM fleet solutions.

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

• Familiarity with OTM Cloud migration and roadmap preferred.