Firstly, change the "add column" part to just "add".
Secondly, this kind of process will definitely take exclusive locks on the table which will block other processes.
I suggest that you run this process during a very quiet time or during a downtime period.
Regards