Survey, collected over a software engineer, network security engineers, database administrators, project managers and other IT technologies are data showing the Guangzhou-Shenzhen and other cities north and technical personnel career picture.
database administrator, English is the Database Administrator, referred to as the DBA. Data Manager is responsible for the management and maintenance of a database server people.
DBA is a free moment to work, or complex and important task to be the effort? The DBA as a possible career choice because what is it? How do DBA should not be engaged in this occupation? China's IT lab will lead you to uncover the mystery of DBA.
DBA is definitely not a leisure work.
is to understand the more hesitant off, man can not have all the skills or time to do all the things to do. As a DBA, your job is with the programmers, network administrators, and even end users to work together. For example, SQL programmers to provide their needs about the network hardware and SQL Server constraints the practical information, relying on the network administrator issues affecting SQL Server for network-related problems that may be for the proper training of end users do provide some assurance, and is responsible for the current SQL Server application software to end users for feedback. If you work in a small organization, you will find who often wear many hats, no one would say that this is an easy job. , will all the time day or night received a call to solve their database for the deadly problems. 24x7 hours of maintenance of the database application, but if only a few, or only a DBA it?
deer smile, said his duties include the patch for the software or make some changes to the database, but these actions do not work when the staff in the company, because the database must be running at this time to enable them to work. five job, then, DBA is not your best choice.
then, the difficulties become a DBA what reason?
some people have to be a good DBA needed talent, and some people do not believe that the secret of a DBA can easily grasp. DBA professional need to master certain skills, but also other IT professional requirements are not necessary.
noted, in addition to Chongqing is more than a thousand, the Beijing and Shanghai are more than three thousand, the highest in Shenzhen thousand. than when the network manager to cost much. He has no grasp of their own strength, that DBA the necessary skills?
JOHN blinked, put up a few fingers out one by one: to install and upgrade the database server (such as Oracle, Microsoft SQL server), and application tools. Database design system, storage solutions, and to develop future storage requirements planning. Once the design of an application developer, you need DBA to create the database storage structures (tablespaces). Once the design of an application developer, you need DBA to create the database objects (tables, views, indexes). According to developer feedback, when necessary, modify the database structure. The user registration database, maintain database security. To monitor the database instance as a day of work will be done to ensure its availability. RDBMS software upgrade and patching when necessary. Necessary to upgrade or migrate the database instance. Ensure that the database used in compliance with intellectual property laws. Control and monitor user access to the database access. Analysis and management of database security. Control and monitor user access to the database. When necessary, the use of the audit database. Monitor and optimize database performance. Through analysis and evaluation of database performance, adjust the server operating system parameters, database parameters,UGGs, network performance, applications such as SQL statements to optimize database performance, ensure that the database is running in the best condition. Development of the database backup plan, disaster appears to restore the database information. Maintain appropriate media archive or backup data. Monitor the backup process. Restored when necessary. Test backup and recovery procedures. Follow the trends and technology database. When can be applied to the use of new technologies. Installation, testing and evaluation of new Oracle related products. Contact the manufacturer of the database system to track technical information.
whether to hire one or more DBA. Database beta or evaluation version to practice using the database, vandalism database and try to fix it,UGG boots, try to carry as much as possible he could think of DBA responsibilities, test and hone their skills on the test platform to prove his database management capabilities.
addition to high wages, others want to be like to commend the DBA DBA because of the honor received, or because he looks cool!
90 early in the IT industry, DBA changes was scarce. If you want to be a DBA, it is easy, very easy. You need to do is prove you know what a database and then work will be earlier than you expected in front of you. However, enter the new millennium, job seekers face more stringent requirements, if not experience, get your first job is very difficult DBA. Not many companies would make a high salary without any experience of the DBA to the operation, maintenance and operation of IT based organization's largest and most important part.
At this point, Luo Fei is lucky.
been spotted before the career direction, to become DBA, will be the co-existence as a challenge to work with fun. technical staff in short supply. log files, backup situation, the database space usage, the system checks the use of resources, identify and solve problems. timely expansion of the space database objects and data to monitor the growth of the database to do health checks on the database objects state check-ups on the tables and indexes, etc. Analyze, check the table of space debris, looking for opportunities for performance tuning the database, the database performance tuning, space management plan proposed by the next step on the ORACLE database state to conduct a comprehensive examination. br> So if there are appropriate Luo Fei ability to solve problems? Luo Feicheng deny him the relevant application experience before graduation, participation is limited to the campus network security management, Language, HTML / CSS, JavaScript, Shell, PERL, PHP, C / C + +, etc., with good English skills in reading, communication skills, internships during the senior guidance, to the database installation, database configuration and management, permissions and security management ,UGG shoes, monitoring and performance tuning, data backup and recovery, to solve common technical issues, knowledge of system architecture and database design, and the database can be optimized at various levels; monitoring database alert log, the regular backup deleted. in Shenzhen After the probationary period by one month, the boss was satisfied with my performance, I am familiar with GNU / Linux, FreeBSD, MS Windows and other operating systems management and development environment, familiar with the development, research and project management processes, also recently raised wages. , DBA will work in teams to maximize. Los
contrast, however the strength and opportunities to fly, join the BEN has been five years does not encourage blind people into the DBA IT industry, he calmly said, found in the DBA career full of frustration and headache. does not necessarily need to know the knowledge of all relevant operating systems, but he knew better. Database and operating system very closely linked, to understand this association is necessary. DBA also needs to know the server hardware and how it affects and help database. Meanwhile, DBA must understand the application software, DBA may be required to help developers create reliable, robust database applications. understanding of the database engine, which is how it works, all the engines are combined together, and how it affects the end-user database engine and application to transfer data. the best I've ever seen not only on the database itself DBA have a very deep understanding, they know that some system management and application development, many times before they become a DBA has one or two of background, however, instead of becoming a qualified DBA also needs a lot of good background knowledge.
DBA level is not very strict. Grasp the situation according to the database, simply divided into three levels: primary Primary, Intermediate and Advanced Intermediate Senior.
primary DBA is also known as DBBS, is the abbreviation of the English Database Baby Sitter. Junior DBA is often part-time, they often also a part-time programmer or other work.
BEN initially a part-time programmers DBBS, only some of surveillance work. Third-party software vendors have installed and configured the database, he needs to deal with some simple question, >
However, the operation and operation of the project is often the project managers and programmers, and other outside personnel. Therefore, once the success of the project, is often valued by the people who are outside the project, and the database administrator is less been mentioned.
In his view, the project managers are mostly promoted by the database administrator for a step up, and the future application of the database more widely, particularly in the telecommunications industry, its operations require huge database of support, at least in the near years, a good database administrator or promising.
into two main formal DBA certification, 1.OCP DBA ORACLE Corporation is one of the promulgation and implementation of the authority of the professional and technical standards, the most popular is the Oracle 10G training, access to the certificate need three certification exams. It is understood that OCP IT Lab digital Wang Xiao launch remote training, if there is plenty of time, users can also choose to still-face view of OCP oracle university training.
2.MCDBA series is a Microsoft Certified Professional certification is extremely important, one can prove that the holder has a higher level of expertise, you can carry around the Microsoft SQLServer database system implementation and management. IT Laboratory
China is planning to obtain a certificate Hai friends, longing to find a highly paid DBA-workers, but the senior counsel him, How to manage a database, it is only possible after the boss to tell you, now you have a certain amount of technology and the attitude of your DBA work is very serious. Do not rely on authentication to get you the job itself. Although there are few level certificate, but not very valued, training, quality of service they have good and bad, so the certificate is not particularly meaningful. stability, security, the pursuit is basically not very high, often with the senior DBA to do some routine work, several databases of books, and in-depth study, now the senior DBA as a target. , Oracle Press. Every Oracle DBA should be in his early career to read this book in your test database in the SQL statements of different exercises until they become your habits. Reference Oracle 9i (Oracle 9i SQL Reference manual) is another very important source of knowledge, . Oracle 9i Concepts Guide, the Oracle 9i Administrator's Guide, and the Oracle 9i Backup and Recovery Guide) come from the Oracle documentation. Other publishers, such as Wrox Press and O'Reilly Press, there are many sites and news groups. to read as much as possible so that you can head in the DBA to continue on this road.
Shao-ping explained , Senior DBA in the country is very small, they tend to buy too many databases of information in English, are generally familiar with a variety of operating platforms of several large databases, and weaknesses, and to the database platform and database environment choices to make decisions, they are generally familiar with system architecture and database design, and can be various levels of optimization of the database. Senior DBA are generally equipped with Assistant, they are more Pianxiang do decision-making and planning, I am trying to learn, learn from the older generation who, for within five years as Senior DBA. Senior DBA is usually seen as the solution of complex Oracle as a problem. You will need all of your technology to solve many problems, these techniques are your career accumulated.
previously found that the system performance bottleneck. For example, DBA should know that the database will run out of disk space available before the pre more disk space, do not pay close attention to carrying capacity plan will lead to the production database is down.
Advanced DBA is often in the banking, insurance, online trading on the stability, security, performance, require a relatively high critical business processing flourish. a good database administrator wages greater than 5000, Shao-ping when he's looking forward to million salary to annual salary.
how to become a good DBA?
not you get a certificate, were well prepared, it means you have to be a good DBA of qualified it? sky passed the Oracle 9i, critical applications in large and medium enterprises are becoming more common. Oracle can run on Windows NT, Sun Solaris, Linux and other platforms. many cases require you to not only familiar with NT, but also you are familiar with Unix, if you did not come into contact with Oracle, it is not a friendly interface and Oracle products, boxes of information may be a barrier. dealing with various personnel, such personnel may be vendors, users, developers or managers, as a DBA, in addition to master the perfect database technology, but also must have its own personality.
high morale and strong self-confidence, unlike the work of junior DBA lack of initiative, not under even the smallest decisions, as a DBA does not know the most deadly is not the answer, but do not know where to get an answer. subtle differences in functionality and performance and enhanced, thus improving their work. br> Blue Sky has a tenacity of will, not easily yield to compromise, DBA often encounter difficult problems, not only at work, still in interpersonal relationships, good only in your department's fire ignited hostility. DBA to be able to think of ways to make the problem appear, rather than waiting for problems. In many cases, developers, managers, users, they will make unreasonable demands We need seasoned DBA guide, to revise their request, to convince them. in-depth understanding of the database kernel, and can understand the view of the relationship between the tables. the database backup strategy should change according to actual requirements,Discount UGG boots, daily backup of data to monitor the situation. Regular users of administrator passwords and other important changes. For each project, should create a user, DBA should project managers and the corresponding or a programmer to communicate to establish the appropriate database to determine how the underlying model, and finally unified management by the DBA to establish and maintain.
or the appropriate staff to write the appropriate SQL statement, should be strictly in accordance with the should also be committed to the database of the deeper level of management and research: optimization of the database itself, developing the performance optimization; project rationalization; security of audit work; the underlying database modeling, planning and design; a variety of data type of treatment; internal mechanism; ora-600 errors of, troubleshooting, and so many issues worth exploring. , but upholds a kind of open-minded attitude to help him find work in the busy balance, not to be depressed against the actual work, was curious to ask what is secret, blue sky yo read aloud:
He strongly by his strong, cool breeze brush hill. He let him cross cross, the moon shines on the river.
no reason you feel it? your inspiration from many different people as to what kind of sentiment, in order to establish their own goals?
No comments:
Post a Comment