It just looks like a consulting gig with the potential offer of a job afterwards. If the rates are good and the offer is decently compensated, it's probably a fine way to recruit for what looks to be a highly specialised position.

Probably not going to get that many low-level postgres specialists with deep experience walking through the door. If the consultant feels good about the project then they've got the chance to stick around in the long term.