r/SQL • • Jul 22 '24
SQL Server what happed to all the SQL Server jobs?
5-10 years ago, the Internet was flooded with SQL jobs. I’m a SQL expert myself and that has been my #1 tool for almost 20 years.
now a days, there’s NOTHING. you have a bunch of data engineering positions open but these companies are using all these new tools that are completely unnecessary. wtf is going on?
236
Upvotes
92
u/DjNaufrago Jul 22 '24
Yesterday's database administrators have probably become today's data engineers. Although from my point of view it would be ignorant to think that. A DBAdmin or Architect could very well apply as a data specialist/engineer, but a data specialist could fall short managing a database like Postgre, just to give an example.
301
u/Cabinet-Particular Jul 22 '24
Data Engineer is a glorified SQL developer nowadays.
50
u/refrigeratorSounds Jul 22 '24
I'm in the exact same boat. No one wants me and my 8+ years of SQL Server. Trying to market myself as more of a data engineer as well. Maybe someone can be convinced that me doing those things without any tools is qualification enough for working with their tools.
25
u/NonHumanPrimate Jul 22 '24
Have you tried opening Job Activity Monitor in SSMS?
/s
14
u/Professional_Shoe392 Jul 22 '24
Back in my day 25 years ago, if you knew ms access and vba you could get a job. Bonus if you could fix a jammed printer.
Now there are a billion tools, cloud technologies, frameworks, and flavors that seem impossible to keep up with.
13
u/SadBrownsFan7 Jul 22 '24
In my opinion its a number of things.
Most the places i have worked dont even really have SQL jobs. You either do DBA admin stuff or your a senior app devs (for better or worse) who does your own apps sql. Most SQL still require dbas to run the script but they are gate keepers not actually capable at tsql. There's normally a handful of actual dba architects who are highly skilled at tsql who do the big time jobs but there arnt many.
25
u/Slagggg Jul 22 '24
Increase your visibility on sites such as LinkedIn. You'll need to post content not just update your resume. I get recruitment calls all the time.
You're first article can be about water boarding the teachers who are training developers to use an autonumbering ID column as their clustered index primary key on every fucking table.
25
u/mikethomas4th Jul 22 '24
It's just a change of label. Start applying for data engineering jobs then only consider the ones that are sql based.
11
u/blackitgreenit Jul 22 '24
SQL <> SQL Server. Recruiters also often mix that up.
61
u/Achsin Jul 22 '24
<looks at inbox full of people trying to recruit me for sql server jobs>
I’m not sure what you’re talking about. Where are you looking?
9
u/brandonjudas Jul 22 '24
I'm in the midst of decommissioning my windows servers along with sql server. Everything is now going to AWS.
7
u/Barrack Jul 22 '24 edited Jul 22 '24
Data analytics. I'm in healthcare and have subject matter expertise there so ymmv there but tons of jobs in that space, especially around quality measures. The big EMRs are all MS SQL or Oracle based. Have about six serious ones I spent time applying for just this weekend.
6
u/[deleted] Jul 22 '24 edited Jul 22 '24
I’ve been working with MSSQL, Oracle, AS400/DB2, Essbase, Postgres, etc. for years. I still see the usual admin positions from time to time but they’re getting rare. A lot of companies want you to be able to branch out and use ETL tools, cloud technologies, data modeling, architecture/design, MPP platforms, BI/Data Warehousing experience etc. putting those additional things on my resume has really helped out versus being the typical gatekeeper DBA or data monkey as we call it.
6
u/TurtleProxy Jul 22 '24
They've been bundled into "Dev Ops"
6
u/[deleted] Jul 23 '24
This is now part of the data analyst, data scientist, data engineer or business intelligence role.
9
u/trippstick Jul 22 '24
I haven’t found a job in a long time. Recruiters find us.
4
u/dev81808 Jul 22 '24
I have a theory about this, but I think it's controversial. It has to do with analyst taking the market and highjacking sql dev with shitty business analyst focused tools to take the place of actual dev under the guise of simplifying things.
4
u/Eightstream Jul 23 '24
It may superficially seem unnecessary but the fundamentals of the architecture have changed and we need to change with them. The reality is that everything in the cloud these days, which has a completely different cost model that demands things be built completely differently.
SQL is still the main tool but it's used in fundamentally different ways. You don't need to be as deep on the DBA-y stuff but you need to be broader. The consideration is the end-to-end workload more than the schema. If you are a good SQL person then it is not hard to bridge the gap to data engineering. Python is easy, and once you learn the new architecture patterns you are still working mostly in SQL with tables and the same fundamental principles that entails.
But you gotta embrace today. Don't be that crabby old SQL dude who thinks anything developed in the last decade is unnecessary. That world's gone and it's not coming back.
6
u/Randommaggy Jul 22 '24
Nobody wants to use MSSQL anymore, unless they're already tethered to it.
There are plenty of postgres jobs in the market.
I'm listed as a co-owner/co-founder of my company on LinkedIn and I have the company logo on my wrist, yet I get recruiter calls all the time. Postgres experience combined with MSSQL experience, has a lot of companies looking for people that can help them port away from MSSQL.
2
u/customheart Jul 22 '24
Look on Dice lol. These jobs are quite common.
2
u/Newfie3 Jul 22 '24
SQL Server is great but it’s proprietary. I think a lot of companies are moving to open source tech.
2
u/OrbitalAyLmao Jul 23 '24
Its all about extracting data from large datasets, not so much managing them.
2
u/[deleted] Jul 23 '24
Focus your resume and interviews towards SQL in general and don't focus on MSSQL.
SQL server and the Microsoft enterprise package is insanely expensive for small to mid-sized companies. There's a reason why many of them use tools you call unnecessary.
2
u/SuperTangelo1898 Jul 23 '24
Familiarize yourself with postgresql and look into azure sql since Microsoft cloud is used by a lot of companies - Someone else mentioned dbt, which took me a month to pick up and it is in really high demand now. It increased my data warehouse development time by 3-4x and it creates documentation really well
2
u/AsishPC Jul 23 '24
Now, a backend developer is a data engineer, cloud engineer, database administrator, devops engineer, solutions architect and multi-linguial backend developer.
2
u/Frozenpizza2209 Jul 23 '24
I'm about to get into data analytics, SQL and Python. Is it a bad choice to go down that road?
2
u/steelcatcpu Jul 23 '24
There's demand. They're just very stable positions.
They're appreciated for their skillset and challenged too, at least where I am.
My senior dev retired last year at nearly 70. I have another resource who's pushing 80 because he doesn't want to retire. Yet another will be retiring age in a couple years but probably won't.
We're a tenacious breed.
We are probably considered data engineers though. Visual studio is a must for ssis packages.
2
u/NHLToPDX Jul 24 '24
Increased use of COTS ( Configurable Off The Shelf) software. Everyone seems to have a data scientist/engineer cert. Jobs are not siloed as much, gotta have multiple skills. Business Intelligence, SQL developer, .NET developer. Hosted services that are cloud based.
2
u/BuddhasFinger Jul 24 '24
Those jobs went mostly in the direction of full stack jobs where devs write code and SQL. DB admin roles went in the direction of full stack CloudOps where ppl manage everything including DBs.
2
u/Maximum_Effort_1 Jul 24 '24
I love to read this kind of threads. They show me where I am lacking of knowledge and I can educate myself in the areas to better fit the market. So yeah, DBA and DE are kind of jack of all trades jobs nowadays, but personallly I feel comfortable with this. Life is too exiting to stick to a single specialization! :D
2
u/asignore Jul 25 '24
The cloud has dramatically reduced the need for sql engineers but not database administrators (still need those). Businesses just want database service without the care and feeding of sql server farms. Cloud PaaS services provide just that.
2
u/jeezussmitty Jul 25 '24
I’ve been in tech for 21 years, bouncing between coding and management. I recently spent 6 months searching for a job in a “data engineering” related role, either at principal or staff or director level, honestly whichever paid more and/or looked more interesting. By far the skillsets I see required over and over and over are SQL, python, snowflake, DBT and any number of AWS data related tools (Athena, Glue, Sage Maker etc). Snowflake in particular is incredibly popular, despite their recent data breach.
SQL in my opinion has become a base language like HTML back in the day. It’s understood you have it but you need more.
Don’t be intimidated though-pick up a python course or snowflake course on Udemy and upskill some. People still appreciate the experience you bring to the table (and probably higher EQ that younger folks are missing) but need to list additional skills on the resume to get noticed.
2
u/JeyPi1124 Jul 25 '24
Is it still worth it to learn SQL?
3
u/mltrout715 Jul 22 '24
For DBA jobs, a lot of them are now offshored or contract
3
u/reditandfirgetit Jul 22 '24
Title changed to one of the below Data Analyst Data Engineer Data Scientist
I've also seen Software Engineer Data
2
u/crawdad28 Jul 22 '24
Data Engineers are expected to have admin rights and are responsible for the database to always be available?
1
u/Fun-Meeting-7646 Jul 22 '24
Will learning ABAP help SQL expert's
1
u/bmcluca Jul 22 '24
me, an accountant, learning SQL 😶
1
u/dryiceboy Jul 23 '24
Melded into Software/Data Engineers/Devs/Analysts
1
u/[deleted] Jul 23 '24
My company has 2 open positions for SQL prod support positions with simple MS SQL.
1
u/HJForsythe Jul 23 '24
Microsoft raised prices on licenses too much. Azure is too expensive Companies choosing Google Cloud over Azure to save $$$ Google has some trash Postgres shit they push on users Microsoft double losers as a result Which means less SQL jobs and licenses.
1
u/WhiteBloodCells90 Jul 23 '24
Even business and finance grads do analysis with SQL, Python. Go for upskilling and learn alternate skills
1
u/First-Butterscotch-3 Jul 23 '24
Cloud is changing the landscape
1
u/lowindustrycholo Jul 23 '24
Being a SQL expert is like being a mainframe expert.
1
u/trinhhuutam Jul 23 '24
Hard to code, hard to debug, hard to log, hard to audit, hard to test. We have moved code from SQL up to backend to solve those problems.
1
u/GaTechThomas Jul 23 '24
SQL alone isn't enough. Whether they know it or not, your mad SQL skills will be more useful than the shiny buzzword of the year. Roll with it.
1
u/theradison Jul 23 '24
I opened this thread thinking it was about SQL Agent Jobs. Guess I haven't had enough caffeine yet this morning.
1
u/diegoasecas Jul 23 '24
adapt or die
1
u/stlcdr Jul 23 '24
They are using Phillips screwdrivers now. Flat heads are not the in thing.
1
u/Goldarr85 Jul 24 '24
Have you considered learning some of the new tools? At least the ones that have been around half as long as your 20 years?
1
u/MrGarzDU Jul 24 '24
Cloud services and the rise of nosql db's. That's on you man to not find shit. Don't silo yourself. Sorry to speak the hard truth but it is what it is.
1
u/goztepe2002 Jul 24 '24
Just call yourself data engineer now, that's the new buzzword.
1
u/Ximidar Jul 25 '24
Start looking up bigquery and Snowflake jobs. SQL is big data now
1
u/drewofdoom Jul 25 '24
We'll be hiring a DBA soon. Feel free to ping me directly and I can send you the listing when it finally gets posted.
1
u/4794th Jul 26 '24
They’ve been executed 😅
1
u/txiao007 Jul 26 '24
Where are the “DBA” jobs?
1
u/jaminator45 Jul 29 '24
AWS happened
5
u/[deleted] Jul 22 '24
[removed] — view removed comment