This is a major job and I would appreciate any advice

You need a hands-on kind of structural engineer person to see this disaster.
Ask to have recxommendations as to what part of the work you can do yourself
and what should be jobbed out because of special tools or equipment. Good
advice will always save you a bundle and is worth the price. HTH

Joe