Should I put my site on maintenance mode before using "drush sql-dump"?
According to Moshe's answer in advantages of drush bam vs. drush sql-dump / drush sql-connect, the answer is no.  drush sql-dump does the right thing and will result in a consistent backup.