Relational databases are the lifeblood of your business
÷ they can contain the critical customer information that supports
yours business ability to grow and build profitable business relationships.
Our Database Management Service is designed to allow you to take advantage
of the knowledge and experience of our consultants to maintain an optimal,
highly available database configuration.
While offering superior reliability, scalability, and performance the MACCIUS
Database Management Service is the best choice for hosting Sybase, Oracle,
OpenBase, Frontbase and MySQL applications. To optimize your database and
get the most benefit from the capabilities of your server, MACCIUS offers
database services that will analyze and tune your database and provide administrative
services so your database continues to run at peak efficiency.
Benefits
- Reduced risk with the use of highly skilled administration
and monitoring of database operations
- Hands-on mentoring and augmentation of your database
administration staff.
Supported Platforms
- Sybase
- Oracle
- OpenBase
- Frontbase
- MySQL
MACCIUS offers a number of options from disk space on a
shared database server to high-availability, clustering solutions.
| |
Vivaldi
|
Amadeus
|
Hagi |
| Database Monitoring |
|
|
|
| Monitoring Hours |
24x7 |
24x7
|
24x7 |
Connectivity
|
√ |
√ |
√ |
| Database Maintenance |
|
|
|
| Scheduled Backup Setup |
√ |
√ |
√ |
| Index Maintenance |
√ |
√ |
√ |
| Database Security & Permissions |
√ |
√ |
√ |
| Database Recovery/Restore from Backup |
√ |
√ |
√ |
| Database Implementation |
|
|
|
| Creating Tables, Indexes |
√ |
√ |
√ |
| Creating Stored Procedures, Triggers |
|
√ |
√ |
| Database Patching |
|
√ |
√ |
| Database Consistency Check |
|
√ |
√ |
| Database Tuning Recommendations |
|
√ |
√ |
| Database performance Recommendations |
|
√ |
√ |
| Database Design Assistance |
|
|
√ |
| Database Reresh |
|
|
√ |
| Database Support |
|
|
|
Monthly Technical Hours Available*
|
2 |
6 |
10 |
| Web Support/Email support |
√ |
√ |
√ |
Phone Support
|
|
√ |
√ |
| Conference Call |
|
|
√ |
*Hours cannot be carried over from one month to another
Database Monitoring
Monitoring hours
MACCIUS NOC monitors your environment round the clock for greater
uptime. All systems are monitored 24/7.
Connectivity
MACCIUS checks for the database connectivity of your environment.
If the ability to connect to the database fails, it sets of alerts to
the NOC for immediate remedial actions.
Database Maintenance
Scheduled Backup Setup
Database backup is setup to run on a schedule, usually daily. MACCIUS
will configure your database to be setup in such a schedule and configure
all the required parameters for the backup software.
Index Maintenance
For all types of databases, MACCIUS regularly conducts maintenance
on the indexes. This improves the performance of queries and keeps the
database in a healthy state.
Database Security and Permissions
MACCIUS helps you to setup users and their roles. It maintains the
administration users and controls their passwords. Security checks are
conducted to detect any holes in the system accessibility.
Database recovery/restore from backup
If a restore is requested, MACCIUS will conduct one using the database
backups from disk/tape. In the unforeseen event of a database crash,
a recovery will be done from the backup disk/tape as the case maybe.
Database Implementation
Creating tables, indexes
Creation of database objects is done by the MACCIUS DBAs once the
environment is in full production state. Data storage objects like tables
and indexes are created with optimal storage parameters and are maintained
by the DBAs.
Creating stored procedures, triggers
Data manipulation objects like procedures, functions and triggers
are also setup by the DBAs. This is done keeping the original design
and standards in mind.
Database patching
Database vendors occasionally release patches to fix specific bugs.
These patches are installed and a patch log maintained by MACCIUS.
Database tuning recommendations
MACCIUS regularly makes recommendations for improving the query
performance. Specific tuning recommendation like rewriting the queries
and tweaking system parameters are provided.
Database performance recommendations
Improving the overall performance of the database by coalescing
or de-fragmentation of database objects etc can be recommended by the
MACCIUS DBAs depending on your specific needs.
Database Design Assistance
MACCIUS DBAs have a vast experience in database design concepts.
You can tap into this experience for recommendations and assistance
in your database design initiatives. MACCIUS will assist you in your
design needs, but for an additional fee, can undertake to implement
the entire database design for you based on your needs and parameters.
Database Refresh
Very often, you may need to have a development database environment
as a copy of the production site. The MACCIUS DBAs can do for you as
per your requirements.
|
 |
Database Support
Monthly Technical Hours available
This is total number of technical hours available to you under the
different packages. These hours include all the activities listed above.
Web support/Email support
MACCIUS provides access to your support issues via its website.
Alternatively, you can also email your questions to support directly.
This service is provided at no additional charge in the selected packages.
Phone support
You can call in with your support issues on a toll-free line to
MACCIUS. This service is provided at no additional charge in the selected
packages.
Conference call
MACCIUS DBAs conduct a monthly conference calls to better address
your needs and issues. It also gives you an opportunity to bring up
any new initiatives or voice your concern on any issue pertaining to
the database environment. This service is provided at no additional
charge in the selected packages.
|
|
For more information about MACCIUS™ or any of our services, call us
toll-free at 888.622.2487 or email us at sales@maccius.com
|
