IT consulting Services for AIX, iSeries, Intel, VMware. ERP and ISV consulting and infrastructure services. Storage and Server consolidation and virtualization. 24/7 Phone and onsite OS Support services and Disaster Recovery solutions, planning and consultations.

Oracle Database System Service

Keeping your Oracle database systems highly available and well tuned takes knowledge, skill, and experience. We know that your environment is unique. And we know that it requires technical expertise as well as good communication to maintain optimal database performance. Therefore, RYJAC recommends the following services based on our clients goals and technical environment. 

 

Database Administration Services

With our offerings, we can configure a program that best suits your technical, business, and budgetary goals. We work as an extension of your team to set up and manage your Oracle databases to maintain reliability, scalability, and peak performance. You are assigned a primary and secondary RYJAC DBA. Either individual performs all work on your database.

Services

 

Assignment of primary and secondary Database Specialists

 

Initial setup

 

 

Introductions and contact information exchange

 

 

Set up infrastructure

 

 

Establish secure remote access to your servers

 

 

Install, configure, and customize monitoring tools

 

 

Review system, environment, databases, applications, and procedures

 

Monitoring

 

 

24x7x365 monitoring of [Client]’s databases, operational indicators, storage, and alert logs

 

 

Comprehensive monitoring and alert notification in areas such as:

 

 

-    Instance configuration parameters

-    Messages in the alert log

-    I/O and free space

-    Tablespace sizing and configuration

-    Redo log configuration

-    Rollback segment configuration and contention

-    Temporary tablespace configuration

-    User configuration

-    Session statistics

-    Wait events and locks

-    Latch statistics and contention

-    Shared pool statistics

-    SQL statement execution and performance

-    Object sizing and storage

-    Index definitions and usability

-    Database jobs

-    Customer-defined metrics and alerts

 

DBA Services (continued)

 

Monitoring (continued)

 

 

Alerts sent via email or pager to [client]’s staff

- Individuals set their own preferences for which alerts to notify by email, by pager, both, or neither

 

 

10+ powerful and easily customizable reports available round the clock

 

 

-          Alerts and events

-          Past alerts and events

-          Database growth

-          Tablespace size

-          High resource SQL

-          Instance activity

-    Performance summary

-    Performance ratios

-    Wait events

-    Redo log activity

-    Daily reviews

-    Monthly reviews

 

Customized Level of Coverage, Notification and Escalation

      Ö  Customized services proposed for [Client] are noted with a check mark

 

Ö

Notify client of events and recommended course of action

 

Ö

Daily database review and recommendations

 

 

Monthly database review, recommendations, and report

 

Ö

Full access to support team during normal business hours

 

 

24x7 pager support with guaranteed response time

 

Ö

Included database administration consulting hours per month to be used for proactive maintenance and any Oracle database related work needed by [Client]

 

Ö

Proactive maintenance for client pre-approved tasks

 

The following activities are a sampling of activities that can be performed as part of the included hours in your monthly plan. Activities that are requested above and beyond included hours will be billed on an hourly basis.

Services

 

Fault Management

 

 

Proactive maintenance to reduce risk of service disruption

 

 

Recommend solutions and changes to minimize impact of a failure

 

 

Post mortem analysis to avoid recurrence of a database or application failure

 

Backup and Recovery

 

 

Audit backup and recovery procedures

 

 

Test backup and recovery procedures

 

 

Recommend modifications to reduce risk of data loss

 

 

Recover database and data

 

Performance Management

 

 

Assist with application architecture and design

 

 

Review statistics regularly and at pre-defined intervals

 

 

Proactive tuning of application code, memory, I/O, and CPU usage

 

 

Maintain performance data archive for historical and planning analysis

 

 

Monitor and evaluate resource consumption

 

Configuration Management

 

 

Monitor database instances for configuration changes

 

 

Recommend changes for instance and session configurations

 

 

Recommend changes to maximize recoverability and manageability

 

 

Identify invalid objects, disabled constraints, disabled or invalid triggers, space and resource allocation constraints for user accounts

 

Services (continued)

 

User and Role Management

 

     Create and maintain user accounts and roles

 

     Audit database access and security

 

Capacity Planning

 

 

Resource requirement projections

 

 

Trend analysis

 

 

Data archiving and purging

 

Oracle Support

 

 

Opening TARs and following them through

 

 

Patch procurement and installation

 

 

Research using MetaLink

 

Consulting Services

We want you to think of RYJAC as your Oracle partner. From designing and building new database systems to seamlessly maintaining large production systems, we work alongside you to provide reliable, scalable, high-performing Oracle systems. Often times our clients ask about services and special projects that are not covered. Through our daily and monthly reviews, we will discuss our current approach and proactive ways to ensure that your system maintains its peak performance. You can select consulting services to be performed as part of its monthly service hours. Our experts make suggestions that include features from our Consulting Services as well as other services that may not necessarily be listed.

Consulting Services

Database Analysis and Design

 

User requirements

 

Database functionality

 

Logical and physical design

 

Data modeling

 

System architecture

 

Database architecture, design, and review

 

Schema changes and enhancements

Database Management

 

Capacity planning

 

Installations

 

Enhancements

 

Performance tuning

 

Troubleshooting

 

Upgrades

 

Migrations

 

Production support

 

Creation and support of development, test, QA, and production databases

Backup and Recovery

 

Strategies, planning, and implementation

 

Hot backup

 

DataGuard

 

Standby database

 

Multimaster replication

 

Distributed database architecture

 

Database recovery

 

Auditing and testing

 

Documentation

 

Consulting Services (continued)

Applications

 

Architecture and design

 

Code review

 

Work with developers to pinpoint problem queries

 

SQL optimization

Training

 

Coaching for junior DBAs

 

Knowledge transfer and procedure documentation

 

Seminars on client-requested topics

 

Mini-sessions on ad-hoc issues

Migrations, refreshes, and data archives

 

Database upgrades and migrations

 

Apply patches

 

Copy production databases to development and QA areas

 

Archive and purge data