Job Description

• Ensure 99.9% system availability for all terminals, and 24/7 support of production system services to ensure the highest standards of availability, resilience, integrity and performance required for TOS  application & auxiliary systems like VMT/HHT, RFID, OCR, Web Portals, Weight Scale Integration, PDS / DGPS etc..
• First line to fix problems with the TOS, eg. when TOS is down the whole terminal is down which is a huge business risk; and related end-points, Integration –API.
• Maintain EDI, work with SPOCs and external customers on their needs for reports, EDI etc
• Monitor and ensure the proper documentation of the manual, project documents, change requests etc and approve the final versions.
• Performance monitoring, reporting, and fine-tuning of TOS Application & Configuration. 
• Management and maintenance of back-ups & recovery procedure of TOS
• Installation and maintenance of TOS Setup, replication and client environments. 
• Reviewing and tuning SQL and PL/SQL code; designing Logics and Reports. 
• Security and access control. 
• Provision of support and assistance to development team in the design, development, testing, tuning and implementation of TOS database applications 
• Creation and maintenance of SQL queries and routines in TOS 
• Provisioning of TOS Solution development and testing environments. 
• Writing ad-hoc queries based on schema knowledge for various reporting requirements. Writing / tuning data ingestion procedures from external suppliers and partners using PL/SQL, sql loader, 3rd party tools. 
• Required to deal with complex data models and object relational database mapping, while producing complex reports
• TOS and related training and familiarization session
• TOS Process improvements and Enhancement recommendation
• Ensure PROD and DR setup and perform recovery testing on defined routines as per business requirements.
• Co-ordinate with SPOC and interact with Zodiac and other team members for Automation software’s.
• All other duties assigned by Head TOS/ Head Shared Service time to time.
• Maintain the software and version at Site.
• Work in shifts for 24x7 support