How is a real DBA?

The database administrator-DBA, in simple words, is a lot of things for many people. In a small-and medium-sized enterprise, he has a wide range of work, while in a formal management of large enterprises, his work will be very specific. Whether your company is developing or applying third-party development tools, you need to decide whether to hire a DBA. know whether your company needs this position and what it really does, And the DBA at that level is suitable for this position. For a company or hired person, is crucial.

DBA's main responsibilities:

1: Install and upgrade the Oracle server and application tools.

2: Set the storage system of the system and plan the future storage system of the database.

3: design, plan, and establish a database.

4: Create a table space to monitor and manage the table space.

5: create database objects (tables, views, indexes) and monitor and manage them.

6. Change the database structure, usually according to the requirements of application developers, and sometimes according to the system settings.

7. Monitor and control the user's connection to the database and configure the network connection.

8. Create users and manage database security.

9: database and SQL optimization.

10: plan and plan database backup and recovery.

11. Manage distributed databases and dynamically copy databases and slave databases.

12: Contact Oracle for technical support.

As a real dBA, you must have all the knowledge and skills mentioned above.

DBA personality:

As an Oracle DBA, in addition to solid database management technical skills, it must also have a unique personality. In the past work, a DBA's personality was discovered through contact and understanding of many DBAs, which has a great impact on his work. On the one hand, a dba must face other people, such as providers, users, developers, and different superiors. On the other hand, they have the most important and critical tasks, this is often the case when database problems occur. At this time, they have to withstand great mental pressure.

Self-confidence is very important to Oracle DBAs. It is not the worst thing to remember that you do not know the answer to a question or how to solve it, the worst thing is that you don't know how to find out the answer and how to solve the problem. I had to have a strong curiosity to keep up with Oracle's constant changes. When I first came into contact with Oracle, I was using oracl6. Today I am Oracle 9i. I need to figure out every change. Tenacity and tenacity are equally important. It is very likely that your database will not be available for two days or two nights. Smart and intelligent, allowing you to constantly accumulate work experience and problem-solving skills. Self-increment and progressive. As an Oracle DBA, most of your spare time is reading documents and reference books related to Oracle DBA. Since you want to get on this "thief ship", you must make preparations in advance. Pay attention to the details, ask why for every small change and question, and try every means to clarify him.

How to become a real DBA:

To become a real dBA, two aspects of knowledge are indispensable. One is: a very solid basic database knowledge, including basic concepts and structures. To do this, the best way is to select a really powerful training company for training. Because Oracle databases are abstract and logical, it is difficult to learn by yourself. second, rich work experience-the ability to handle and solve problems, to achieve this, on the one hand, through a long period of work, get in the work, this takes a long time, there is also a better way, where experienced DBAs can pass on to you in a real environment to grant such work experience, which requires experienced DBAs, at the same time, there must be a real application environment.