Skip to content

Fractional DBA Service - SkyDBA

SkyDBA 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, SkyDBA'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 SkyDBA team.

Note

SkyDBA 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 SkySQL support

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

SkyDBAs 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 SkyDBA subscription, your customer success manager can schedule quarterly business reviews with someone from the SkyDBA 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 SkyDBA team to ensure that your environment is safe and secure. This includes auditing of users and grants.

Proactive Monitoring and Incident Response

SkyDBAs 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/Analysis (Core Dumps, system logs, etc.)

With a SkyDBA 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 SkyDBAs 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

SkyDBAs can assist in data recovery from backups or other sources, providing expertise for analysis. Additionally, as requested, SkyDBA 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.