Application & Database

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 24×7 24×7 24×7
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