You will get a fully automated system to ensure the integrity of your SQL Server backups

Douglas C.
Douglas C.
4.9

Let a pro handle the details

Buy Database Optimization & Design services from Douglas, priced and ready to go.

You will get a fully automated system to ensure the integrity of your SQL Server backups

Douglas C.
Douglas C.
4.9

Let a pro handle the details

Buy Database Optimization & Design services from Douglas, priced and ready to go.

Project details

You will get a fully automated system that backs up your SQL Server databases (if not already working) and then does a daily restore and integrity check to ensure that the backup files are good and your database does not have any corruption. It will email you in case of any issues so that you can take another backup or contact your database support team. This system will provide confidence that your backups will be restorable when you need them.
Database Type
MS SQL
What's included
Service Tiers Starter
$1,000
Standard
$2,500
Advanced
$4,000
Delivery Time 14 days 21 days 30 days
Number of Revisions
222
Number of Tables Added
222
Schema Diagram
-
-
-
Permissions Setup
-
-
-
Import/Export Data
-
-
-
Admin Panel Setup
-
-
-

Frequently asked questions

4.9
17 reviews
94% Complete
6% Complete
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
Rating breakdown
Availability
4.9
Deadlines
4.9
Skills
4.9
Quality
4.9
Cooperation
4.9
Communication
4.9

SK

Safa K.
4.85
Mar 31, 2023
Senior Database Administrator Doug worked part-time and was mostly on call for us. He provided his availability schedule at the start and every time we needed him, he immediately responded, was online and able to address issues. In addition to being on call, he upgraded the SQL server on our lower environment successfully. I'd certainly hire Doug for future DBA type of roles. Thank you, Doug!

JG

Jillian G.
5.00
Oct 7, 2022
Database Administration - Provide workaround to long query times great freelancer, already have other contracts open. definitely recommend!

HT

Henderson T.
5.00
Aug 25, 2022
SQL Consulting/Training-Initial Setup Doug was very helpful, effective, and professional. Highly recommeded.

KS

Keith S.
5.00
Sep 16, 2021
Excel/SQL Cube performance issues Douglas provided expert help working on our SQL server issues, and provided excellent advice and options on how to resolve problems and improve performance. He does an excellent job communicating and working within the time frame and budget. We will continue to work with Douglas for our Database work in the future!

RA

Richard A.
5.00
Dec 17, 2020
Additional Changes to MorawareAndSlabsmith Software Doug is great to work. He is an excellent communicator and his work is very timely. And his skills are top notch!
Douglas C.

About Douglas

Douglas C.
SQL Server Administrator and Developer
4.9  (17 reviews)
Winston-Salem, United States - 7:24 am local time
I have been using SQL Server for seven years in a production environment, and I have taken on the DBA role for my workplace, since I have discovered a passion for SQL Server. I have been working with Azure SQL DB since early 2018. I have developed systems for IT to auto-restore and verify the integrity of backup files, I created a centralized system for tracking job history, and I have experience configuring and using CMS to run queries or change configurations on multiple servers simultaneously. I have written a lot of application code, stored procedures, functions, and triggers, as well as designing and creating database schema and structures. My favorite task is optimizing queries and indexes to make them faster and more efficient.

I was lucky enough to attend a week-long training by Itzik Ben-Gan, as well as having taken many trainings from Brent Ozar. I always try to find the most efficient T-SQL solution for my queries and create solutions that I know will last.

During that time, I have also worked as a software developer in the Inductive Automation Ignition environment. I have worked with PLCs, transaction groups, database design, user requirements, Jython scripting, screen design, and process automation. I have developed several systems based on user requirements, from the ground up in Ignition.

I would love to help you overcome the obstacles currently in front of you!

Steps for completing your project

After purchasing the project, send requirements so Douglas can start the project.

Delivery time starts when Douglas receives requirements from you.

Douglas works on your project following the steps below.

Revisions may occur after the delivery date.

Confirm backup jobs

If you are not already using Ola Hallengren's backup scripts (or similar), I will set them up for you so that you have a backup system. I need your backup files to be in a predictable file structure in order to restore them with my automated system.

Customize automated restore

I will take my automated restore system and customize it to work with your environment, ensuring that all desired databases will be restored daily.

Review the work, release payment, and leave feedback to Douglas.