Manager - Infra and IT - SCO

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