Oracle Transportation Management (OTM) Techno Functional consultant

Position: Technical Functional OTM Specialist

Type: Contract (Freelance)

Start Date: ASAP

Hours: US Eastern Time Zone (8:00am to 5:00pm EST) (5.30 to 2.30 IST)

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