NWU PeopleSoft Database Optimization

NWU is renowned for its commitment to research and teaching. Over the years, as the university expanded its student base and business requirements, the need for an efficient and secure database system became increasingly evident. The university's database system, which had been in use for several years without a comprehensive review, was crucial for managing human resources, student records, customer information, and supply chain operations.

To tackle these challenges, a comprehensive database assessment was undertaken. The project involved a detailed review of the database architecture and infrastructure. The team focused on identifying performance bottlenecks and implementing solutions to improve query response times. Security measures were evaluated and enhanced to protect sensitive data. The project also included a review of monitoring controls and thresholds, along with an enhancement of backup and disaster recovery processes. A significant part of the solution was assessing the database's scalability to ensure it could handle future growth.

The project yielded significant improvements across the board. Query performance was enhanced through various optimization techniques, leading to faster and more efficient data processing. Security measures were strengthened, including the implementation of multi-factor authentication and data encryption, to safeguard sensitive information. The team proposed strategies for both horizontal and vertical scaling to accommodate future growth. A comprehensive backup and disaster recovery plan was developed to ensure data integrity and minimize downtime during critical events. Additionally, the project addressed the management of historical data and file attachments in the database and emphasized the importance of regular database maintenance and patching.