What is the job of SQL administration?

Question

Career in IT

I often see the same requirement in system administrator vacancies - SQL server administration (Microsoft SQL, MySQL, Oracle, etc.), but I have no idea what it is.
What should a system administrator know in terms of SQL, its administration? Is it somehow related to 1C?
Microsoft SQL, MySQL and others are they fundamentally different?
I would be grateful if you could tell me literature - books and video courses (preferably short, but at the same time informative) in order to cover the topic of SQL administration as much as possible and fill in the gaps in this, because, as I understand it, the system administrator must know this.

Answer 1

because as I understand the system administrator must know this

is not a fact. in small companies more often yes, but the larger the infrastructure, the more likely it is that there are admins and database admins , with different tasks and powers

Is it somehow related to 1C?

possible, but in vacancies of this type it is always explicitly indicated

What should a system administrator know in terms of SQL, its administration?

- the most essential - the ability to create backups, even more important to restore databases from backups
- routine - create databases, provide access to them according to some plan / regulation, users, developers, etc ..
- do not be surprised - delete databases (usually accepted make backups, suddenly the manager changes his mind)
- advanced skills - solve performance issues, such as why the base is dumb? maybe the hardware is out of order, maybe it's outdated, maybe the developers screwed up, maybe the users screwed up ...
.. not enough? .. I assure you, you can add more, well .. I'm too lazy, sorry .. ))
ps and yes - in all of the above, a video tutorial for 15-30-45 minutes will not help. only experience. well, or good books, pro blogs (in the simplest case, habr by tags), but always personal experience
pps .. in catch -up
- database migrations. for example, from old hardware to cool new, but so that without interruption in customer service;))
- cluster management - fault-tolerant, and there are schemes and clusters of load distribution, even for the database))
something like this in general .. there is no limit to perfection ..

Answer 2

- advanced skills - solve performance issues, such as why the base is dumb? maybe the hardware is out of order, maybe it's outdated, maybe the developers screwed up, maybe the users screwed up ...

90% of skill, salary and everything else for DB Administrator
CRUD and so on and devops will look at stackoverflow

Answer 3

If you do not even know how to use the search, it makes no sense for you to be interested in this issue.
https://en.m.wikipedia.org/wiki/Database_administrator

Answer 4

1) Install (deploy)
2) Backups, configure, track what is working.
3) Recovery from backups
4) Solving performance issues (when everything slows down). These are query plans and so on.
1 - simple
2, 3 - simple, but requires responsibility
4 - not always required, but means the highest qualification in this matter.
Access rights to the database, although they exist, are hardly essential work for their purpose.