Get your database demands solved quickly and smoothly. It's Real!
Count on an experienced DBA team | 24×7 | We take care of your data so that you can take care of your business.
Do not hire a DBA! Hire an entire team of DBA’s!
Oracle | MySQL | SQL Server | DB2 | PostgreSQL | MariaDB | Amazon EC2 e RDS | Rackspace | Microsoft Azzure | Google Cloud | Cassandra | Hadoop | MongoDB | IaaS | PaaS
24-hour monitoring is done through our DOC (Database Operations Center) through RMM (Remote Monitoring and Management) tools. We use the main tools for database monitoring: Nagios, Zabbix, MONyog, in addition to our own DBSnoop tool. In this modality are monitored: service availability, stability, replication, disk, memory, processing, and a number of other metrics that indicate the health of the environment.
Typically, MSP (Managed Service Providers) companies monitor metrics related to the operation of a particular hardware and / or software. HTI Tecnologia decided to go beyond and define behavior metrics, such as: ingestion and manipulation of data, attempts to access protected objects and / or without permission for a given user. Viewing and changing sensitive data. We can also define usage metrics and data consumption, and, through algorithms, determine the expected behavior in the use and consumption of data. In this way, we can set thresholds to alert when something is out of acceptable.
Through the statistical information provided by active monitoring our team of Senior DBAs will act to prevent problems and mitigate failures before they occur. Acting in problem solving in a preventive and corrective way.
Composed of a series of activities and tools to control the changes related to the RDBMS, its accessories (plugins), and, above all, the embedded code in the RDBMS itself. Configuration management applies changes, updates, patches, and hot fixes to RDBMS components and all embedded code, controls, audits, and reports on its activities.
It broke? We Fix It! Problems, really, critics that unavailable an entire database environment is rare. However, when these events arise it is crucial to have the best team of Senior DBA’s to avoid losing valuable information, and to restore the environment in the shortest time possible. Our team is 24 hours a day, every day of the year, available for limit situations that require quick intervention and with great assertiveness.
Configuration settings of the RDBMS and Operating System according to the manufacturer and the demand required by the data consumption. Optimization of tables and indexes. Monitoring the degradation of indexes and their statistics. The constant monitoring of data growth and the way it is consumed is part of continuous performance improvement.
Control and management of users, roles, privileges, access and utilization / limitation of resources and consumption of database. Besides doing all the management of users (creation of users, passwords, permissions) this matter is also concerned with creating reports is metric as to what, when and how much is consumed.
Application of changes in metadata (tables, columns, indexes, constraints, procedures, functions, etc). Record changes, and, “rollback” when needed.
Validation of data modeling and support. Control over changes in metadata, thus avoiding service stops, and especially total and / or partial loss of information.
Design and Support of high availability platforms. Monitoring, operation and testing. Synchronous replication, asynchronous, active-passive cluster, active-active cluster.
Application of best practices in maintaining a disaster prevention and continuity plan. Backup & Restore Techniques. Monitoring and testing of backups. Keeping backups in a safe place.
Applications grow. The data too. With the growth of databases, and the consequent increase in consumption can bring slowness to applications and services, and even denial of service. Our team will be one step ahead of these demands, making capacity plans, anticipating the need to increase resources, before these are effectively needed.
EAR – Environmental Analysis Report: In the months of January (December, November, October), April (January, February, March), July (April, May, June), and October (July, August, September) a In this report we present information such as: disk / memory / cpu consumption, vegetative growth of data / indexes / logs, problems, failures, errors, availability, etc.
QAR – Query Analysis Report: Weekly report will be sent with the 10 most impacting queries with comments and suggestions so that the development area can act on the rewriting of the same.