Proactive Database Management

What does it mean when you don’t hear from your assigned DBAs?

At WellData we take great pride in our ability to offer proactive database management.

As part of the service that as a WellData client you receive, we anticipate problems, we think ahead and apply ‘fix-before-fail’ procedures to proactively test, monitor and reduce the risk of things going wrong to the very minimum.

And this may be why you don’t need to contact your WellData DBA every day.

But does this mean that there is no activity carried out on your databases?

No, in fact, quite the opposite.

By proactively monitoring and tuning we make your systems more robust and resistant to failure


We achieve this by implementing some key tasks:

Proactive health checks
Continuous operational improvements
Change requests for design and implementations
Backup monitoring
Capacity planning
Performance tuning, high availability testing, and disaster recover
Service pack, patching and hot fixing
Database refresh of development/test installations


Additionally, we install specialist monitoring tools to underpin the 24/7 management, with a warning system in place which ensures that, in the unlikely event of an incident, a DBA is allocated the task immediately.

However, at WellData we believe that this still isn’t enough.

We strive to offer the highest level of proactive service


And that’s why we also ensure that your assigned WellData DBAs regularly perform an additional series of tasks to help ensure that your database is at the highest standard…

Security Reviews

Regular user permission reviews should be part of a regular database health check, but in our experience, clients rarely actually carry this out. In fact, we have seen many instances where employees have left but still have user access and enabled accounts. Sometimes clients are scared of deleting the user, fearing the possible dependencies on that account, but they don’t realise the potential threat that leaving access to their mission critical databases to an ex-employee can mean to their business. That’s when we step in and help our clients review their security, disabling accounts when relevant.

Database Usage

Identifying databases that are no longer in use is harder than it sounds. It involves closely monitoring the databases, taking them offline, ensuring that this hasn’t caused any disruption and only when you are absolutely certain that nothing will break down, the database can be removed. The benefit? Left untouched, these databases would still require maintenance and back ups, using unnecessary system resources and capacity.

Job Clean-up

Similar to databases being left in service when they are no longer used, we often come across scheduled jobs that have been disabled or are no longer running. These should be deleted, and that’s why we work with our clients to ensure that the job is definitely not required and can be safely deleted.

So, when you receive updates on any of these tasks, you know that while these are not always routinely performed tasks, WellData carry them out as standard.


You can enjoy the peace of mind of knowing that your databases are proactively managed, with minimum disruption, and that’s why you don’t need to hear from your WellData DBAs all the time.

But that’s still not all. In fact, at our clients’ request, we can look at further tasks that have important positive effects on database management…

Restore Tests

These tests can be run in addition to the traditional database backups. While the backups allow you to recover the database if it becomes unavailable, at times it can be difficult to know where the backup file can be restored from, and to be sure that the backup file is useable. Obviously there are things like backup checksum and backup verification for SQL Server or RMAN validation for Oracle, that can give you a pretty good idea that your backup file is ok – but the real assurance only comes from actually running restore tests from the backups to make certain that, should the worst come to the worst, you will be able to effectively recover your data.
To run the restore tests you will need additional resources, like a server dedicated to backup tests, the end result is worth the investment.

Application-to-Database Mappings

When we take on a new client there is often little or no documentation on which applications use which databases and, particularly for larger businesses, this can cause severe delays in solving application issues. This lack of mapping makes it hard to track down the database that needs to be addressed if there is a problem with a particular application. Once again, we can step in and work on the application-to-database mapping for our clients.

Planning for Upgrades

Every database version will reach end-of-life at some point and that’s why it is important that for versions that are reaching end-of-life we begin upgrade plans, including tasks such as checking for breaking changes in newer editions, and begin working on fixes.

If you are considering a project or have an additional requirement that we can help with, please get in touch.


Get in touch

Here's what other people think

Google Rating
High standard, professional service. I've worked with Welldata for a number of years and always found their DBA's to be knowledgeable and proactive. Throw any question at them and it will be resolved, it gives real peace of mind knowing you have a partner you can rely on from emergencies to general questions. They also like a challenge and we do throw a few curved balls at more
Paul Miller
Paul Miller
12:34 27 Aug 21
The support I receive from Well Data is extremely responsive. Richard Parsons is my contact and keeps me informed daily on the health of our SQL Databases. Whenever I ask for assistance from Well Data it is quick and more
Kay Riley
Kay Riley
13:41 19 Aug 21
Really know their stuff and their response times are very good. They provide us with a vital service.
Andy Cole
Andy Cole
13:36 19 Aug 21
The guys at WellData really know their stuff. We wanted a quick route to doing something complex and they sorted it for us very quickly and to a high standard. Very professional, no ego, just excellent and to the point more
Steve Goacher
Steve Goacher
11:31 14 Nov 19
I have worked with the WellData team for many years now and they have always delivered.I would highly recommend them to any business looking for best-value outsourced Expert DBA’s.Being able to offer a rolling contract on the basis that if they don’t deliver you can leave shows their confidence and commitment.Their professionalism and knowledge is second to more
Petro Bartoszyk
Petro Bartoszyk
08:51 18 Oct 19
A very dedicated team of extremely professional and knowledgeable experts
Giulia Iannucci
Giulia Iannucci
14:08 16 Nov 18
We use Welldata for SQL support and are very happy with their service.
David Sadler
David Sadler
09:40 15 Nov 18
Really know their stuff and their response times are very good.
Andy Cole
Andy Cole
11:45 06 Nov 18
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our more
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work more
John Lynes
John Lynes
14:00 04 Oct 17
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17