OTM Consultant

Role Title : OTM Consultant

Duration : 6 Month Contract, possible extension

Preferred Location : Remote in Mexico

Role Description :

This team is seeking a skilled Technical Functional OTM Specialist to support two key projects. First our OTM upgrade initiative across three environments. The primary goal is to successfully complete the on-premises / in place upgrade to OTM version 6.5.3 by the end of the year. Second to develop OTM enhancements for our Epes General Commodity business model.

This role requires a deep understanding of both technical and functional aspects of OTM, with an emphasis on developing new functionality, comprehensive testing, Additionally, expertise in database administration and infrastructure support related to OTM environments is required. The specific skill sets required for either project are below.

Key Responsibilities :

• 60% technical and 40% functional
• 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.

Requirements :