You asked

how do later biblical texts, particularly in the new testament, speak of god's presence in places like sheol?

Reading with you…