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.
Restarting your droplet is a very simple process.
shutdown -h now
The simple answer is no, DigitalOcean does not require you to turn off your droplet to take a snapshot or backup.