Platform Hosting - Database - Oracle

 

The California Department of Technology (CDT) provides services on a number of database management system (DBMS) technologies for various hardware and operating system platforms. CDT offers Oracle on leased equipment within the CDT Tier III data center.

Oracle is available as an add-on component to Customers that subscribe to the AIX, Linux, Solaris or Windows Platform Hosting services. 

Benefits

  • Project agility and flexibility
  • Significantly reduced cost and risk
  • Fixed monthly rate for database management

 

  • CDT manages database installation, upgrades, migrations and patching
  • Access to the Oracle Enterprise Manager for control and overview of the database state
  • 24/7 Service Desk support

The following are included in the Oracle service:

  • Support of Oracle database versions in accordance with the CDT Software Version Support Policy
  • Hosting on the Solaris, AIX, Linux, z Systems, and Windows platforms
  • Management of the Oracle software licensing
  • Oracle database installation, patching, maintenance and 24/7 on-call technical support 
  • Liaison service between the Customer and vendor for technical system-level DBMS issues
  • Database backups on the following schedule:
WHAT WHEN
Full Backup Weekly
Transaction Log Backup Daily
Backup Retention 28 days

 

Oracle Database offers a wide range of features to help customers meet specific requirements in the areas of performance and scalability, high availability, security and compliance, data warehousing and big data, and manageability.

CDT assists Customers in formulating database designs that meet their business requirements. Customers should contact their Account Lead to engage architectural/engineering and design consulting services. Additional charges may be incurred.

General

RoleResponsibility
Maintain logical and physical database design diagram(s) and provide to CDT upon requestCustomer
Update of logical and physical database design diagram(s) as database environment(s) are completed and acceptedCustomer
Understand product lifecyclesCustomer
Collaborate with CDT on upgrades, testing, and verification of database technologies before the end-of-life support dateCustomer
Determine and submit details of hardware capacity needs and Oracle database software versionCustomer
Identify and lead the resolution of application related problemsCustomer
Review and approve of submitted request prior to beginning workCDT
Notify customer of any submittal flawsCDT
Installation, upgrade, patching and standard configuration of the Oracle database product(s)CDT
Assist Customers in specifying design requirements in accordance with information provided in the Oracle Database SubmittalCDT
Design, develop, test and deploy the Oracle database(s) and maintain interactions with application(s)Customer
Submit a complete Oracle Database SubmittalCustomer
Identify and provide list of database users who will be assigned DBA role and inform CDT Oracle Database Support of changesCustomer

Installation

RolesResponsibilities
System-level administrationCDT
Assist Customers in restoring a database in accordance with the Oracle Database Submittal CDT
Monitor table space usage and notify customer when additional storage is neededCDT
Maintain database backupsCDT
Assist in resolution of database system problemsCDT
Create database DBA account(s) within Oracle instanceCDT
Assign permissions in accordance with Oracle Database Submittal CDT
Monitor and tune Oracle databaseCDT
Review and recommend optional configurations that may better meet capacity and performance requirements in accordance with the Oracle Database Submittal
Perform Oracle database migrations, upgrades and patchesCDT
Maintain non-client based Oracle database administration toolsCDT
Maintain Oracle database software and configurationsCDT
Resolve Oracle database problemsCDT
Contact CDT Oracle Database Support for Oracle database issues as neededCDT
Define Oracle database availability requirementsCustomer
Document database design and application architectureCustomer
Maintain Oracle database dictionariesCustomer
Respond to threshold limit notifications provided by CDT Oracle Database SupportCustomer
Test new maintenance and software releases at user and application levels for compatibility and functionality to databaseCustomer
Submit Service Request to purchase Oracle database licenses and to renew maintenanceCustomer
Create and maintain schema objectsCustomer
Adhere to CDT Procedure 4000 – Software Version Support for application design, development, testing, migration and maintenance activitiesCustomer
Application design and maintenance adhering to supported Oracle software versionsCustomer

Maintenance

RoleResponsibility
Manage contract and licensing for Oracle database softwareCDT
Serve as liaison between the customer and Oracle Corporation for technical database issuesCDT
Communicate database version end-of-support dates through Account Leads and Service Desk BulletinsCDT
Formulate and implement database upgrade plansCDT
Assist Customers with DBMS incident resolution subsequent to application configuration changesCDT
Maintain application and database statisticsCustomer
Maintain application development toolsCustomer
Ongoing monitoring of database growth in relation to disk spaceCustomer
Monitor database use and promptly respond when action is neededCustomer
Assist in resolution of database system problemsCustomer
Identify database application related problems or database problems Customer
Data cleansingCustomer
Identify and report database problems to the CDT Service DeskCustomer
Database capacity planing and ongoing monitoring of database growth in relation to disk spaceCustomer

Oracle DBMS administration authority is restricted to CDT designated personnel.

Occasions arise when, during construction, customers may be granted temporary DBMS administration rights to their leased installations of Oracle database. This access is limited to a maximum of four (4) calendar weeks from the time access is provided and will be revoked thereafter. If a customer requires temporary DBMS administration rights, the customer must complete an Information Security Exception Request and adhere to CDT Standard 3132 – Midrange Database Security.

Follow the procedure outlined in Procedure 3502 – Information Security Exception Request.

  • Oracle database support outside of core support hours is available upon receipt of an approved CDT Service Request. The request must be received a minimum of 10 days prior to the start of requested support.
  • Oracle change requests follow the established CDT Change Management process. Oracle maintenance activities utilize the platform maintenance schedules; however, emergency changes may be scheduled. Changes require 2-week prior notification. Shorter periods may not always be accommodated. Security-related changes adhere to the Midrange Database Server Security Standard, which can be obtained upon request through your Account Lead.
  • Configuration changes made outside the scope of the service request which requires intervention, correction, or troubleshooting by CDT staff may incur additional charges.
Service CodeService DescriptionUnit of MeasurementRateNotes
D101-PassCDT Processing Fee on Pass-through Products% of Direct Pass-Through Costs - Per Purchase Order Pass-through + 2.81% CDT Processing Fee
M622Tier 2 Database Support (Oracle)Instance/Month$1,170.00
M623Database Instance Installation Set-up Fee for Database Support - Tier 2 (Oracle, Informix*, Sybase*, and Cache*)One-Time/Instance$690.00*Software is in containment & unavailable for new systems, upgrades or migrations of existing systems.

Subscriptions to this service are available. Rates may also be referenced in the CDT Rate Schedule.

To submit a service request for a new database or database environment, please go to the Enterprise Services Delivery page.

A completed Oracle Database Submittal is required prior to the start of work. To aid in the preparation of providing this technology, a CDT Service Request form needs to be submitted and contain all pertinent information about the database build including local and physical database design diagrams.

Customers are encouraged to update the logical and physical database design diagram(s) as the database environment(s) are completed and accepted.

Service Requests are revised at appropriate intervals providing for expeditious and practical execution of the work performed.

Use the following method for work requests:

Item Request Method
To request a change to a current database or decommission, please submit a service request. Request a Change to a Current Database or a Decommission Now
Modifications to Existing Systems CDT Service Desk
Technical Problems CDT Service Desk for an Incident
Security Related Issues/Incidents CDT Service Desk
Temporary DBMS Administrator Privilege Request Information Security Exception Request. Follow the procedure outlined in CDT Standard 3132 – Midrange Database Server Security Standard and Procedure 3502 – Information Security Exception Request