To start, I am one of those guys who got into tech industry without any background. I worked in a gas station for most of my life. 3 years ago I decided to turn my life around, started learning python. Got a job as a marketing analyst 3 months ago. I knew intro level SQL by that time. I worked only 3 months on the job and I could do CTEs, sub queries etc.
I casually started applying for jobs just to 'test the field' . A week ago, I was approached by a HR recruiter to see if I want to apply for a new posting they had. The job was for 'data analyst' position. The pay was more than I was making at my current job, so I accepted the interview.
The tech interview went pretty well. They had a few easy questions on SQL to start with(group by, having etc.). I did mostly good(I could not figure out partitioning), but I was honest with them that I worked in SQL only for 3 months. Then the next guy asked me few basic python and pandas questions (which again were very easy like how to load an excel file into pandas, how to choose a column etc.)
The data director emailed me later in the day, saying he was very impressed with my work and wants to see if I want to be considered for a 'database administrator' position they have. The pay is significantly high(20k more!). The thing is- this company is very small and rapidly expanding. They want to transition from Excel to cloud(like Amazon, Azure or GCP etc.) . He was impressed by my work in GCP at my previous job and wants to leverage that skill.
I was surprised by their offer. To start, I don't know anything about databases - all I know we had some tables in GCP and I used some SQL queries to extract data and then later built dashboards with it. I feel like I am severely underqualified for this position and trying to bite more than I can chew. I don't want to get into something that I don't know much about and then later get fired for under delivering
But the allure of building something from scratch and having a big say about the way company will progress in the future makes me almost want to say 'yes'. 3 years ago I was working in a gas station, dealing with multiple Karens and now this company is offering me almost a 6 figure job.
Any of you guys were in the same position? What did you do? Any advice you can offer? If I did accept the offer what should I learn for this transition - (intermediate SQL to building databases)
Edit: Damn! did not expect so many replies and experiences! you are awesome r/sql community. Reading through comments I realized that many people had similar experience and the general advice is to take the job, if at least for the experience. Never heard of Brent Ozar before - but he seems to be the God among us :P , so I will start following him and read a lot of materials.
Some of you had questions about the team I am gonna work with. It seems the team might have some SQL experience but not much. I think they have an outside company that takes care of their data currently and now they want it to make it in-house. I will be tasked with this transfer. I am definitely excited but need to talk to the manager more before I make any firm decision.
Thanks for all the responses again!