Oracle Transportation Management

**MUST BE FLUENT IN ENGLISH; PLEASE APPLY WITH A RESUME WRITTEN IN ENGLISH TO DEMONSTRATE FLUENCY

Title: OTM Consultant

Location: Remote – sitting in Brazil

Duration: 8-month Contract w/ possible extensions (through end of 2025)

Pay Rate: $8-20/hr USD (may be some flexibility here based on experience)

Qualifications:

• 7+ years of hands-on experience with Oracle Transportation Management (OTM), including at least 2 full lifecycle OTM upgrade projects.
• Proven experience specifically with OTM upgrades to version 6.5.x or similar major releases.
• Strong technical and functional expertise in OTM architecture, workflows, configurations, and integration points.
• Experience with Oracle database administration tasks supporting OTM, including schema updates, performance tuning, and backup/recovery processes.
• Familiarity with infrastructure aspects such as server migrations, and middleware configurations related to OTM environments.
• Proficiency in SQL, PL/SQL, and creating/optimizing stored procedures.
• Excellent analytical, problem-solving, and troubleshooting skills.
• Ability to work independently, manage competing priorities, and deliver in a fast-paced environment.
• Strong communication skills to effectively collaborate with cross-functional teams and stakeholders.
• Exposure to working in large-scale logistics, transportation, or supply chain environments.
• Experience with performance testing and capacity planning for OTM environments.

Job Description:

We are seeking a highly skilled Technical Functional OTM Specialist to support our Oracle Transportation Management (OTM) upgrade across three environments. The goal is to complete the upgrade by the end of the year. This role involves developing new functionality, testing it thoroughly, and addressing updates and new versions.

Key Responsibilities:

• Lead the end-to-end OTM upgrade process across three environments, targeting completion by year-end.
• Develop and implement new functionalities in OTM aligned with business requirements.
• Conduct thorough testing of all enhancements, customizations, and system upgrades.
• Create, review, and optimize stored procedures, SQL queries, and database objects to ensure system performance and integrity.
• Collaborate with infrastructure teams to address database, server, and integration layer requirements for the upgrade.
• Ensure seamless handling of updates, patches, and new versions, maintaining system stability and performance.
• Troubleshoot and resolve technical and functional issues post-upgrade.
• Provide documentation, training, and knowledge transfer to internal teams as needed.