Answer

The designer has no sisters, so he is not John.

And not Noah, because Noah is not the oldest and is married to John's sister.

So the designer is Alex.

Noah is younger than the programmer, so he's not a programmer, he's a manager.

And John is the programmer.