# Fractional DBA Service: Remote DBA

Remote DBA is a "Fractional" DBA Service, a cost-effective solution for businesses that need database administration but do not require a full-time database administrator. This service provides access to a team of experienced database administrators on a part-time basis. Whether it's for routine maintenance, troubleshooting, or strategic advice, Remote DBA's Fractional DBA Service ensures that expert assistance is just a message away. This approach not only saves the expense of a full-time employee but also provides a higher level of service due to the collective knowledge and experience of the Remote DBA team.

{% hint style="warning" %}
Remote DBA  is an optional service that you can purchase. You can use this service regardless of the Tier (Foundation or Power) used to deploy DB services. For more information, please contact MariaDB support
{% endhint %}

Here is what you can expect from this “add-on” service.

### **Migration Methodology & Advice**

Expert advice available on migration methodology and procedures.

### **Query Optimization and Performance Tuning**

Remote DBAs offers tailored query analysis and professional tuning upon request. Our team provides expert assistance in implementing low-impact table alterations when necessary.

### **Quarterly Business Review**

With a Remote DBA subscription, your customer success manager can schedule quarterly business reviews with someone from the Remote DBA team to review items such as:

* Historical usage focusing on peak
* Future Growth/Capacity Planning
* Recovery Time (RTO)/Recovery Point (RPO) Objectives
* Escalation Points
* Business Continuity

### **Quarterly Security Audits**

Work with the Remote DBA team to ensure that your environment is safe and secure. This includes auditing of users and grants.

### **Proactive Monitoring and Incident Response**

Remote DBAs monitors instances for potential business impact events. Upon detection, events are internally flagged. We investigate and collaborate with your team as needed for swift resolution.

### **Extended Troubleshooting and Analysis**

Troubleshooting and analysis includes core dumps, system logs, and more.

With a Remote DBA Subscription, our database experts can assist with tasks such as analyzing core dumps, system logs and other similar technical issues that require expert database server knowledge.

### **Tailored Backup/Restore Strategies**

Partner with Remote DBAs to create tailored backup strategies to meet your organization's Recovery Time Objective (RTO) and Recovery Point Objective (RPO) goals.

### **Data Recovery Assistance and Validation**

Remote DBAs can assist in data recovery from backups or other sources, providing expertise for analysis. Additionally, as requested, Remote DBA can conduct annual Disaster Recovery exercises upon request to ensure preparedness. It's important to note that running a recovery to a secondary service may require additional compute resources.