The Databases Behind Your Apps, Backed Up, Patched and Watched
Accounting, CRM and line-of-business applications all sit on a database, and most come with scheduled jobs and data feeds that nobody looks at until a report comes out wrong. Ceifa supports those databases as part of your managed IT. We keep them backed up and patched, control who can get in, watch the jobs that move data between systems, and fix them when they fail.
What Database Support Covers
Your accounting, CRM or line-of-business application is only as dependable as the database behind it. These are the parts of that database we look after as part of managed IT.
Failed Jobs and Data Feeds, Fixed
Failed Jobs and Data Feeds, Fixed
Nightly imports, SQL Server Agent jobs and syncs between applications tend to fail quietly. We put alerts on the jobs that matter, so a failure becomes a ticket for us instead of a surprise in next week's report, and we fix the cause rather than rerunning the job and hoping.
Backups You Have Restored, Not Just Taken
Backups You Have Restored, Not Just Taken
A backup job that reports success is not the same as a database you can get back. We set backups to match how much data you can afford to lose, keep copies off the server, and test restores so recovery is a known process, not a guess.
Access Control and Least Privilege
Access Control and Least Privilege
Shared logins, old service accounts and staff with more rights than they need are common in databases nobody has reviewed. We tie access to named accounts, remove what is no longer needed, and close access when people leave, in line with the security baseline we apply to every client.
Patching and Routine Maintenance
Patching and Routine Maintenance
We keep SQL Server patched, watch disk space and growth, and run the integrity checks and index and statistics maintenance that keep a database healthy, scheduled so they do not slow your staff down during the working day.
Documentation and Small Changes
Documentation and Small Changes
We record which applications use which databases, what each scheduled job does, and where credentials are kept. Small changes, such as a new field in an export or a different schedule for a job, come through the helpdesk like any other request.
On Your Servers or in Azure, With Early Warnings
On Your Servers or in Azure, With Early Warnings
We support SQL Server on your own hardware and databases in Azure. When a version is nearing the end of Microsoft support, a job keeps failing, or an integration is too fragile to trust, we raise it early. Larger redesigns and new pipelines are delivered with Regroove, our sister consultancy.
Your Contact for This Service
Clod Feijao, Partner and Director of Client Success
Clod looks after client relationships at Ceifa, which includes the databases and data feeds behind your applications. He is accountable for making sure a failing job is fixed properly, that recurring problems are raised with you, and that your databases are covered by backups and reviews like everything else we manage.
He is not the one patching servers or writing queries. When a database or integration needs more than support, such as a redesign or a new pipeline, he scopes it with Regroove, our sister consultancy, and makes sure the result comes back under Ceifa support.
Read Clod's profileBringing a Database Under Management
Before we can support a database properly, we need to know what it is, what depends on it and what shape it is in. Every engagement starts the same way.
Find Every Database and Feed
We list the databases in your environment, the applications that use them, and the scheduled jobs and integrations that move data between them, including the ones nobody remembers setting up.
Health and Risk Check
We review version and support status, backup coverage, who has access, disk space, and which jobs are already failing or close to it.
Fix the Basics First
We put working backups in place, tighten permissions, and plan patching around your business hours, so the most serious risks are closed first.
Monitoring and Alerts
We set up alerts for failed jobs, failed backups and low disk space, so problems reach our helpdesk before they reach your staff.
Runbook and Documentation
We document what runs where, what depends on what, and how to restore each database, so recovery does not depend on one person's memory.
Ongoing Support and Review
From then on, failures and small changes go through the helpdesk, and we review database health with you in our regular reviews. Bigger changes are scoped with Regroove.
Common Questions
Could Your Database Be Restored Tomorrow?
Tell us which applications and databases your business depends on. We will show you how Ceifa would back them up, patch them, watch their jobs and data feeds, and support them as part of your managed IT.
Burnaby Head Office: 3999 Henning Dr #402, Burnaby, BC V5C 6P7 | Victoria Office: 300-848 Courtney Street, Victoria, BC V8W 1C4