My chances of getting into a RN program

Bay area? Slim to non honestly. Its SUPER competitive. Congrats on getting a job at that hospital though! :)

You should retake your sciences and work really hard to pull that A and then apply for lottery based nursing programs with waitlist near you, or any other program such as LPN, ADN, or BSN that you believe you may have a shot at.

I know. Bay Area is super competitive. It's in sane how impacted the program is.

I think DeAnza and Evergreen both have lottery based entry systems for at least some of their seats. Not a guarantee, but I'd look into them.

In SoCal, repeating one of the 4 sciences more than once would automatically disqualify you from most RN programs. I'm not sure what programs would accept you when you have to repeat Anatomy for a 3rd time. I'm almost certain that you will need to go out of state.

Like others said, retakes are not favored. To have a slightest shot at getting accepted into nursing school, try to look into ASN programs, too.

I'm looking out of state since its very impacted here in the bay area to increase my chances of getting into a program. Lets say I score really good on the hesi a2 exam, would my chances go up?

I think it depends on the school whether or not a good grade on the entrance exam will help you out. I would recommend hunting around for a school that takes the highest grade. I am in SoCal and the school I currently attend accepts the highest grade, but only the first TEAS score for their program applicants. While pricey, a private institution may also be another option. There are scholarships and loans (yes, the dreaded loans) out there to help fund your education. Once you graduate and land a nursing job, I think with the amount made loans can be repaid quickly especially if you are able to stay with your parents or friends for free or at a low rent amount.

If your grades are not quite enough to get you into a BSN program (not sure if you want a BSN or ADN), but an ADN/ASN program may also be an option if you are unable to go the private school route. I know some schools offer extra points for people who already have other medical experience like EMT, paramedics, or LVNs.

Like other said, retake the classes that you need to. You're going to have to do some digging around, but you may be able to find a program. Every school is different.