Database Administration Services
InfoTelica’s dedicated database administrator team provides all DBA services (Oracle, PostgreSQL, MySQL, Microsoft SQL Server, vector databases, NoSQL databases, etc.) by assigning highly qualified DBA professionals. The primary objective of such a team is to provide our customers with high availability and agility in their business through InfoTelica’s reliable and proven expertise. To meet this objective, we form our dedicated DBA team from Oracle-certified, highly experienced, self-motivated team members.
- Database Health Check.
- Database Backup and Recovery.
- Database Performance Tuning.
- SQL Statement Tuning.
- Database Security Configuration.
- Database Setup and Upgrade.
- Database Capacity Planning and Sizing.
- Remote Database Support.
- Real Application Clusters (RAC).
- Data Guard and Standby Configuration and Management.
- Oracle Exadata and Oracle ODA Configuration and Management.
What we deliver
Database Health Check
InfoTelica’s well-known, Oracle-certified, experienced consultants diagnose existing database problems and bottlenecks with a proactive approach by monitoring the database. To monitor the database, we look at operating system configurations, database initialization parameters, database security settings and database performance metrics. After monitoring, we identify and solve problems before the database crashes, or give your database better performance in the light of monitoring results.
Database Backup and Recovery
By examining your existing database structure, we determine the most reliable and suitable backup and recovery strategy for your database system. Also, we can improve or determine your disaster recovery strategy.
Database Setup and Upgrade
According to customer needs, we carry out capacity planning, identify the Oracle installation packages, set database initialization parameters and tune performance.
Database Capacity Planning and Sizing
The scope is CPU, storage, file system, memory and network. We continuously review database growth and carry out annual capacity planning. We add extra database extents according to customer’s business needs.
Real Application Clusters (RAC)
To improve your database performance by using load balancing between nodes and to provide 24/7 availability for your business, we can determine the ideal RAC architecture and set it up for your database systems.
7x24 eyes on your databases
We set threshold values for the key performance metrics of your production databases. When a metric crosses its threshold, our own monitoring tool e-mails InfoTelica’s consultants, and we find and fix the bottleneck before your users feel it.
- Thresholds on every key metric. Query time, CPU, sessions, storage and more.
- Alerts that reach a person. Our consultants are notified the moment a limit is crossed.
- Fixed at the source. We tune the query, the index or the configuration, not just restart.
- Threshold reached: average query time above 250 ms
- E-mail sent to the InfoTelica DBA team
- Bottleneck found: full table scan on a reporting query
- Fix applied: query time back below the threshold
From a week to 1 hour 35 minutes
We read the execution plan, fix the query, the indexes and the statistics, and measure again. In one tuning project a one-week report now finishes in 1 hour 35 minutes, and an 8-second query in 3 seconds.
Performance Tuning
We set performance metrics for the customer’s production database and make the required improvements. There are two methods of performance management:
- Proactive Performance Management:Before performance problems appear, we find performance bottlenecks and tune the database system. To do this, we set threshold values for performance metrics and if the system reaches any of these threshold values, the system sends an email to InfoTelica’s Oracle consultant group using our own tool.
- Reactive Performance Management:After performance problems appear, we solve these problems.
Database Security Configuration
The primary aim of database security configuration is to allow only privileged users to access customer data. We also make necessary improvements to protect your database system from attackers. Database security is configured according to Oracle standards by
- Applying rules of secure remote access.
- Loading up-to-date security patches.
- Disabling unused services.
- Setting the required internal parameters.
- Enabling auditing.
- Auditing the SYS and SYSTEM users.
- Providing Oracle network security.
- Granting database object privileges to users.
- Creating database users and roles and granting related privileges.
All of these security measures are applied according to customer’s security policies and procedures.
Remote/Onsite Database Support
We know you have a business to run, and you want to have as few worries as possible and feel secure. That's why our customers choose us and stay with us for their Oracle database services. Via our remote Oracle DBA support we guarantee that you keep your systems running smoothly and you have the level of expertise you need to quickly resolve any database problem that may occur. Our cost-effective remote Oracle DBA services range from monthly database reviews to 24/7 support with guaranteed response times. Our focus is on using best practices and doing things right in order to avoid performance issues, data loss, or downtime and maintaining ongoing communication with you. We'll handle proactive maintenance, monitoring, and responding to your database system alerts so that you can focus on running your business. You can utilize our full Oracle remote DBA outsourcing services for all your mission-critical production database support to complement your in-house DBA resources or to provide DBA resources for companies without DBAs on staff. The solution we offer is cost-effective in these tough economic times because
- You will have a high level of availability and minimal downtime, even outside working hours.
- We will provide you with proven and reliable expertise so you will not need to train your staff on new technologies or retain specialised technical staff in-house.
Not sure where to start?
Tell us about your systems and goals. We will suggest the right mix of services and a first step.