Senior OTM Solutions Analyst – Remote (EST Support)

Bayforce; United States; Remote; USD 100,000 - 130,000; Full time

Job summary

A leading solutions provider is hiring a Senior OTM Solutions Analyst for a fully remote role focusing on configuring and optimizing Oracle Transportation Management. The ideal candidate has over 7 years of OTM development experience and expertise in PL/SQL. Responsibilities include system integration, performance tuning, and developing reports. This is a contract-to-hire position, offering a unique opportunity to enhance transportation operations.

Qualifications

• 7+ years of hands-on OTM development experience.
• Deep knowledge of the OTM data model and workflows.
• Expertise in OTM configuration and automation.

Responsibilities

• Configure and enhance OTM for optimized operations.
• Develop and tune PL/SQL procedures and queries.
• Integrate OTM with external systems.

Skills

OTM development

PL/SQL

Transportation management

Performance tuning

Integrations

Problem-solving

Tools

Tableau

BI Publisher

Job description

Role Title: Senior OTM Solutions Analyst – Remote (EST Support)

Employment Type: Contract-to-Hire

Duration: 6 months, with potential for extension

Location: Fully remote, with occasional support for EST time zone

About the Role

We are seeking a highly skilled Senior OTM Solutions Analyst to configure, enhance, and optimize Oracle Transportation Management (OTM) for fleet and transportation operations. This is a fully direct-hire engagement—we do not work with third-party vendors or agencies.

You will take ownership of OTM development, performance tuning, integrations, and reporting while collaborating with system administrators and DBAs to ensure a stable, high-performing environment. The ideal candidate has deep expertise in OTM configuration, PL/SQL, and transportation/fleet management processes.

Key Responsibilities

• Configure and enhance OTM (agents, workflows, statuses, route groups) for optimized operations.
• Develop and tune PL/SQL procedures, queries, triggers, and high-volume transaction processes.
• Integrate OTM with external systems via web services, XML, middleware, and telematics/ELD.
• Monitor and troubleshoot OTM performance, logs, thread management, and environment stability.
• Conduct root cause analysis for bottlenecks in agents, workflows, and integrations.
• Perform database tuning, table optimization, and server load balancing with DBAs.
• Develop BI Publisher and Tableau reports to support operations and analytics.
• Conduct fit-gap analysis and design scalable OTM fleet solutions with minimal customization.

Required Qualifications

• 7+ years of hands-on OTM development experience.
• Deep knowledge of the OTM data model, fleet-specific tables, and driver/asset workflows.
• Expertise in OTM configuration and automation (agents, workflow logic, event triggers).
• Strong skills in server performance tuning and environment optimization.
• Advanced PL/SQL debugging and query optimization.
• Experience resolving deadlocks, agent delays, and thread contention.
• Proficiency in capacity planning and scalable system design.
• Strong problem-solving mindset for complex OTM application and infrastructure challenges.

Preferred Qualifications

• Experience with OTM Cloud migration and roadmap.
• Fleet Management modules: driver management, dispatching, equipment/power unit tracking.
• Ability to translate business requirements into scalable OTM fleet solutions.