The Auxiliary IT Operation center at the Indiana University has a lot of responsibility on its plate. It is in charge of the majority of for-profit activities the university is engaged in, namely the halls of residence, parking, dining facilities, campus transportation and much more. Additionally, this unit supports many critical IT processes including the secure distribution of student photos for identification cards.
TMIndiana University Deploys AutoMate Software to Centralize and Facilitate IT Management Contact: Aaron Sudduth Title: IT Manager Company: Indiana University Background The Auxiliary IT Operation center at the Indiana University has a lot of responsibility on its plate. It is in charge of the majority of for-profit activities the university is engaged in, namely the halls of residence, parking, dining facilities, campus transportation and much more. Additionally, this unit supports many critical IT processes including the secure distribution of student photos for identification cards. Auxiliary IT is responsible for approximately 60 Windows servers, and roughly a thousand desktop machines. The servers host many databases, mainly Microsoft SQL Server but a handful of Oracle, that contain sensitive student and financial information. Two server administrators manage and maintain the servers, and roughly 15 other employees including DBA's, developers, and managers comprise the rest of the department. The Challenge Managing and supporting the wide range of users and constituencies requires continuous sharing of data, files, and information. In the past, if a database owner needed information from another database, he could simply write a script, batch file, or data transformation package to move or copy the information from one server to another. However, the ad-hoc data transfers were extremely problematic. For starters, this was a major security issue, as most of the data and files consisted of sensitive student and financial information. Managers and administrators worried that information could be misused, or worse, fall into the wrong hands. Moreover, when a system problem arose as a result of a data transfer, there was virtually no way for the server administrators to diagnose the cause and implement corrective action, because there was no audit trail or centralized oversight of the transfers. While the open policy for data access made it easy for database owners to share and access information, it was a management nightmare that clearly needed to be changed. Another issue Auxiliary IT had to confront was disaster recovery. The department had to develop a centralized and manageable process to ensure all the sensitive data was backed up on a regular basis. The Solution Aaron Sudduth, an IT Manager with Auxiliary IT, was tasked with developing solutions to these challenges and to improve the overall management and control of the information in the department's purview. Some of the most important changes Aaron made were procedural in nature, not sweeping software solutions. For example, database owners were no longer permitted to access data from other sources directly. Instead, they had to request that Aaron and his team coordinate and conduct the data transfers. However, this policy change resulted in a flood of data transfer requests to Aaron and his team. The only way they could accommodate these requests and provide users with the data they needed was to implement an automated solution. Fortunately, a colleague introduced Aaron to the power of AutoMate software, and Aaron soon realized that he could automate a range of critical processes with the tool. Aaron and his team quickly established a set of automation tasks that database owners could utilize to access data from other sources. With these tasks, Aaron accomplished several goals. First, he was able to implement processes that enhanced secure access to the sensitive data. Second, he provided users with a straightforward, easy process to access needed data. And third, he added a new level of transparency that enables his team to diagnose and rectify any problems that might arise. As Aaron says, "AutoMate is so flexible and powerful we keep finding more and more scenarios where AutoMate is the solution." Once Aaron solved the most pressing security, data access, and management issues, he turned his attention to other issues he knew AutoMate could help him solve. One of these was implementing procedures to enable recovery of data in the event of a disaster. Now, critical database logs are replicated and securely transferred to offsite servers every two hours for backup and disaster recovery. Aaron even has a task that notifies him and his staff in the event a backup transfer does not occur so they can diagnose and fix an issue before it becomes a real problem. Aaron also implemented a process that distribute... [download for more]
