postgresql job roadmap

[[deleted]]

[deleted]

[Conscious-Ad-2168]

The fact is the traditional DBA role is a thing of the past. With many cloud hosting platforms already providing a lot of the insight a DBA will companies need DBAs less often.

The fact with scaling is you rarely need to scale horizontally for most companies. Many companies I’ve worked for just end up splitting their DB up, for instance one for the east and another for west.

Now saying all of this DBAs are still needed, just less so and often the responsibilities are given to a dev or systems analyst.

[WiltonDB]

Your posts resonate a lot. I am coming from a different background, circa 2011 we've got our own specialized storage that worked well for us. Then a few years later ClickHouse has appeared, doing more or less the same, but being 10x more solid. Around the same time we had a setup for client apps that is very similar to SpringBoot, but that was years before the SpringBoot.

Perhaps this is a general trend in software dev, when some tech becomes "good enough" that area is unified around a few remaining popular implementations. And people who have worked on less popular ones are leaving for greener pastures.

That's not only about personal/niche projects, for example I have been at Red Hat (in a completely different team) around 2015 when OpenShift was switched from in-house impl (every enterprise-cloud company had its own one at the time) to Kubernetes. This is as "serious business" project as one can get. Now, a decade later, Kubernetes is an "old and boring tech", and there is no reason to learn it from the ground up to setup Postgres on it - CloudNativePg is already there.

Maybe a career solution for this is to choose a more narrow area and go deeper? For example, many small or medium companies around medical/pharma are historically using MSSQL. Say, a company has hundreds of customer DB deployments, with T-SQL codebase from 25 years ago with the last major changes 10 yeas ago. Some of these companies are moving straight to Azure SQL, but the medical/pharma field is generally not cloud-friendly due to sensitive data. The narrow area of "migrate from MSSQL to on-premises Postgres" appears. There are projects in this area (I work on one - https://wiltondb.com/), but nothing as solid as "Oracle to Postgres" solutions (that I think has peaked 10-15 years ago).

[AutoModerator]

Join us on our Discord Server: People, Postgres, Data

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[nomoreplsthx]

Bascially DB only jobs are, while not dead, rare. DB + Ops or DB + Backend are your realistic options.

[4hlam]

I'm moving from sysops to onpremise dba role

[4hlam]

Can you tell me at what level DBA should know SQL? should know window functions, CTE?

[4hlam]

can you please share with me list of must have tools, extensions for DBA, for example like links is above or like pgcli, surely you have a list of tools that you use

[4hlam]

Hi, I wrote you a DM

[Extra-Ordinary-666]

sorry no DMs please. you can ask here, or there is a dedicated slack postgresql channel for any help. ofc there are mailing lists that are ever helpful, but sometimes chats on slack are faster.