Database administrator DBA What is DBA?
Database administrator, English is Database Administrator, referred to as DBA. This position does not mean different people. A small software development studio compared to a large company with a division of labor than a large company, DBA's responsibilities are wider. A company, whether it is its own application software, or buy a third-party application, as long as it involves the database (how much does not involve application software? The database is the commercial soul and the brain), you need to make a employment one Or several DBAs. I know which requirements for DBA positions, which will be critical to the definition of this position within the business or for those future DBAs.
Some responsibilities of DBA:
Install and upgrade the database server (such as Oracle, Microsoft SQL Server), and the application tool. Database design system storage solutions and develop future storage requirements plan. Once the developer has designed an app, you need DBA to create a data storage structure (TableSpaces). Once the developer has designed an app, you need DBA to create a database object (tables, views, indexes). According to the feedback information of the developer, the structure of the database is modified as necessary. Users who register the database to maintain the security of the database. Guaranteed the use of the database in accordance with intellectual property. Control and monitor users' access access to the database. Monitor and optimize the performance of the database. Develop database backup plans, the disaster occurs, restore the database information, and the manufacturer of archiving or backup data backup and recovery database contact database system, tracking technical information.
DBA personality features
Many times the management personnel ignores the personal characteristics of DBA, they only pay attention to DBA's technical capabilities. In fact, every responsibility mentioned above means that DBA needs to be deal with various people, which may be vendors, users, developers or managers. This shows that DBA must have the following personality features:
Self-confident curiosity and tenacity, old, self-driving, pay attention to detail
Why is these personal characteristics important?
There will be a few lack of self-confidence, they repeatedly ask me that there is no worse problem, and they don't believe in the minimum decision. They also lack the initiative of work. This may not be too big for primary DBA, but for those senior DBAs, if they lack self-confidence, they can rely on who can help them decisive? In the DBA interview, even if you can't answer a technical issue, you have to show enough self-confidence. The most deadly is not an answer that I don't know the problem, but I don't know where to get an answer.
Almost all database systems are constantly updating. But not all updates have technical documents. For good DBAs, curiosity is required. DBA without curiosity and curiosity is always waiting for someone to tell them answers. And a known desire of DBA will install the latest version of the database system and start searching for those who are subtle features and performance, thus improving their work. The question that is inevitably asked at the time is: What references do you have? How do you use them? There is no doubt that if you only answer the documentation of the database, or you have not even read them, your "stock market value" will greatly decline. Curious heart will drive DBA to understand the Data Dictionary, managed tools (Tools) or other support packages (Packages).
DBA often encounters a tricky problem. Looking for an answer is a personalized feature that requires tough willpower and can withstand the fall. I often see the issues raised by DBA in some discussion groups or forums. These issues are often the questioners you can solve. If they have tough personality features, and strive to seek questions about the problem.
Self-driven is very important to everyone, especially for DBA. DBA can find a way to make problems, rather than waiting. Self-driven DBA often try to get or write some necessary scripts (Script) to monitor projects including Table Size, TableSpace Usage, and these projects are ignored, they will encounter trouble. DBA often asked the experience in PL / SQL, SQL or SQL * PLUS, which will distinguish between those DBAs you have never written from scripts you need.
Needless to say and users, it is to deal with programmers and managers, and you need to be cheerful enough. A little DBA will not do anything for you, and will only ignite the enemy's mood in your department. Sophistication is such a ability, you advise someone to go to the government, haha, and finally this person went to the mood of the desire. Many times, developers, managers, users, they will make unreasonable needs, and DBA needs to be guided by the land, and correct their requirements and persuade them. When you try, your response will now explain whether you are old. Finally, talk about details, this personality is very important. Pay attention to the details of the DBA clothes, have their own schedule, and have been investigated in front of the unit before the test. Note DBA in detail deeply understand the database's kernel and understand the relationship between the view, the table.
DBA level
The level of DBA is not very strict. According to the master of the database, I simply divide three levels: primary primary, intermediate intermediate and advanced Senior.
The primary DBA is also called DBBS, which is an abbreviation of the Database Baby Sitter. Primary DBA is often part-time, and they are often a programmer or other work. The primary DBA often writes a great resume and participated in a lot of database-related projects or work. However, these items or efforts are often: Third-party software vendors have installed and configured databases, they only do some monitoring work. They can handle some simple questions, but most of them ask the application software supplier. The primary DBA prefer graphic database management or monitoring tools, they like the desktop database such as Access, and simply applied these small databases to the large database related work.
The primary DBA is best distinctive. Intermediate DBA and advanced DBA are not very good. Their difference is the difference between experience and individual characteristics and ability. There are many intermediate DBAs, they can compete for most of the advanced DBA, including:
Database Installation Database Configuration and Administration Permissions Settings and Security Management Monitoring and Performance Adjustment Backup and Recovery Solution General Problems
Intermediate DBA is often from a year, familiar with the database in a certain operating system environment. Because of the intermediate DBA, Windows NT and UNIX are very different. Intermediate DBA is more familiar with SQL, and they bought a few books in this database and in-depth research. Intermediate DBA often serves as a database programmer, their work is basically not very high in performance, stability, and security, often with advanced DBA to do some routine work.
Advanced DBA is very small in China. They have purchased too many English materials in the database, perhaps friends buy from Amazon. Relative to their remuneration, the money bought the book is a few proportions. Advanced DBA is generally familiar with several large databases under many operators. They know the advantages and disadvantages of different databases in different environments, and can make decisions in the selection of database platforms and database environments. They are generally designed in system architecture and database, and can optimize the database. Advanced DBA is generally equipped with assistants, they are more biased towards decisions and programs. Advanced DBA is often a key business handling in the field of stability, security, and performance in banking, insurance, online transactions.
Many times, whether the database expert certification certificate is not important. I know that many database vendors will receive a certificate as long as you go. There are a lot of companies to provide commercial training, and their service quality is also very bad. Therefore, the certificate is not particularly meaningful. Several popular database systems
The most "easy" database system - Microsoft SQL Server
If you plan to be a DBA, it is recommended that you choose the database system that is now more popular. This means you will have more employment opportunities, exchanges and training opportunities, and the reason you are popular, you can save a lot. Of course, employment competitive pressure is relatively large. The general entry selection Microsoft SQL Server, which is a database system that is very suitable for small and medium-sized enterprises. Readers who are familiar with Access can easily use Microsoft SQL Server to become a DBBS. JMicrosoft SQL Server 7.0 quotes, 5 users version of $ 1399, increase users, 127 US dollars per user.
The most "difficult" database - ignorant king oracle
If you have the opportunity to get in contact with Oracle, it is a good opportunity. Oracle is currently the most optimistic database vendor because of its powerful features and configurable, manageable capabilities, Oracle DBA salary is generally higher than that of other database administrators. Moreover, Oracle's key applications in large and medium-sized enterprises are more common. Oracle can run under Windows NT, Sun Solaris, Linux and other platforms. In many cases, you are not only familiar with NT, but you have to be familiar with UNIX; and Oracle is not very friendly interface and the contained Oracle product information may also be an obstacle. Oracle 8i Standard Edition offer, if you run in Windows NT, with JServer and Intermediate, support 5 concurrent users, the quote is $ 3925 per CPU. When adding concurrent users, $ 785 per user. Add additional named users, $ 392.5 per user.
Database system noble-IBM UDB / DB2
As the result of 30 years of database research, IBM DB2 is indeed known to the "database system's noble". Whether it is a small commercial system, or a large banking system, with DB2 can be high enough. Recently launched new DB2 6.1, management and adjustment tools are more excellent and easy to use. DB2 can run on the Intel architecture, or on the IBM's S / 390 large computer. If your industry is particularly known to IBM's machine, it is recommended that you learn IBM DB2.
DB2 has two versions: Working Group Edition and Enterprise Edition. Working Group Edition $ 999 per server, plus $ 249 for each concurrency user. The enterprise version is $ 12,500 per CPU, which is not limited to concurrent users.
Database - Sybase Adaptive Server Enterprise (ASE) 12.0 in Java
The upcoming Sybase ASE 12.0, directly facing Java programmers. This kind of Java-centric database system will be the best choice for companies that are preparing to build corporate applications under the Java platform. But ASE is not a leader in a database, although there are many modifications that have been improved relative to it, and support multiple CPUs and more concurrency, there are many new features. But Sybase's scenery seems no longer.
INFORMIX CENTAUR worth looking forward to
Sometimes "first" just means your opponent needs a longer time to catch you. This is the Informix founded in 1997. Informix is one of the large database manufacturers who take the lead in adding multimedia characteristics to the relational database system. But now, IBM, Oracle, Sybase has spanning this concept. Therefore, Informix has to seek new support to distinguish from other database vendors. This is the goal of Informix Centaur. Informix Centaur combines INFORMIX DYNAMIC Server 7.3 Object-Relational Database and Informix Universal Data Option 9.1, which is intended to get better adaptability and multimedia support. For details, we will wait and see! DBA salary
There are many factors that affect you as a salary of DBA:
Your experience and power determined by the DBA level you are familiar with your personal characteristics and potential
