[#204] Propagate onPause, onResume

* Use Activity life-cycle callbacks to handle DB resources