Here are 3 variations in tense. All of these are fine.
1. Is there any sign showing that he is here? (Is there evidence that he is here now?)
2. Is there any sign showing that he was here? (Is there evidence that he was here in the past? You can add a time reference - e.g. yesterday, last week, etc.) 3. Is there any sign showing that he has been here? (