SQL Server support restored after an unexpected DBA departure

An unexpected departure left a critical skills gap

One of Europe’s leading specialist law firms unexpectedly lost its sole Database Administrator. With no handover available, the firm needed an experienced partner to take responsibility for its ongoing SQL Server support.

Pro DBA stepped in and began supporting the environment while building an understanding of the systems and processes left behind.

Undocumented SSIS packages were brought under control

The firm had several password-protected SQL Server Integration Services packages but did not have clear documentation explaining what each package did.

Pro DBA reviewed and fully documented the SSIS estate, then provided recommendations for improvements. This gave the internal team a clearer view of its data processes and the work required to maintain them.

Support was shaped around changing requirements

The ongoing service was tailored to the firm rather than forcing it into a fixed operating model. Non-standard project and development tasks can be handled on a time-and-materials basis or built into the support agreement.

Support hours can also be adjusted when the firm has cyclical periods of higher or lower demand.