If your Droplet has an extremely active database its worth exporting the data into a static file just before taking a snapshot, this way you guarantee your data is safely backed up and restorable without corruption.
The simple answer is no, DigitalOcean does not require you to turn off your droplet to take a snapshot or backup.