MANAGED DATABASE SERVER

IBN's database experience is unparalleled. Our support executives are extensively trained to assist customers in managing and troubleshooting their database environment.

IBN offers a number of options from disk space on a shared database server to high-availability, clustering solutions.

• Database user account management
  IBN will manage all user accounts assigned to you. The IBN's support executives will manage addition, modification and removal of user accounts and associating profiles and/or storage parameters. To better manage the environment, IBN would create specialized roles/profiles. These are then assigned to the user accounts based on their requirements and contractual agreements. User defined roles and profiles can also be setup.



• Database objects creation
  IBN's support executives can manage creation of tables and indexes if you so choose. This activity is restricted to creating these objects based on existing storage conditions and profiles and does not include design modifications and/or modifications to the data structures. IBN's support executives can also manage the creation of objects like stored procedures, triggers, packages etc.

  IBN will not troubleshoot and/or make modifications to the logic of the code. IBN responsibility is strictly focused around the creation of the object in the database (running an object creation script etc) and not to the writing of the code/script for object creation.

• Database storage management
  It is imperative to manage the growth of the database objects. Poorly designed objects in the database can cause fragmentation and/or chaining in the database, which can adversely affect the performance of the system.



• Database patch management
  Database vendors occasionally release patches to fix specific bugs. These patches are installed and a patch log maintained by IBN.



• Database backup administration
  Database backup is setup to run on a schedule, usually daily. IBN will configure your database to be setup in such a schedule and configure all the required parameters for the backup software. Wherever necessary, the database is setup in the hot backup mode so as to reduce downtime of the instance.

  For Oracle databases, IBN can take the backups of the archive logs too, which are more like incremental backups, during the weekdays. This helps in any recovery efforts in the future and also reduces the risk of any data loss in case of a database crash. IBN will make all the necessary configurations and setups required for this option.

  For MS SQL Server databases, IBN can take the transaction log backups, which are more like incremental backups during the weekdays. IBN will make all the necessary configurations and setups required for this option. Transactional log backup can be used only if the database does not have bulk insert procedures or if the schema does not change

• Database Recovery/Restore from Backup/logs
  Hostcentric can recover your environment from the backup tapes as and when requested. Where possible, Hostcentric can recover your environment from the archive logs instead of the backup tapes as and when requested. This is ideal when you need to recover to a point in time and/or pressed for time to recover from tape.



• Database Refresh
  Very often, you may need to have a development database environment as a copy of the production site. The Hostcentric DBAs can do this for you as per your requirements.



• Database Design Assistance
  Hostcentric DBAs have a vast experience in database design concepts. You can tap into this experience for recommendations and assistance in your database design initiatives. Hostcentric 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.