What should a person who was favored from Allah with a newborn, but couldn`t afford an Aqeeqah, do?
Aqeeqah (the sheep slaughtered on the seventh day from the child`s birth) is a desirable Sunnah for the financially able since Allah, The Exalted, charges not a soul beyond its capacity. Therefore, if the father couldn`t afford the Aqeeqah before the end of his wife`s confinement, then it isn`t due on him, and if he was able to afford it later on, then it is permissible, but if he didn`t until the child reached puberty, the latter can offer the Aqeeqah himself.
Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?
If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].
Is permissible to buy/sell with non-Muslim?
Yes buying/selling for a Muslim with non-Muslim is permissible as regards what is lawful.
I am an employee at Social Security, and I have heard that working with them is forbidden (haram) because they impose an interest rate of 2% on companies and individuals who are late in making payments. Is my job with them haram or questionable?
Please clarify the type of work. If it does not involve the usury (Riba) mentioned, we hope that there is no issue with it, as most of their funds are acquired in a lawful (Complies with the teachings of Sharia) manner. And Allah, The Almighty, Knows Best.