database administrator, English is the DBA. This position means a different meaning to different people. A small software development studio is a much broader responsibility than a large company with a high level of specialization. A company, whether it is developing its own application software, or buying third-party applications, as long as it involves the database (how many applications that do not involve databases)? The database is the soul and brain of the business, and you need to decide whether to hire one or several DBAs. Knowing what the DBA is asking for is critical to the definition of the position within the enterprise or to the future DBAs.
maintain archival or backup data on the appropriate media
Contact the manufacturer of the database system to track technical information.
Why are these personality traits important?I have a few people who lack self-confidence, they repeatedly ask me some of the questions, they do not have the confidence to even make the smallest decision. They also lack the initiative to work. This may not be a big problem for junior DBAs, but for senior DBAs, if they lack self-confidence, who can they rely on to help them make decisions? In a DBA interview, even if you can't answer a technical question, you should show enough self-confidence. The most fatal is not to know the answer to the question, but do not know where to get the answer.
almost all of the database systems are constantly being updated. However, not all updates have technical documentation. For a good dba, Curiosity is necessary. DBAs without curiosity and thirst for knowledge always wait for someone to tell them the answer. A highly inquisitive DBA will install the latest version of the database system and immediately start searching for even minor features and performance differences and enhancements to improve their work. One of the questions that must be asked when taking a test is: What references do you have on hand? How do you use them? There is no doubt that if you only answer the documents of the database, or you have not even read them, your "stock market value" will be greatly reduced. Curiosity drives DBAs to understand data Dictionary, management tools, or other support packages (Packages).
DBAs often run into tricky problems. Finding the answer is a personality trait that requires tough willpower and can withstand beating. I often see the questions the DBAs ask in some discussion groups or forums, which are often the questions that the questioner can solve if they have tough personality traits and try to find the answer to the question.
Self-drive is important for everyone, especially for DBAs. The DBA should be able to find a way to make the problem happen instead of waiting for it to happen. Self-driven DBAs often try to get or write some of the necessary scripts (script) to monitor items including datasheet size (table size), tablespace usage (tablespace Usage), and these items will be in trouble if they are ignored. When taking the test, DBAs are often asked to experience Pl/sql, SQL or Sql*plus, and these questions will separate you from the DBAs who have never written the scripts you need.
Needless to say, you need to be sophisticated enough to deal with the user, with programmers and administrators. A little DBA will not do anything good for you, it will only ignite hostile passions in your department. Tact is the ability to advise someone to go to the underworld, Haha, and in the end this person is in the mood of longing. Most of the time, developers, managers, and users will make unreasonable demands, and DBAs need to be adept at directing, correcting, and persuading them. When you take the test, your response can be a good indication of your tact.
finally said that attention to detail, this disposition is very important. Attention to detail the DBAs are neatly dressed, have their own schedules, and investigate the units they apply to before taking the test. The DBAs who pay attention to detail understand the kernel of the database and understand the relationships between views and tables.
The primary DBA is the best distinction. Intermediate DBAs and senior DBAs are not very well differentiated. Their differences lie in differences in experience and personality traits and abilities. There are a number of intermediate DBAs who are capable of most of the work of a senior DBA, including:
Backup and Restoresolve the general problem
senior DBAs are very few in the country. They bought too much data on the database in English, perhaps from a friend from Amazon. The money to buy books is a very small proportion of their remuneration. Advanced DBAs are generally familiar with several large databases under many operating platforms. They know the strengths and weaknesses of different databases in different environments, and can make decisions on the choice of database platforms and database environments. They are generally familiar with system architecture and database design, and can optimize the database at various levels. Senior DBAs are usually equipped with assistants who are more inclined to make decisions and plans. Senior DBAs are often in the key business areas of banking, insurance, online trading, and so on that have high stability, security, and performance requirements.
If you are going to be a DBA, it is recommended that you choose a database system that is now more popular. This means that you will have more opportunities for employment, communication and training, and that there are popular reasons why you can worry a lot. Of course, the employment competition pressure is also relatively big. The average beginner chooses Microsoft SQL Server, a database system that is ideal for small and midsize enterprises, and readers who are familiar with access can easily become a DBBS by using Microsoft SQL Server initially. J
If you have access to Oracle, that's a good chance. Oracle is currently the most promising database manufacturer, because of its powerful capabilities and configurable, manageable, Oracle DBA salaries are generally higher than other database administrators. Moreover, Oracle's key applications in large and medium-sized enterprises are more common. Oracle can run on platforms such as Windows NT, Sun Solaris, Linux, and so on. In many cases, you are not only familiar with NT, but you are also familiar with UNIX, and Oracle's unfriendly interface and box of Oracle product data can also be a hindrance.Oracle 8i Standard Quote, if run in Windows NT, with Jserver and intermedia, support 5 concurrent users, quote 3925 USD per CPU. When adding concurrent users, 785 dollars per user. Add additional named users when 392.5 dollars per user.
There are two versions of DB2: Workgroup Edition and Enterprise Edition. Workgroup Edition 999 USD per server, plus 249 USD per concurrent user. And the Enterprise version is 12500 dollars per CPU, unlimited number of concurrent users.