In my question, I have i.i.d random variables $X_1,...,X_n$ $\sim \text{Bern}(p)$ (Bernoulli distribution with parameter $p$). Denote $S_n = \sum_{i=1}^{n} X_i$. Does $\mathbb{P}(S_n/n>p+a)$ decrease when $n$ increases, where $a$ is a fixed positive value?
Update: or when $n$ is big enough?
No, it does not decrease, but oscillates. Here is a graph of the probability in question for $p=1/2, a=1/10$, for $n=1$ up to $n=100$. A rigorous proof can be achieved by analysing the probability in question, given by
$$P\{\frac{S_n}{n}>p+a\}=\sum_{k>n(p+a)}{n\choose k}p^k(1-p)^{n-k}$$ which follows from the fact that $S_n/n$ takes the value $k/n$ with probability ${n\choose k}p^k(1-p)^{n-k}$.