Oracle Functional Consultant

Technical/Functional OTM Specialist

Position Overview

Position: Technical Functional OTM Specialist

Type: Contract (Freelance) from India

Hours: US Eastern Time Zone (8:00am – 5:00pm EST)

Seeking an experienced Oracle Transportation Management (OTM) Specialist to support

two major initiatives:

➢ OTM Upgrade Project – Complete an in-place upgrade to OTM version 6.5.3

across three environments by year-end.

➢ Enhancements– Develop and deploy functionality tailored to new business

needs.

This role requires deep technical and functional OTM expertise, with a strong emphasis on

system upgrades, functional development, database administration, and infrastructure

alignment.

Key Responsibilities

• Lead and execute OTM upgrade efforts across dev, test, and production

environments.

• Design and implement enhancements and new functionalities in OTM aligned with

business processes.

• Perform comprehensive testing for upgrades, customizations, and new features.

• Create, review, and optimize stored procedures, SQL queries, and database objects

to ensure performance

• Collaborate with infrastructure teams on database, server, and middleware

configurations

• Manage patching, versioning, and post-upgrade stability.

• Troubleshoot and resolve OTM-related issues.

• Provide documentation and knowledge transfer to internal teams.

• Participate in performance testing and support capacity planning

Qualifications

• 7+ years of hands-on experience with Oracle Transportation Management (OTM)

• At least 2 full lifecycle OTM upgrade projects, including upgrades to version 6.5x or

higher

• Strong expertise of OTM architecture, configuration, workflows, and integrations

points

• Experience with Oracle DB administration including schema updates, performance

tuning, and backup/recovery

• Understanding of OTM infrastructure components and middleware.

• Proficiency in SQL, PL/SQL; proven ability to create and optimize stored procedures

• Excellent communication, problem-solving, and cross-functional collaboration skills.

• Experience in transportation, logistics, or supply chain environments preferred.

• Familiarity with performance testing frameworks and OTM system capacity

• planning