Oracle Transportation Management Analyst

Overview :

A leading logistics and transportation organization is seeking an experienced OTM Solutions Designer to lead system configuration, optimization, and integration efforts within Oracle Transportation Management (OTM). This role focuses on enhancing fleet operations, improving performance, and ensuring scalability across enterprise systems.

Requirements :

7+ years of experience in OTM solution design and configuration

Deep understanding of the OTM data model, fleet-specific tables, and driver / asset workflows

Proficiency in OTM configuration and automation (agents, workflow logic, event triggers)

Strong background 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

Skilled in capacity planning and ensuring system scalability and resilience

Strong analytical and problem-solving skills for complex OTM applications and infrastructure

Responsibilities :

Lead hands-on development within OTM Fleet Management modules, including driver management, power unit tracking, and dispatching

Configure and enhance OTM components (agents, workflows, statuses, route groups)

Develop and optimize PL / SQL procedures, triggers, and performance tuning scripts

Integrate OTM with external systems (web services, XML, middleware, telematics / ELD)

Monitor and troubleshoot OTM server-related issues, including log analysis and performance optimization

Perform root cause analysis for agent and workflow bottlenecks and integration delays

Resolve issues related to thread management, agent execution, and database deadlocks

Conduct database and table tuning to improve OTM performance

Collaborate with infrastructure teams on server load balancing, patching, and upgrades

Apply knowledge of transportation operations, fleet optimization, and regulatory compliance

Develop and maintain reporting and analytics tools using BI Publisher or Tableau

Conduct fit-gap analysis and design scalable fleet solutions with minimal customization

Familiarity with OTM Cloud migration and roadmap is a plus