Summary
A'Sharqiyah University is seeking a Database Administrator to support its ERP systems and other applications. The role involves writing SQL queries, preparing reports, investigating data discrepancies and database issues, and coordinating with the ERP vendor on fixes and system changes. The successful candidate will have 0–2 years of related experience, knowledge of Oracle Database, and a bachelor's degree in a relevant discipline. Strong analytical, troubleshooting, reporting, and communication skills are required.
The posting
As published on asu.edu.om. Pulled from the employer's site and shown as they wrote it.
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.