The Data Services team is comprised of Database Administration, Data Warehousing, Business Intelligence, and Middle Tier Management.
Database administration services include providing support to various business units using database operations. Supported database operations are Oracle and SQL Server. The administrators, specializing in these fields, use distinct computer programming languages to perform a variety of tasks including defining, installing and configuring the databases, problem analysis, transforming data between databases, automating processes, software upgrades, and backup and recovery.
Data Warehousing provides the extraction, storage and deployment of data for the purposes of reporting, analytics, and sharing across the enterprise. The transactional data is extracted from operational database systems and stored within a central enterprise master repository. Relevant subsets of this data are then further extracted and transformed into data marts, which are accessible by business users and optimized for reporting, analytics, or sharing data across the enterprise.
Technology Management's Business Intelligence (BI) Services provide support for technologies used to transform large quantities of data into information and actionable support for decision makers. Current technologies being supported are Microsoft SQL Server Reporting Services and Tableau. Microsoft SQL Server Reporting Services includes configuring, managing, maintaining and supporting the enterprise development, test and production Reporting Services server environments and managing upgrades. Tableau includes professional desktop, reader and Server web access.
Technology Management's Middle Tier services include the design, installation, configuration and monitoring of application and web servers used to control business logic and presentation to the user. This layer is between the user’s computer and the database server. It is typically a mixture of technologies which include web and application servers, as well as, computer languages used to manage the business logic of applications. Some of the applications using this technology, and supported by these services, are Weblogic, Tuxedo Server and Microsoft Biztalk; as well as, Banner Advantage and Emerald.