Logan,
Congrats on your new featherbaby :) He sounds lovely. So he's mostly yellow? That would make him either a pied or a lutino cockatiel. I love cockatiels. As long as they are hand fed or hand tame, they make great pets for kids. They rarely go through the "hormonal stage" that the conures and larger parots do. They are very charming and long living :) and they remain gentle.
I had a cockatiel, a rescue actually, named TuTu (I didn't name him :) ) but he fell victom to a terrible accident while I was asleep during the night before my high school graduation :(
I have also had dogs and cats with birds. Since I started getting the bigger birds ( I had a breeding pair of maroon belly conures, a cockatiel, and a goffins cockatoo) the dogs and cats realized that those birds were off limits.
They actually became AFRAID of them! Especially my cockatoo! Pica would walk on the floor looking for mischief, and if the dogs or cats were withing eyesight, she'd RUN over to them and start biting their tails playfully...then the dogs or cats would wag their tails in annoyance and it would make Pica want to nibble on that tail more and more until the cat or dog just couldn't take it anymore and got up and ran away :) Pica then promptly nipped at their ankles until they ran out of sight :)
My suggestion would be to use a water bottle and squirt the dogs and cats away from the cage, but you probablly already thought of that :)
I wish you all the best with Roger. I hope everything works out and the doggies and kitties learn that he's not a toy!
Happy birthday, Helen. Logan, you're a GREAT mom!