Seriously, get a couple West Highland terriers. They were genetically engineered through selective breeding to solve this specific problem. (Jack Russells work too, but then you have a pair of Jack Russells—not a dog for everyone.)
There’s ample videos on YouTube if you need evidence. I’m pretty sure I also heard a segment on KCRW about how there’s a group of West Highland owners in NYC who have a ratting group. (They do this for the dog’s benefit because the dogs love ratting.)
I found this 2017 article: Meet the fearless dogs solving NYC's rat problem