Mine does but it won't override silent mode. So I just need to make sure I am not silent before going to sleep. But getting this to work to that extent wasn't trivial and require a phone call. An app from a different device profile can't pierce it.

Also "thankfully" our on call system (Pagerduty) can be configured to call you if you don't answer the notification quickly enough