What are the responsibilities and job description for the Oracle Transportation Management Analyst (JOB ID 002692) position at Innovien Solutions?
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