Grow from a junior DBA to a senior DBA [4]

How can IDBAA beginner becomes an intermediateDBA?

 

You have been a dBA for a while. Do you want to improve your technical level to the first level? What should I do next? First, go back to the previous section and check that you have completed all the steps. It is very important to thoroughly understand the SQL language. It is also important to understand the relational database theory and master basic database management tasks. Up to now, you should have read documents and other books. If not, you are not ready to continue your further studies to increase the technical level of your DBA. If you are ready to continue, I have prepared some methods for your further study.

 

Procedure#1:Learn the operating system and your server hardware-As I mentioned earlier, databases exist on the operating system and server hardware. It is necessary to understand how these components work. You should know how to work with a special operating system. How do you delete or edit an object? If your operating system is UNIX, you should master the command line and how Unix Commands help you. The same is true for running Windows or other operating systems. You also need to have a certain understanding of the server hardware. What is the difference between physical memory and virtual memory? What is raid and how different levels have an impact? Why Do databases prefer more physical hard disks than a large hard disk volume? You need to know these things so that you can easily configure your server with the system administrator so that it can fully support database conversations.

 

Procedure#2:Learning application design because it is related to databases-As described above, databases exist between the operating system and database applications. You really need the two. How does the SQL language help create applications? What are variable binding and why are they important? Tom Kyte wrote a very good book and gave good suggestions on Oracle application design. His expert one-on-one Oracle book can be found in wrox press. I strongly recommend reading this book. He describes in detail what can generate and destroy Oracle Applications. You need to know this because your application developers want to get guidance and database knowledge from you. Learn any knowledge related to application design. It may be advantageous to attend a course class on software engineering, operating systems, or data structures.

 

Procedure#4:Certified-Maybe you don't need your job, but obtaining certification is definitely good for you. Every day as a DBA, you have learned many new and exciting things. Maybe you haven't learned anything new for a few days during your career. But you still have a lot to learn. To become an OCP (Oracle certified professional) dBA, you must have learned all the basics of database management. I found that during the course of the OCP examination, I learned something I never touched at work. Once I learned a special topic that I have never encountered, I was able to use that knowledge to solve the problem. If I fail to take the OCP exam, I will never use that special method to solve the problem. This has happened to me again and again. Some may say that authentication is actually not worthwhile. I would like to say that it will only benefit you. So, get the certification!

 

Procedure#5:Obtain a resource library-In the previous section, I pointed out that every DBA should have an account on technet. This is one of your main resources. However, there are many other resources at the same time. Many people share their knowledge about oracle. If you haven't started yet, you should use a web browser to search and collect a lot of Oracle resources. If you want, you can start by visiting my website (http://www.peasland.net. The following lists some websites that Oracle DBAs must know:

Ü ask Tom-http://asktom.oracle.com

Üjonathan Lewis web site-http://www.jlcomp.demon.co.uk/

Ü ixora (Steve Adams)-http://www.ixora.com.au

Ü orapub-http://www.orapub.com

Ü Metalink (Oracle Support site)-http://metalink.oracle.com

 

There are many other good websites.

 

Procedure#6:Start to communicate with different newsgroups and forums-Maybe you have already found them, but if you haven't, it's time to start. There are many news groups and forums that can answer any of your Oracle questions. In the Oracle community, many experts are willing to share their knowledge with you. All you have to do is ask questions. The following is a list of the best internet groups that can start communication:

 

Ü Usenet newsgroups-Comp. Databases. Oracle. server and comp. Databases. Oracle. Misc are two world-renowned news groups that can communicate with each other. They have a large number of exchange files for Oracle problems. The best way to watch these groups is to use broadcasters. However, if you want to use web-based access, you can also search for it using the Google search engine. (Http://groups.google.com/groups? Hl = en & LR = & Ie = UTF-8 & Group = comp. Databases. Oracle)

Ü quest pipelines-The revealnet pipelines was called when they first belonged to the software provider revealnet. Now, quest has purchased revealnet and has pipelines. Pipelines is medium, so these are my favorite. Here you can find pipelines (http://www.quest-pipelines.com/index.asp ).

 

It is a good thing to observe how others are tested and suffering. If you have any questions, you can freely raise them in the group. If you want to ask a question, you should usually include some information, such as your Oracle version and the platform that runs oracle. These will produce a very different answer. If you forget it, someone will remind you! You can even learn a lot from others' answers without asking questions. I can't remember how many times I solved the problem because I remember someone else asked the same question in the newsgroup.