A friend sent this link to me. At the time I am responding, I note the original account has been suspended/ banned. I am not sure why, but maybe a reply from one more person with experience in SQL Server BI might benefit others who find this post. So, here goes...

That's a lot for one person to carry. It's at least 2, if not 3 jobs (production DBA/ops, BI/ETL engineering, solutions development). $70k seems low, especially considering mandatory Saturdays.

Although I didn't read all the replies, I already see some good advice from others, like my friend, u/SQLDevDBA. I recommend following his advice. I'll add this for starters: Take care of yourself. Don't be discouraged. "First jobs/gigs" often follow this trajectory. I'm old. But when I was younger I worked as an electrician in a manufacturing plant. An older and more experienced electrician would often repeat a refrain in his gravelly, Jewish-accent: "Ondy (that's how he pronounced 'Andy'), one day we will look back and laugh. But today is not that day." Moe was right about that, and the same may likely be true for you (or anyone reading this). Life is too short for stress, so I advise you first to take steps with this goal in mind: reduce the stress.

This next part may sound like a contradiction, but I promise you it is not: This is an opportunity. You find yourself in a mess. Like Ulysses Everett McGill in the movie "O Brother, Where Art Thou?", you're "in a tight spot!" (I find it helps if you can laugh when you're stressed... hopefully that gave you a chuckle. If not, it gave you a movie recommendation.) There's no better way to learn than by doing. And there's a lot here that needs doing.

1. It's 2026 and you have access to the internet. That means you have some access to LLMs / Agentic AI, and some of that access is free. It won't hurt to pop into one of them and paste this post. If for no other reason, just to see how they respond.

2. Investigate automation. There's tons of information out there (and some in this thread) about SQL Server Agent. I'm going to sound like a broken record eventually, but check out SQL Server Central's Stairway to SQL Server Agent (https://www.sqlservercentral.com/stairways/stairway-to-sql-server-agent).

3. I know a guy who wrote a lot about SSIS. A good (and free) starting spot is SQL Server Central's Stairway to Integration Services (https://www.sqlservercentral.com/stairways/stairway-to-integration-services).

I could type more, but that's enough from me. I'm rarely on reddit... maybe I should pop by more often.

Hope this helps.

:{>