Being an Effective DBA (Database Admin)

by Jongwoo Y
Database Administrators are one of the most sought after jobs for CIS majors once they graduate. In the article that I chose today, the author sets up a guide on how to become an effective DBA, while also doing a good job with pointing out common problems that are found within DBA’s that tend to not do so well. Many DBA’s do not try to find the major flaw of their databases when they run into a major problem; instead, they go for a quick fix that can cause more problems in the future. It is a good idea to find the major flaws in a database in order to save time and not run into the same problem in the future. Some of the points the author makes is common sense, however, the last thing he advises DBA’s to do is something that is very useful and something that I have never thought of. The author tells the reader that he must log and create tables/indexes/dashboards that chronicle all of the work that they have recently completed (Lyon 2011). Why? In order to show that they are useful for the company and provide proof of how valuable they are to the company. One of the first departments that a company will go to if they try to “trim the fat” from itself is the IT department. Though this isn’t the best decision by the business, it will oft fire valuable employees that are essential for the well being of their business. Other things the author went over were: Unclear problem definition, Making unfounded assumptions, no structured problem-solving process, and stopping with the first good idea (Lyon 2012).

After reading this article, I was able to discover some valuable tips on how to be an effective DBA. Though much of it was common sense and basically told me to be diligent and work hard, the last tip the author provided was eye opening. It basically told DBA’s to make sure and log all of their work in order to be able to show how valuable you are to a company in the case they try to fire you. This type of advice is not only effective to readers in the database field, but can apply to everyone in the work force today. With the economy in shambles, many people are struggling to survive as jobs are becoming a rarity for millions of Americans.

Much of this article is valuable information and related to the classwork that we have been doing the past few weeks due to the fact that a DBA is the preferable career path for anyone that wants to have a future in the field of database. Though a lot of the guide is logical, I can see it being a very helpful refresher for DBA’s that are starting to feel as if they are not putting enough effort and work into their job. Another thing to note is that many of the points that are specified throughout this article are not only effective in the workplace environment, but can be applied to our class as well.

Lockwood, L. (2011, November 18).databasejournal.com. Retrieved from http://www.databasejournal.com/features/improving-dba-productivity.html

 

5 thoughts on “Being an Effective DBA (Database Admin)”

  1. These tips are very effective. I believe that becoming a DBA will be very difficult in the sense that this professions needs a lot of attention to detail because something is incorrect, then we are going to get fired from the job. It was like last week with the T-Mobile databases getting compromised. If the data being managed by a DBA is useful or efficient or worthy, then we may be out of the job.

  2. I'm going to have to agree with you, keeping a log of what you do never crossed my mind. It would be a good way to show that you are more valuable than they think, and also a good way to show how productive you are. I would think being a DBA would be a job that constantly needs your attention, since problem can arise frequently, and if we look bad they can always seek a replacement with more experience. The job market is tough at the moment, people with lots of experience will take jobs that new graduates would take.

  3. It seem like these are common sense, where people should look at the big picture then the multiple mini problem. I do agree that DBA need play attention for every small thing in the database.

  4. Great article, I was able to get get a lot of useful information from your blog. Regarding the idea to keep a log of what you do, great idea. It reminds me of the show "deadliest catch", captain Sig, always reviews his notes from previous years before deciding on where to fish. The job market is going to be pretty tough which is why we should be more diligent in preparing ourselves. Being a DBA will definitely be a high paying job.

  5. Personally I am going into networking rather then database administration. But I do have lots of respect for database administrators as I know many of them and am aware of the complexity of their job sometimes. Many of the ideas are also network administrators have to be mindful of such as documentation. Effective tips, thanks for the post.

Comments are closed.