Database Administration

The ITAS Database Administration team provides database administration services to the Purdue University campus.

Platforms Supported 

Services Provided

  • Provisoning of databases
    • To request a new database please submit a Footprints ticket to tickets-itidba@purdue.edu.  You will receive a Database Request Form back as an attachment.  If you have any questions on filling out the form please use the ticket as the communications vehicle.
  • Backup and recovery services
  • Tuning and optimization
  • Management of database assets
  • Consultant services
  • Oracle Database Mitigation

Mailing Lists

Please subscribe to the appropriate mailing list to be kept up to date on issues affecting your ITAS-supported database.  These lists are used to notify you on downtime (both scheduled and unscheduled), patching, and upgrades.

Oracle database mailing list: HTTPS://lists.purdue.edu/mailman/listinfo/iti-oracle-contacts

MS SQL Server database mailing list: HTTPS://lists.purdue.edu/mailman/listinfo/iti-mssql-contacts

MySQL database mailing list: HTTPS://lists.purdue.edu/mailman/listinfo/admindb-mysql

Service Requests

  • Outage or Emergency service requests
  • If you realize a production database is experiencing an unscheduled outage   – or --
  • A change is required to prevent a production outage, both of the following steps should be performed:
    1. Submit a ticket via email detailing the problem (tickets-itidba@purdue.edu). Include in this ticket the following information:
      • RDBMS: Oracle/SQL Server/MySQL
      • Database name:
      • Server: [If known]
      • Environment: PROD
      • Urgency: High
      • Impact: Major/Minor
      • Backup required: Yes/No
      • Script: Included/Attached
      • Additional Information: [Refresh/update permissions/etc]
      • Note:  Your Footprints ticket should be used to provide the on-call DBA with detailed, technical information necessary to address the issue.  This information is not often available from the CSC representative.
    1. Call the Service Desk to report the outage and escalate the ticket request.  Inform the desk of your ticket number so the on-call DBA can be made aware of it. You will also contact the Service Desk to learn the status of the outage.  The on-call DBA will then be contacted by a representative to confirm awareness of the ticket and escalate it accordingly.

  • Standard service requests

  • To request standard support and maintenance activities (e.g. data migration, database object migration, development environment restoration, etc.) submit a Footprints ticket via email detailing the request to tickets-itidba@purdue.edu. Include in this ticket the following information:

  • RDBMS: Oracle/SQL Server/MySQL

  • Database name:

  • Server: [If known]

  • Environment: DEV/QA/PROD [If PROD – has been tested in DEV and/or QA?]

  • Urgency: High/Medium/Low

  • Impact: Major/Minor

  • Backup required: Yes/No

  • When to run: ASAP/Today/Before Next Workday/Scheduled time

  • Job name: [Used if running after hours or a specific time is requested.  Job will be updated with script and scheduled by DBA]

  • Script: Included/Attached

  • Additional Information: [Refresh/update permissions/etc]

 

If any of this information is not supplied it may delay the processing of your request.

 

Accessing Database Resources

To obtain direct access to an ITAS supported database system, the Database Access Request Form must be fully completed and signed by the Account Owner (person for whom access is to be created), System Owner (person authorizing system access), and Data Steward (person authorizing data access). If you are unsure who the data steward for your system data is, you can refer the list posted at: https://www.purdue.edu/securepurdue/data-handling/data-stewards.php.

You may request a Database Access Request form by submitting a Footprints ticket to tickets-itidba@purdue.edu with the Subject Line: <System Name> Access Request, where <System Name> is the name of the system to which the access is being requested. In the message body of the email indicate you are requesting the Database Access form.  The form will be sent back to you as an attachment.  The ticket will remain open until the access request has been fully processed.

NOTE: Partially completed or unsigned Access Request Forms will not be processed.

Please allow at least 3 business days for your request to be received and processed.