Technical Functional OTM Specialist

Position: Technical Functional OTM Specialist

Type: Contract (Freelance) Offshore INDIA

Start Date: ASAP

Shift Timings: 6:30pm IST to 2:30am 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

• • 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