• Provide day-to-day technical support for the University's existing ERP systems and assist in resolving database-related application issues.
• Write, execute, and modify SQL queries to retrieve data, generate reports, verify transactions, and support the information requirements of university departments.
• Investigate data discrepancies, missing transaction records, duplicate entries, and inconsistencies by reviewing relevant database records and ERP application screens.
• Coordinate with the ERP vendor to report technical issues, provide supporting information, follow up on reported problems, and verify the implementation of solutions.
• Generate routine and ad hoc reports from the ERP database based on requirements from management and relevant university departments.
• Assist in tracing ERP transactions across related database tables to identify missing records, incorrect references, and other data-related issues.
• Verify the accuracy and consistency of database reports and extracted information before providing them to authorized users.
• Assist with routine database monitoring, connectivity checks, and preliminary investigation of database-related errors.
• Assist in checking database backup status and report any identified issues to the responsible IT personnel.
• Support ERP system upgrades, patches, configuration changes, and enhancements by coordinating with the vendor and assisting with testing and validation.
• Maintain documentation of SQL queries, report specifications, technical issues, troubleshooting steps, and vendor communications.
• Follow up on ERP support requests and maintain records of reported issues, actions taken, and resolutions.
• Ensure that database access and information handling comply with the University's IT security policies, access control procedures, and data confidentiality requirements.
• Perform other related duties assigned by the IT management in support of the University's database , ERP applications and other Applications implemented in university like Moodle, Chatbot etc..