|
|
Database Services
Being proactive and keeping Database Systems running smoothly, takes the right combination of skills, experience, and tools. Our focus is on using internationally accepted best practices and in order to avoid performance issues, data loss, or downtime - doing things right the first time! In addition to setting up proper systems and ensuring the level of availability required along with a tested backup and recovery plan, we consider it is critical to monitor a variety of metrics to ensure that the database continues operating smoothly.
Our expertise helps in proactively assessing database systems and making suitable adjustments to avoid crises. If a critical problem does arise, we recognize it within minutes and immediately provide corrective measures to resolve them instantly.
Our core Database offerings include:
> Architecture & Design
> Administration
> Porting and Migration
> Performance Tuning and Optimization |
> Patch Application
> Cloning
> Upgradtion
> Audit & Security |
|
|
| |
| Key Features of our offerings: |
| |
| |
- Comprehensive Service Level Agreement
- Installation and periodic upgrades of the Database Software
- Initial database system configuration
- Storage Architecture and Design for the Database.
- Performance statistics collection mechanisms and quarterly database growth summaries
- Periodic monitoring of database
- Periodic performance analysis & tuning
- 24/7 Database support
- Back-up and recovery standardization
- High Availability Design and Installation as well as Configuration, using Clustering, Replication etc.
|
 |
 |
| Basic |
Standard |
Advanced |
• Installation and Configuration of Database software.
• Database Creation sizing and configuration
requirements.
• Managing Users addition and permissions.
• Monitoring Database Availability.
• Patch tracking Installation- upgrades and patches
• Daily/Weekly/Monthly database reports. |
Many powerful and easily customizable reports are available. These reports provide current and historical information in areas such as :
• Alerts and Events
• Database Growth
• Table space Size and Distribution
• High Resource SQL
• Instance Activity
• Performance Ratios
• Wait Events
• Log Activity |
The features of our offering can be customized to suit individual needs. We offer the following and more:
• A dedicated primary and secondary DBA assigned
to work with the client on an ongoing basis
• Daily check-in by an experienced DBA
• Comprehensive monthly reviews and reports
• 24/7 availability with guaranteed response time
• Proactive database maintenance with constant
database monitoring and alert notification
• Customized services for special projects
• Backup and overflow support for DBA team |
Porting Services
We offer porting services from one database to another. We offer the following and more:
Oracle - MySQL
> Conversion of data between Oracle and MySQL (MyISAM/InnoDB/NDB)
> Conversion between MySQl Routines and PL/SQL
Our experience includes the following areas:
|
Oracle
• Oracle 8i/9i/10g on Linux/Unix/Windows
• Oracle 9i/10g Real Application Cluster
• Oracle Data Guard, RMAN
• Oracle Applications 11i
MySQL
• MySQL 4/5 on Linux/Unix/Windows
• MySQL Cluster/NDB, Replication, Partitioning
|
DB2
• DB2 V8/9 on Linux/Unix/Windows/AS400
• DB2 HADR, HACMP, Partitioning
SQL Server
• SQL Server 2000/2005 |
|
|
|
