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. Below I list some of the dba responsibilities: 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's personal characteristics, the management personnel ignore the individual characteristics of DBA, they only pay attention to DBA's technical ability. 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-confidence curiosity, heroic will, old, self-driving attention, 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.