r/DatabaseAdministators • • Aug 19 '26

Is Oracle a sinking ship ?

35 Upvotes

I’m a senior DBA based in India, and my management team in the US has been telling us that Oracle is becoming a sinking ship and that we should start exploring new career paths, particularly in AI.

To some extent, I agree with their perspective. I’m seeing more and more customers question the high cost of running their businesses on Oracle and OCI, which makes me wonder how sustainable the traditional Oracle DBA career path will be in the long run.

Whats your thoughts ?


r/DatabaseAdministators • • Aug 26 '26

Creator of InfluxDB & CTO: The end of programming

Thumbnail
pauldix.com
32 Upvotes

r/DatabaseAdministators • • Jun 19 '26

I got tired of manually documenting database schemas, so I built a tool to export them directly to Markdown

26 Upvotes

Hey everyone,

Like many of you, working on a project i realized that quick database schemas change could be a pain to explain to coding agents.

To solve this, I created DBtoMD – a lightweight, open-source tool designed to instantly export your database structure into clean, readable Markdown files (perfect for your GitHub wikis, READMEs, or internal docs).

What it does:

  • Connects to your database and reads the entire schema.

  • Generates clean Markdown files documenting tables, columns, data types, and relationships.

  • Saves time and keeps your team's documentation synced with the code.

It is completely open-source and free. I’m currently looking for feedback to improve it—features you'd like to see, edge cases, or support for specific database dialects.

Check out the repository here: https://github.com/Bilodev/DBtoMD


r/DatabaseAdministators • • Nov 18 '25

DBA vs Data Engineer

25 Upvotes

I have been offered two jobs - Database Administrator and Data Engineer. My background is mostly sys admin and I have done a few little things involving database administration. I keep reading about how Data Engineer is futuristic. I am not sure which one to choose. I have until noon today to make a decision on both.

What drives me is challenge and loyalty. I don't know much about either team I would be on. I know that I have wanted the DBA role for a long time but have had a hard time getting real world experience, I have done a few backup/restore and resolved a transaction log issue.

I am pretty rusty on SQL writing, know very little about Python or Databricks.

I am not sure if either job requires on call or anything. Data Engineer is definitely more entry level, DBA listed 2+ years experience.

Do you think DBA is a dying career? LinkedIn and Indeed both show more jobs available for Data Engineer, especially remote work and I live in an area where there is not much tech jobs to begin with.


r/DatabaseAdministators • • Jun 14 '26

Database

18 Upvotes

I am new to database, doing my masters in data science. I am learning mySQL in depth like Windows functions, CTE, CTA, Store Procedure, etc. I would like to create a good industry standard project. I saw on YouTube, everyone showing generic one. Can anyone please recommend me? Also what other database and tech I need to learn practical way?

P.s - I am fresher who is going to complete masters in few months.

Thank you 😊


r/DatabaseAdministators • • Oct 04 '25

Database adminstrator Career path

18 Upvotes

Which is better for building a career in database administration - Microsoft Azure or Oracle?

I'm passionate about databases and plan to become a Database

Administrator in Saudi Arabia.

I'm also planning to earn a DBA certification, so I'd like to know which option offers better career opportunities


r/DatabaseAdministators • • Aug 11 '26

Being both a C programmer and a DBA taught me one thing

17 Upvotes

After spending roughly 10 years as a software developer and the next 20 as a DBA, I've noticed a pattern.

Developers blame the database.

DBAs blame the application.

Both are usually looking at symptoms rather than causes.

Having worked on both sides, most performance issues I've investigated were caused by interactions between systems rather than a single component.

The bigger the outage, the more likely it was that multiple teams each owned part of the problem.

Experience taught me that technology is rarely the hardest part.

Understanding the whole system is.


r/DatabaseAdministators • • Aug 11 '26

What’s the most terrifying sentence you’ve ever heard as a DBA or database developer?

17 Upvotes

r/DatabaseAdministators • • Jun 30 '26

I'm a oracle dba with 22+ years experience.

17 Upvotes

I've been an oracle dba since oracle 7.3.4. I've seen previous releases but my career started with 7.3.4. I'm at a stage where I would like to retire in next few years. Wanting to pass along to next generation. Offering anyone interested in becoming an oracle dba help. Let me know.


r/DatabaseAdministators • • Nov 20 '25

Student project: can a DBA answer 5 short questions for an interview?

17 Upvotes

I’m a student and I have to make a presentation about the job of a Database Administrator.
I don’t know any DBAs in real life, so I’m looking for someone who can answer 5 or 6 short questions for my school interview.

It would really help me 🙏
I can send the questions directly here in the comments or as a message.

Thanks in advance!


r/DatabaseAdministators • • Sep 24 '26

Starting My DBA Career With Zero Experience

16 Upvotes

Hi everyone,

I’m currently in my first week working as a DBA. I graduated from Software Engineering a couple of months ago.

To be honest, I had almost zero DBA knowledge before starting this job. With the current job market, this was basically the only opportunity I had, so I decided to take it.

The company I joined provides DBA consulting services, and they are willing to train and develop junior DBAs, which is why they gave me this opportunity.

Right now I’m trying to learn as much as possible, but there is obviously a lot to take in.

For experienced DBAs: what would you recommend focusing on during my first few months? What skills or topics do you think are the most important for someone starting from zero?

Any advice, resources, or things you wish you had known when you started would be appreciated.


r/DatabaseAdministators • • Mar 01 '26

roadmap to becoming a DBA

16 Upvotes

I want to become a DBA, so Linux and SQL are the two fundamental skills I need to master, right? What is the roadmap to becoming a DBA in 2026? Please let me know.


r/DatabaseAdministators • • Sep 26 '26

DBA in a consulting company: is working across too many DBMSs holding me back?

15 Upvotes

Hi everyone,
I’ve been working as a DBA at an IT consulting company for about 8 months now (it’s actually my second IT job, I was a data engineer before).
I’ve learned a huge amount during this time, but one thing that still leaves me somewhat unsure is the way we work.
Because we have many different clients — ranging from manufacturing and healthcare to banking — we work with a huge variety of technologies and ecosystems. For example, I deal with Oracle, PostgreSQL, MongoDB, OpenSearch, MariaDB and ElastiCache. We also use IaC tools such as Terraform and Ansible, as well as Oracle OCI, MongoDB Atlas and Amazon RDS/AWS.
On the one hand, I feel that this is extremely useful for professional growth because I’m constantly exposed to new technologies and different environments. On the other hand, I sometimes feel like I’m not really strong in any particular database technology.
It often feels like I learn just enough to deal with a specific issue, on a specific DBMS, at a specific moment. For example, at the moment I might have some doubts about how to properly handle a restore on Oracle, rather than PostgreSQL. I understand the general concepts, but I don’t feel like I have the same depth of knowledge that I imagine a DBA specializing in one particular database would have.
Has anyone else found themselves in a similar situation, especially in consulting?
For those of you who work with Oracle, PostgreSQL and MongoDB, what would you consider the fundamental things that a DBA absolutely needs to know for each of them? What topics would you recommend going deep on to build a solid foundation rather than just learning things as they come up?
I’d be particularly interested in hearing from experienced DBAs about the skills/topics that made the biggest difference in becoming truly proficient.


r/DatabaseAdministators • • Mar 14 '26

Domain change into Database Administrator

15 Upvotes

Hi , I am planning to switch my carrier into database Administrator as I don't want to go into very heavy coding so I am planning to learn postgres sql DBA , can anyone suggest me whether i am going in the right direction?


r/DatabaseAdministators • • May 16 '26

Where can I find a course that teaches PostgreSQL DBA fundamentals (and beyond) for a SQL Server DBA?

14 Upvotes

Hi all,

Our systems are slowly starting to move to PostgreSQL, at least for some services. I'm currently a senior SQL Server DBA and I want to learn PostgreSQL from the DBA side.

Over the past few days I've been trying to find a course that walks through the database step by step, but I can't find anything good or consistent. I've tried Udemy and YouTube and it's all over the place. I can't find a structured course on this.

Does anyone have a recommendation? I'm willing to pay a good amount of money for a quality course, I'm not looking for something free. But it has to be DBA-focused, not developer-focused. I've already picked up most of the new syntax from W3Schools, and after years of T-SQL it's not too hard to adjust to.

Thanks.


r/DatabaseAdministators • • Apr 02 '26

I am building SQL notebooks into an open source database client

14 Upvotes

Hi guys!

I've been working on Tabularis (open source cross-platform db client) and I'm working on a notebooks feature that i think people here might find interesting.

The core idea: SQL cells + markdown cells in a single document, running against your live database connection. no separate kernel, no python, just SQL.

The feature I keep coming back to is cell variable references, you write {{cell_3}} in your SQL and it takes the result set from cell 3 and injects it as a CTE. means you can chain analyses without building giant nested queries. for ad-hoc exploration this is a huge workflow improvement.

You also get:

  • inline charts: bar, line, pie. select label column + value columns, switch between types. nothing fancy but enough for quick visual checks

  • notebook parameters: define params once, use in all cells. good for parameterized reports

  • run all with stop on error: shows a summary of what succeeded/failed/skipped with links to the failing cells

  • parallel execution: mark independent cells with a lightning bolt, they run concurrently during run all

  • execution history: every cell tracks its last 10 runs, you can restore any previous query + result

  • csv/json export per cell, or export the whole notebook as self-contained HTML

  • drag & drop reordering, collapsible sections, resizable result panels

It supports all of databases supported by Tabularis.

The notebook file format is json-based (.tabularis-notebook).

There's a demo database + sample notebook in the repo under /demo.

Github: https://github.com/debba/tabularis
WIP Branch: https://github.com/debba/tabularis/tree/feat/notebooks

Feedback welcome, especially around the cell reference syntax and what else would make this useful for your workflow.


r/DatabaseAdministators • • Sep 09 '26

4 YOE Oracle DBA confused between DevOps/Cloud Engineer vs Cloud DBA — looking for honest career advice

13 Upvotes

Hi everyone,

I’m currently an Oracle DBA with around 4 years of experience and I’m trying to decide what direction to take my career in.

I’m OCP certified and have solid Oracle production experience, including RAC. I’m currently working as an Oracle DBA consultant.

I want to move toward cloud/infrastructure because I don't want to remain limited to traditional Oracle DBA roles long-term.

I’m considering doing a structured DevOps/Cloud course that covers things like:

Linux

Python/scripting

AWS

Networking

Git

CI/CD

Docker

Kubernetes

Terraform

Monitoring/observability

Security

SRE concepts

The idea is to use the course to build the infrastructure/cloud side that I'm currently missing.

But I'm confused about what career direction makes the most sense.

Option 1: DevOps / Cloud Engineer

Oracle DBA → DevOps/Cloud Engineer → Senior DevOps/Cloud Engineer → Platform/SRE → Cloud Architect

The advantage seems to be a much broader job market and potentially higher salary ceiling.

But my concern is that I'd essentially be competing with people who already have several years of AWS/DevOps experience.

Option 2: Cloud DBA / Cloud Database Engineer

Oracle DBA → Cloud DBA → Cloud Database Engineer → Database/Cloud Architect

This seems like a safer transition because I can leverage my existing Oracle experience while adding AWS/cloud skills.

But I'm worried that the career might remain relatively narrow compared with DevOps/Cloud engineering.

Another concern: AI

With AI increasingly automating things like:

Terraform generation

Kubernetes YAML

CI/CD configuration

scripting

log analysis

troubleshooting

I'm wondering how much of a threat this is to DevOps as a career.

Would DevOps still be a good career to enter in 2026?

My main question

If you were in my position — 4 years Oracle DBA experience, OCP, and wanting to move toward cloud/infrastructure — which path

would you choose?

A. Stay Oracle DBA and specialize further

B. Oracle DBA → Cloud DBA / Cloud Database Engineer

C. Oracle DBA → DevOps / Cloud Engineer

D. Something else entirely

And if you recommend DevOps/Cloud, would you take a structured 6–8 month course to make the transition, or would you learn everything independently?

I'm particularly interested in hearing from people who have actually made a similar transition, rather than generic career advice.

Thanks!


r/DatabaseAdministators • • May 26 '26

DBA vs Data Engineer Career

13 Upvotes

Hi, just wanted some opinions on which job has more potential for growth and opportunities. I was once a DBA but I transitioned into a Data Engineering role (Snowflake). I transitioned mainly to get experience with cloud platforms since my previous experience was On-Prem Databases. Did I make the right call to transition to a Data Engineer?


r/DatabaseAdministators • • Dec 08 '25

How would you design a database admin strategy for managing thousands of mixed format datasets with different licenses?

13 Upvotes

I’m working on a system that curates and distributes a huge range of datasets everything from CSVs and JSON files to SQL dumps, images, and proprietary licensed data. It’s not a data warehouse; it’s closer to a structured catalogue where users search, evaluate, and request/download datasets.

I’m trying to think through what the database administration side should look like for a platform like this.

A few things I’m wrestling with:

  • Metadata design: how to structure it so dataset discovery is fast and flexible Storage

  • strategy: keep files inside the DB (Oracle, SQL Server, MySQL, etc.) or store externally and

  • index? License tracking: what’s the cleanest DBA friendly way to represent license types, restrictions, and versioning?

  • Performance concerns: many datasets are large, but the metadata layer needs to stay extremely fast

  • Backup/restore practices: how would you handle versioned datasets and changing licenses?

If you were architecting or administering the backend for this kind of system, what would your approach look like?

I'm especially curious about lessons learned from people who’ve managed catalog style or data marketplace style architectures.


r/DatabaseAdministators • • Jun 29 '23

How to get started with SQL ?

13 Upvotes

It is recommended that you learn the basics of databases before jumping into SQL. This will give you a better understanding of how data is stored, organized, and managed in a database. However, you can also learn SQL in parallel with learning about databases.

Compared to programming languages like Python and C++, SQL is considered to be relatively easier to learn as it is a declarative language that focuses on querying data rather than writing complex algorithms or functions. However, it does require a different mindset and approach to problem-solving.

To get started, there are many online resources available for learning SQL. You can start with free online courses or tutorials and then move on to more advanced topics. It is also recommended that you practice writing SQL queries and working with databases to gain hands-on experience.

To get you started, I will highly recommend you look at these articles.

They will guide you through :

What you need to know to get started:

https://link.medium.com/kz9qL7TtCAb

10 tips you should know:

https://link.medium.com/NsrPQF1tCAb

SQL query Optimization:

https://link.medium.com/LwrtUV7tCAb

Sql queries for complex business reports:

https://link.medium.com/Cbi6fRbuCAb

The power of sql case statement:

https://link.medium.com/rY2G7UfuCAb

Advanced SQL queries for mysql workbench series:

PART 1: https://link.medium.com/Ab6QXnmuCAb

PART 2: https://link.medium.com/mMo35opuCAb

PART 3: https://link.medium.com/DXVhGKruCAb

Understanding SQL inner join with practical examples:

https://link.medium.com/8MYnwLtuCAb

Unleashing the power of SQL aggregate functions:

PART 1: https://link.medium.com/ZKZtBMAuCAb

PART 2: https://link.medium.com/xpA0E7DuCAb

PART 3: https://link.medium.com/7xKteHFuCAb

PART 4: https://link.medium.com/zmMc91IuCAb


r/DatabaseAdministators • • Apr 23 '26

SQL Server DBA transitioning careers - is DP-300 → DP-700 the right path or should I target something else entirely?

12 Upvotes

Background: 26 year old SQL Server DBA, 4+ years experience, currently at a payment gateway company. Have AZ-900 already. Day to day work is mostly on-prem SQL Server — patching, data requests, basic administration. Not much cloud exposure yet.

Personal constraints: Sole breadwinner, parents financially dependent on me, cannot take a career break or stop income. Need a path that works alongside my current job.

Advice I received: Transition from SQL Server DBA to Azure Data Engineer via DP-300 first, then DP-700 (Fabric Data Engineer Associate). The reasoning given was that data engineering builds on my existing SQL Server foundation, pays significantly better, and offers hybrid work culture + For now aligns with ai.

Questions:

  1. Is data engineering via DP-300 → DP-700 the right path for my situation, or should I be targeting a completely different stream or set of certifications altogether?

  2. Is DP-700 the right second cert or should I consider something else like Databricks, AWS, or a different Microsoft cert after DP-300?

  3. What skill gaps should I expect between DP-300 and DP-700 — specifically around PySpark and KQL — and how should I address them?

  4. Is Microsoft Fabric actually being adopted in Indian enterprises or is it still early stage here?

  5. Any other advice for someone in my specific situation?


r/DatabaseAdministators • • Feb 21 '26

1.5 Years as DBA (Oracle + PostgreSQL) – Switch for Better Pay or Move to Data Engineering?

12 Upvotes

Hi everyone,

I’ve been working as a DBA at Accenture for about 1.5 years, mainly handling Oracle and PostgreSQL. I’m thinking of switching jobs for better pay, but I’m a bit confused about the direction I should take.

I’ve also completed a few cloud certifications and have started exploring data engineering. Now I’m unsure whether I should:

•	Continue applying for DBA roles in other companies (maybe aim for higher salary + stronger DBA profile), or

•	Transition into Data Engineering / Database Engineering roles and build skills in that direction.

For someone at my experience level, what would you recommend?

Is it better to deepen DBA expertise first, or switch early into data engineering?


r/DatabaseAdministators • • Jan 08 '26

Portabase v1.1.10 – database backup/restore tool, now with notification connectors

Thumbnail
github.com
12 Upvotes

I’ve been using Portabase, an open-source tool for managing database backups and restores. It’s cron-based and supports three different retention strategies, which works well for logical backups (no PITR yet, but sufficient for me since I run self-hosted services with small to moderate-sized databases).

Currently, storage options are limited to local filesystem and S3-compatible storage—again, sufficient for my use case.

The new v1.1.10 release adds several notification connectors like Discord, ntfy (best open-source tool for push notification!), and generic webhooks, making it easier to keep an eye on backups.

For anyone looking for a simple, self-hosted backup solution without heavy dependencies or complex setup, this is worth checking out (the docs include a ready-to-go Docker Compose setup).

GitHub: https://github.com/Portabase/portabase


r/DatabaseAdministators • • Dec 30 '25

Aspiring DBA

11 Upvotes

I’m in a job right now where I work with data every day; pulling reports, cleaning exports, fixing connection issues, and using SQL to make information less chaotic and more usable. I’m basically the person behind the scenes trying to make the data make sense. I troubleshoot ODBC connection problems, deal with relinking issues, and write queries to clean things up and reduce duplicates so staff can actually get what they need.

All of this has made me really interested in becoming a Database Administrator. I’ve been teaching myself and researching things like MySQL DBA certification paths, SQL fundamentals, backups/restores, server connections, cloud vs. local setups, and what a DBA actually does day to day. The more I learn, the more I realize how much I don’t know, and I don’t want to move forward blindly or build bad habits.

I’m motivated, I’m willing to put in the work, but I could really use guidance. If anyone has advice on where to start, what skills or projects matter most, or if there’s a certification that’s truly worth the time at the beginner level, I’d appreciate it. And if anyone is open to being a mentor or someone I can occasionally ask questions as I go, that would mean a lot.

I want to do this the right way, I just need some direction.

Thank you for reading, and thank you in advance for any help.


r/DatabaseAdministators • • Dec 26 '25

First DBA role feels very slow and it’s giving me anxiety

11 Upvotes

I’m a few months into a junior DBA role under a senior DBA, and I’m struggling more with the lack of work than I expected.

Before this, I worked as a SQL programmer (assisting with Tech Support here and there) and was busy almost nonstop. I worked for a 2 man IT team and there was always something to do and progress felt very visible. In this role, at a much bigger company, work tends to come in bursts. Some days I have tasks or the Senior DBA will pull me into a meeting or 1 on 1 call to teach me something, but other days I have nothing assigned.

I use the downtime to practice more advanced SQL and read about indexing and query tuning, but mentally it’s tough. I keep worrying that I should be doing more, that I’m not providing enough value, or that being idle makes me look unnecessary. At the same time, I don’t want to bug the Senior DBA or ask for work too often. He works remote and I work in an office, but he surely knows that I am not too busy over here, so I feel to some degree assigns me work and teaches me things when they come up on his end.

I haven’t gotten any negative feedback, which is reassuring, but also makes it harder to know if this is normal or if I should be pushing harder for more responsibility.

For any DBAs who might have nor not have been through this, especially early in their careers:

  • Is this kind of slow pace normal?

  • Should I be worried about job security?

  • How do you handle the anxiety during downtime?

  • When does it make sense to push for more ownership instead of just self teaching?

Any perspective would be appreciated.