Oracle DBA is far away

Why is it so difficult to find a good Oracle DBA?

This is not only the pain of many CIOs, but also the problem that many IT directors cannot solve. But where do so many people who have obtained OCP certification from ORACLE training courses go?

 

Tom is a database administrator with An OCP license and a certain understanding of the database architecture and operating principles. I thought everything was okay, but as soon as I took office, Tom was faced with the problem of replacing the host of the company's database system. Tom has no experience in program development, host system management, etc. Tom is the kind of person who will take an OCP test after graduation and then become an Oracle DBA. As a result, he will face many challenges as soon as he takes office.

Since the database system was taken over by Tom, there have been a bunch of strange problems.

Where is the problem? Even though I know that the database system is not running smoothly, I have never been able to find the crux of the problem for a long time, he became the target of "attacks. And the situation is getting worse and worse. At first, everyone went to Tom only when there was a problem with the database. Later on, as long as a problem occurs, whether or not the problem is obviously related to the database, the first action of everyone is to push the problem to the database or to the Tom.

This situation makes the work of Tom increasingly difficult. The reason is that Tom doesn't know how to manage the host system or write programs. When everyone says "Everything is a responsibility of Tom", he doesn't understand the situation at all, you can only touch your nose and stick it down. He left after a year of hard work. So far, he still dared not tell others that he had an OCP license.

 

There are a total of 25 students in the training class of Xiaobai. At the beginning, there were about 15 people who obtained the OCP certification. After several years of work in the workplace, there were about 6 people now engaged in Oracle DBA-related work. Three of these six members "work as" Oracle DBA "as supervisors. Oracle DBA has a high death rate in the IT workplace. The main problem is that the cause of Oracle Database problems is often not just from the database.

 

It is estimated that there are not many problems caused by databases alone. Most of the problems are caused by the aging of system hosts and other hardware, in addition, 1/3 of the problems come from program writing, such as poor SQL syntax writing habits.

In terms of SQL syntax writing habits, when the Database Loading is still very light, these problematic SQL syntax will not have a great impact on the database or system, however, when the database data grows rapidly or the host load is full, the preceding SQL syntax is like a box of porridge, which will directly affect the operating efficiency of the entire database system.

 

However, the Oracle Database courses provided by the Education and Training Center do not teach any knowledge other than the Oracle database system. Therefore, non-Databases themselves cause operational problems, most of the new users who are new to DBA are not competent.

Therefore, when an enterprise says they cannot find competent or useful Oracle DBAs, they may not be the ones who say they cannot find a database that understands the database. In fact, they have obtained OCP certification, I want to know more or less about databases. They should mean that they cannot find people who can use the full view, to resolve, process, and solve the causes of database O & M failures.

 

How can enterprises select a correct Oracle DBA?

Most enterprises require Oracle DBAs to maintain the normal operation of the database and assist the database in data backup. Therefore, they have experience in managing large host systems, users with storage management experience are preferred, or those with knowledge of operating system principles and operations. Because the Oracle database is not operating normally, it is often because the system is out of the situation and users with system management experience are often asked to work as DBAs, to a certain extent, the database information personnel should be able to find the problem quickly. In addition, it can avoid database downtime and other situations.

Secondly, some enterprises want to find the person who understands the data processing process when looking for Oracle DBA, so as to greatly consolidate the data in the existing database and optimize data transmission and analysis. For example, write some store functions, triger, and DB_link. In this situation, find people with development experience, especially those who have actual development experience on database access. In addition to being sensitive to data and data structures, we are also familiar with the customer's needs and know how to refresh the database.

It is important to note that there are only a few people with both system management and program development technical capabilities. Therefore, before recruiting a DBA, we recommend that you first think about the talent you want. However, no matter which type of Oracle DBA you are looking for, I do not recommend that you find a person with only OCP certification but no other work experience as a DBA. This means that it may take a long time for enterprises to implement database management, and DBA is also very hard during the pain.

 

So how should I go as a person who wants to go through Oracle DBA?

It should be clear to everyone through the above understanding.

1 first, you must have a deep understanding of ORACLE databases, operating mechanisms and principles, Backup recovery, performance adjustment, and security auditing.

2. You need to know about Linux and Windows 2003 Data Center, including configuration, monitoring, and logs.

3 understanding of the stored procedures PL/SQL T-SQL MySQL syntax and the corresponding stored procedures, triggers, views, replication release can see clearly, can be converted to ORACLE PL-SQL

4 storage device RAID cabinet, tape drive

5. It is necessary for the Application Server to understand Weblogic TomCate Apache IIS6.0 and know the configuration, performance, and log.

6. JAVA, ASP, C # Open language, J2EE, and NETWORK2.0 understand the syntax and operating principles.

7. At least English can be viewed and written, although it is rarely used in practical work.