We've been doing this with Heroku anyway. Something about Heroku Postgres seemed a bit temperamental with our app (and was more expensive) so we've been using RDS in the same region without any complaints while enjoying Heroku for deployment.
No one on our team has DevOps or DBA experience -- we feel good about Heroku PG (even as inflated prices).