Detect and address issues before they affect service delivery.
The Database Administration (DBA) service offers comprehensive, reliable, and secure database management for the University. This service includes a range of administration, maintenance, monitoring, and support activities, ensuring your critical data infrastructure is always available and performing optimally. We provide a variety of database administration services tailored to support the University's application delivery and operational needs. Our support covers Oracle, MySQL, MongoDB, and Microsoft SQL Server databases. Covering administrative and academic applications databases.
Security, SSO and Access Management
Identity and Access Management (IAM): We manage user identities and access privileges for databases, ensuring only authorized individuals and systems can access your data. This includes: Security Identity Governance: We establish and enforce security policies, covering user de-provisioning, role-based access control (RBAC) implementation, privilege management, and auditing of database access. This ensures compliance with university security standards and data governance policies. Single Sign-On (SSO): We integrate database access with the University's SSO systems where applicable. This provides a streamlined and secure authentication experience for users, reducing password fatigue and enhancing overall security.
Database Creation
Creation of new databases to support the delivery of university applications and services.
Maintenance and Patching
Routine maintenance and timely patching of University databases and Enterprise Resource Planning (ERP) application platforms to ensure security, stability, and performance.
Monitoring and Reporting
Workload and Performance: Continuous monitoring and regular reporting on database and ERP application workload and performance to identify trends and potential bottlenecks. Storage Growth: Tracking and reporting on the growth of database storage to facilitate capacity planning and proactive management.
Cloning
Efficient cloning of databases and ERP applications for development, testing, or other purposes.
Troubleshooting and Optimization
Expert troubleshooting of database issues and performance optimization to ensure efficient data access and application functionality.
Backup and Restore
Comprehensive backup solutions and reliable restore capabilities to protect critical data and ensure business continuity.
Specialized Support
Support for Production and Critical Development Databases: For production or critical development databases, we provide continuous, around-the-clock support. This includes constant monitoring to detect and proactively address potential problems before they can impact service delivery. Oracle Advanced Secuity Oracle Real Application Clusters (RAC) Support: Specialized support for Oracle RAC environments, ensuring high availability and scalability for critical Oracle databases.