ConsultNet Technology Services and Solutions · 10 hours ago
Oracle Application Specialist
United States
Contract
Remote
Senior Level
$65/hr - $77/hr
7+ years expConsultNet Technology Services and Solutions is seeking a highly skilled Senior OTM Technical-Functional Analyst to design, develop, and implement advanced solutions for transportation and logistics systems. The role requires deep expertise in Oracle Transportation Management (OTM) and strong technical development capabilities to ensure optimal system integration and performance.
Human ResourcesInformation TechnologyStaffing Agency
Hiring Manager
Brett Campbell, CIR
Responsibilities
Configure, enhance, and optimize OTM components including agents, workflows, statuses, and route groups
Develop advanced PL/SQL packages, stored procedures, queries, triggers, and perform database performance tuning
Integrate OTM with external systems using web services, XML, middleware platforms, ELD/telematics solutions, and APIs
Monitor OTM servers and environments, resolving issues related to application performance, logs, threading, and system stability
Perform root cause analysis for performance bottlenecks within workflows, agents, and integrations
Diagnose and resolve thread management issues, agent delays, deadlocks, and contention within OTM
Conduct database tuning, query optimization, and table/index maintenance to improve OTM performance
Collaborate with DBAs and system administrators on server load balancing, patching, upgrades, and capacity planning
Apply strong transportation and fleet domain expertise, including truckload operations, dispatch, compliance, and asset utilization
Develop and support dashboards, analytics, and reporting using BI Publisher and Tableau
Perform fit-gap analysis and design scalable, low-customization OTM fleet solutions aligned with business needs
Qualification
Required
7+ years of hands-on Oracle Transportation Management (OTM) development experience
Deep understanding of OTM data structures, fleet-specific tables, driver/asset workflows, and transaction lifecycles
Proven proficiency in OTM configuration—agents, workflow logic, automation, and event triggers
Strong background in OTM environment optimization and server performance tuning
Advanced PL/SQL debugging, query optimization, and handling of high-volume OTM transactions
Ability to analyze and resolve thread contention, deadlocks, queue/agent delays, and integration failures
Experience in OTM scalability planning, performance testing, and environment resilience
Strong analytical and problem-solving skills for complex OTM, integration, and infrastructure issues
Preferred
Experience with OTM Cloud migrations, architecture, or roadmap planning
Familiarity with OTM Fleet Management modules, including: Driver and equipment management, Dispatching and routing, Power unit/asset tracking, Translating operational requirements into scalable OTM fleet configurations
Company
ConsultNet Technology Services and Solutions
ConsultNet is a talent solutions company that helps businesses solve complex challenges by integrating talent, technology, and scalable delivery models.
201-500 employees
H1B Sponsorship
ConsultNet Technology Services and Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (6)
2023 (7)
2022 (6)
2021 (6)
2020 (9)
Funding
Current Stage
Growth StageLeadership Team
Marnie Nuttall
Chief Financial Officer
Company data provided by crunchbase