Database

Definition

The database departement is responsible for monitoring the performance and integrity of databases at the university, and for the safety and availability of application platforms.


Objectives 

The department also aims to harness the power of large and complex datasets to more important insights into informed decisions, problem solving and risk analysis. While aggregate data are important, the compilation of databases into useful and implementable information through innovative analyzes and business intelligence that support rapid decision-making and improved operational efficiency.


Departement Units 

It is divided into three main units:

  • Database module

  • Application Platforms and Intermediate Software Unit


Database module Unit

The database unit is responsible for all the basic databases at Taif University from the design, implementation, architecture, performance, integrity and security of the databases. Also provide daily operational support for databases and troubleshooting to determine root cause if database failure occurs. The database unit is used to provide expertise in the event that new products or contracts relating to databases are considered. The database unit is also responsible for managing and operating its own infrastructure of servers, operating systems, storage units and networks in the presence of the Engineered System.

Unit Functions 

  1. Install and upgrade their databases and servers.

  2. Design and documentation of database models.

  3. Design of data storage operations and smart platforms.

  4. Development of charts, tables and procedures for databases.

  5. Data sharing and partitioning of the hard drive.

  6. Identification of the uses of databases and automatic reports.

  7. Create programming languages ​​such as shell scripts to automate tasks.

  8. Create, test and apply data management languages.

  9. Capacity analysis and performance requirements.

  10. Analyze, integrate and modify databases to maximize efficiency.

  11. Monitoring systems and platforms to ensure availability.

  12. Supervise data backup, replication, compilation and copying, and overcome failures or failures when they occur.

  13. Restoring damaged data.

  14. Download and experiment and apply updates and patches (patches).

  15. Application of security controls and encryption.

  16. Providing technical support throughout the week for emergencies.

  17. Evaluation and recommendation of new technology in the field of databases.

  18. Develop and maintain system documents related to Oracle Exadata and other configuration software.

  19. Evaluate overall performance of databases and make recommendations for improved performance.

  20. Monitor and maintain important hardware information for your Exadata database device.

  21. Monitor and process alerts for Oracle Exadata database device.


Application platform and middleware platform Unit

 This unit is responsible for all platforms hosting essential software and applications such as Apache, IIS Web Server, Weblogic and JBOSS, as well as managing smart phone platforms. It is also responsible for running and managing the middleware of managing and operating the Service Oriented Architecture (SOA) and SSO Management. It is also the responsibility of the unit to manage and coordinate complementarity with foreign organizations such as the program of transition to electronic transactions (pleased) and integration with banks and other universities. The unit is also responsible for the management and operation of its own infrastructure of servers, operating systems, storage units and networks in the presence of Engineered Systems for application platforms.

Unit Functions

  1. Supervision in planning, evaluation, architecture, implementation and validation of new / emerging technologies in Oracle WebLogic and Identity Access Management.

  2. Provide recommendations for system architecture and approvals for major improvements to existing systems.

  3. Unification of virtual environments, command installation and configuration, backup and recovery tools technologies, application platforms and middleware.

  4. Support security, controls and appropriate audit procedures to ensure the safety of applications.

  5. Implement promotions and SSO using Oracle Access Manager / Oracle Identity Manager or any other login solutions.

  6. Review application performance metrics and proactively address performance issues by improving settings and configurations.

  7. Publish, support and implement both DEV, QA, PROD and Disaster Recovery environments.

  8. Troubleshooting to reduce downtime.

  9. Determine the operating systems and servers needed to implement a new system or to modify the current system to perform new tasks or improve the workflow.

  10. Work with system development staff to identify project requirements for test / production environments.

  11. Develop and maintain system documents related to Oracle Exalogic and other configuration software.

  12. Monitor and maintain important hardware information for your Exalogic database device.