RYJAC Computer Solutions
We deliver solutions
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 ofprimary and secondary Database Specialists | |||
| Initial setup | |||
|
|||
| Monitoring | |||
|
24×7x365 monitoring of [Client]’s databases, operational indicators, storage, and alert logs Comprehensive monitoring and alert notification in areas such as: |
|||
|
|||
| 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 |
|||
|
|||
| Customized Level of Coverage, Notification and Escalation | |||
|
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 24×7 pager support with guaranteed response time Included database administration consulting hours per month to be used for proactive maintenanceand 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 |
|||
© RYJAC Computer Solutions