Senior OTM Solutions Analyst - Remote (EST Support)

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. #J-18808-Ljbffr