A -    Re-indexing and other DB Maintenance tasks will have to reside within our Users SQL Administrator at their location.

More than likely our users will not be required to run a re-index on a nightly basis.   The Maintenance that is needed will depend on the number of fragmented tables (meaning records that have been deleted from the middle of the table) and or the tables that have Heavy Transactions.

The users might be able to run on-line re-indexes during business hours depending on the defragments that are found, and then schedule a full re-index once a week that would have to be preformed off line (no one in the system).   How often will be up to the SQL Administrator on location.   There are Statistic tools available within SQL that the Administrator could use to see which tables are in need of re-indexing and how often, etc. . .

There will also be options on what and how often the records are backed up.   The SQL Admin could create a nightly backup that would actually be a partial Backup that will only backup differentials (records that have changed since last backup), which would be much faster than the Full Backup.  And then once a week run a Full Backup.

Again there are many maintenance tools within the SQL that will be up to the SQL Administrator to implement as needed on location.