ITS Database Administration Overview

Database administration is responsible for the creation and maintenance of Wesleyan's databases, ensuring reliable and efficient access to information across the university.

Wesleyan uses Oracle Enterprise v10.2 databases, running on both Linux Red Hat and Microsoft Windows. Wesleyan's suite of applications utilizing Oracle databases includes:

• PeopleSoft HRMS/CS 8.9,  people tools 8.20.07

• PeopleSoft Financials 9.0,  people tools 8.49.11

• Millennium 7.7.2

• Blackboard Learning Objects

• Blackboard Community Center

• Blackboard OneCard

• Lyris 9.3g

• Xythos content management system

• Autosys 4.5.1

• Home-grown financial data warehouse

• Various other in-house applications (i.e., Electronic Portfolio, Media images database)

• Approximately 15 production and 24 development/test instances are supported.

Additionally, there are five Microsoft SQL Server 2005 databases, used for a handful of applications (event management system, financial aid, OrgPlus).

Wesleyan uses Oracle's Internet Application Server (10.2gIAS), running on Linux Red Hat, for serving up database information on the web, allowing for both secured and unsecured access.

Databases and IAS servers are managed via Oracle's Enterprise Manager Grid Control.

Learn more about:

	Database Availability
	Database Security
	Database Backups
	Database Redundancy
	Database Administrators
	Database Administrator Duties
	Operations Page (restricted)

Resources:

	Oracle Corporation (PeopleSoft)
	Sage Software (Millennium Fundraising)
	International Oracle User's Group
	Ask Tom (Oracle resource)