Description
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 or Windows Platform Hosting services.
Benefits
- Project agility and flexibility
- Significantly reduced cost and risk
- Fixed monthly rate for database management
- 24/7 Service Desk support
- CDT manages database installation, upgrades, migrations and patching
- Access to the Oracle Enterprise Manager for control and overview of the database state
Included
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 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:
Database Backup Schedule
| What | When |
|---|---|
| Full Backup | Weekly |
| Incremental backup | Daily |
| Archive log backup | Multiple times every day |
| Backup retention | 28 days |
Security
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 the 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.
Optional
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.
Roles & Responsibilities
General
| Role | CDT | Customer |
|---|---|---|
| Maintain logical and physical database design diagram(s) and provide to CDT upon request. | X | |
| Update of logical and physical database design diagram(s) as database environment(s) are completed and accepted. | X | |
| Understand product lifecycles. | X | |
| Collaborate with CDT on upgrades, testing, and verification of database technologies before the end-of-life support date. | X | |
| Determine and submit details of hardware capacity needs and Oracle database software version. | X | |
| Identify and lead the resolution of application related problems. | X | |
| Review and approve of submitted request prior to beginning work. | X | |
| Notify customer of any submittal flaws. | X | |
| Installation, upgrade, patching and standard configuration of the Oracle database product(s). | X | |
| Assist customers in specifying design requirements. | X | |
| Design, develop, test and deploy the Oracle database(s) and maintain interactions with application(s). | X | |
| Submit a complete Oracle service request. | X | |
| Identify and provide a list of database users who will be assigned DBA role and inform CDT Oracle database support of changes. | X |
Installation
| Roles | Customer | CDT |
|---|---|---|
| System-level administration. | X | |
| Assist Customers in restoring a database. | X | |
| Monitor table space usage and notify customer when additional storage is needed. | X | |
| Maintain database backups. | X | |
| Assist in resolution of database system problems. | X | |
| Create database DBA account(s) within Oracle instance. | X | |
| Assign permissions. | X | |
| Monitor and tune Oracle database. | X | |
| Review and recommend optional configurations that may better meet capacity and performance requirements. | ||
| Perform Oracle database migrations, upgrades and patches. | X | |
| Maintain non-client based Oracle database administration tools. | X | |
| Maintain Oracle database software and configurations. | X | |
| Resolve Oracle database problems. | X | |
| Contact CDT Oracle database support for Oracle database issues as needed. | X | |
| Define Oracle database availability requirements. | X | |
| Document database design and application architecture. | X | |
| Maintain Oracle database dictionaries. | X | |
| Respond to threshold limit notifications provided by CDT Oracle database support. | X | |
| Test new maintenance and software releases at user and application levels for compatibility and functionality to database. | X | |
| Submit a case/request to purchase Oracle database licenses and to renew maintenance. | X | |
| Create and maintain schema objects. | X | |
| Adhere to CDT Procedure 4000 – Software Version Support for application design, development, testing, migration, and maintenance activities.. | X | |
| Application design and maintenance adhering to supported Oracle software versions. | X |
Maintenance
| Role | CDT | Customer |
|---|---|---|
| Manage contract and licensing for Oracle database software. | X | |
| Serve as liaison between the customer and Oracle Corporation for technical database issues. | X | |
| Communicate database version end-of-support dates through Account Leads and Service Desk Bulletins. | X | |
| Formulate and implement database upgrade plans. | X | |
| Assist Customers with DBMS incident resolution subsequent to application configuration changes. | X | |
| Maintain application and database statistics. | X | |
| Maintain application development tools. | X | |
| Ongoing monitoring of database growth in relation to disk space. | X | |
| Monitor database use and promptly respond when action is needed. | X | |
| Assist in resolution of database system problems. | X | |
| Identify database application related problems or database problems . | X | |
| Data cleansing. | X | |
| Identify and report database problems to the CDT Service Desk. | X | |
| Database capacity planning and ongoing monitoring of database growth in relation to disk space. | X |
Administration
- Oracle database support outside of core support hours is available upon receipt of an approved CDT Case/Request. The Case/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.
Rates
The rate schedule represents standard CDT services. If a customer requires technology solutions that are not part of the standard, CDT will review the customer’s request and provide customized pricing as necessary.
| Service Description | Service Identifier | Product Name | Unit of Measurement | Rate | Service Code | Notes |
|---|---|---|---|---|---|---|
| CDT Processing Fee on Pass-through Products | Pass-through Fee | Dedicated Expenses | % of Direct Pass-Through Costs - Per Purchase Order | Pass-through + 2.79% CDT Processing Fee | D101 - Pass-Through | Plus the CDT Processing Fee of 2.79% |
| Tier 2 Database Support (Oracle) | Tier 2-Database Support | Database Support | Monthly/Per Instance | $1,570.00 | M622 | |
| Database Instance Installation Set-up Fee for Database Support - Tier 2 (Oracle, Informix*, Sybase*, and Cache*) | Tier 2-Database Support | Database Support | One-Time/Per Instance | $930.00 | M623 | *Software is in containment & unavailable for new systems, upgrades or migrations of existing systems. |
Subscriptions to this service are available.
Request Service
Cases/requests are revised at appropriate intervals providing for the expeditious and practical execution of the work performed.
| Service Request Name | Link |
|---|---|
| New Database or Database Environment Review the process to request service on 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 Case/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. | Enterprise Services Delivery |
| Change to Current Database or Decommission Complete the Case/Request with the required information. | Order a Change to a Current Database or a Decommission |
| Modification(s) to Existing System(s) Contact the CDT Service Desk. | Request Assistance |
| Report Technical Problems Contact the CDT Service Desk to report an Incident. | Open an Incident |
| Report Security Related Issues/Incidents Contact the CDT Service Desk and open an Incident. | Open an Incident |
| Temporary DBMS Administrator Privilege Request Submit a Information Security Exception Request. Follow the procedure outlined in the Security Exception Requests knowledge article. | Order an Information Security Exception Request |