Small Business Data Backup

Hi, 

We are a medium business and we are looking to backup our data on cloud. I need help in understanding how these things are managed on a corporate level. 

Things that we want to achieve: 

1. Real time data backup on cloud. 

2. Facility to restore data if someone accidently deletes it. 

3. Admin should be able to restore the data if needed. 

4. If files are deleted in bulk then admin should be able to restrict it. Honestly, we don't want to give delete permission, users should be able to only create data.  Need case: In past one employees deleted all the CCTV data of last 3 months when he was fired along with important data of accounts department, we don't want such things to happen. Even if someone deletes any data from their pc, it should still stay in the cloud and they should be not able to empty the recycle bin and even if they do, then admin should be able to somehow restore the deleted cloud recycle bin data as well. 

5. Easily share data among other departments and external persons whenever needed. 

6. Users should be only able to append the file, not delete it. 

7. Whenever someone leaves the organization we should have a option to retain his data or either delete it as per our wish. 

Now, we enquired with google workspace and MS Small medium business One drive sales team. But there are some issues that they are not able to handle. 

Google: Files automatically get deleted after 30 days from trash. We want something in which file will stay in trash for 6 months. 

One Drive: They will not allow admin to access everyone's file.

We can connect in DM as well.