مسؤول إدارة قواعد البيانات

Job Function

The Database Administrator will support the University's existing ERP systems, assist with SQL-based reporting and data analysis, investigate routine database-related issues, and coordinate with the ERP vendor to ensure the smooth operation of the systems.

Responsibilities

• 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..

Experience

• 0-2 years of related Experience • Knowledge in Oracle Database.

Skills

• Basic to intermediate knowledge of SQL and relational database concepts. • Familiarity with Oracle Database or other relational database management systems. • Ability to write SQL queries involving filtering, joins, sorting, and aggregate functions. • Basic understanding of ERP systems, database tables, and transaction relationships. • Good analytical, troubleshooting, and data verification skills. • Proficiency in Microsoft Excel and preparation of data reports. • Good communication skills and the ability to coordinate effectively with software vendors and university departments. • Willingness to learn the University's existing ERP system and database structure.

Qualification

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related discipline.