DBA

How to become an Oracle DBA {3}

by Kevin S
Last week I read and wrote about an article describing what a DBA’s job consists of, and the question arose of how a person might go about becoming a DBA. This week I read the article “How to become an Oracle DBA” by Burleson Consulting. The author starts off by listing the very generous salaries of DBA’s, which often start at around $100k/year and can reach up to $250k/year. While this is appealing, that salary doesn’t come easy. The author talks about the complex and specialized set of skills which are required. The main 3 points he brings up are outstanding communication, business degree, and of course DBA skills. The author also suggests taking courses such as Operations Research and getting Oracle certifications(however he later states in a comment on the article that certifications don’t mean much anymore). read more...

The Forces that Motivate DBAs {1}

by Arlyn R
In the article (2012), “Motivating the DBA,” the author discusses the database administrator’s role and motivations. Lockwood Lyon begins the article by briefly describing the workday of the following IT professionals: programmers, quality assurance analysts, systems analysts, and project managers. According to Lyon, programmers tackle problems during the application development lifecycle and include “…design, coding and testing through implementation and software upgrades (Lyon).” Quality assurance analysts in a typical workday deal with conformance processes, such as programming standards and developing and analyzing test cases. Systems analysts figure out how to have the current technology assets meet the business requirements, along with ensuring the application meets the desired performance. Project managers in the course of a workday manage the resources both technical and human. Also, project managers make sure all requirements are met at each iteration of the project and within budget and by the deadline.
The author then takes an in-depth look at the database administrator’s (DBA) workday. Lyon provides a few examples of the problems DBAs typically face. Examples of these problems include ensuring that applications are following the database standards and information requirements are met. DBA’s play a major role in the design of the database and choosing the right application to meet business requirements and needs. Managing DBMS software support, such as updating to a newer version and implementing vendor software patches, also falls under the DBA’s responsibility. Another example provided by the author in describing the DBA’s role is the 24/7 availability required of the DBA to fix system issues and failures. read more...

DBA, a great position for a CIS major {4}

by Kevin S
The main purpose of a DBA is to perform maintenance and optimization tasks on a daily basis. However, according to Craig Mullins, DBA’s often become much more than that. Because the DBA is often relied upon by both IT and business associates, the realm of what is asked and/or expected constantly grows. A DBA should expect this, and accept it as it makes him/her more valuable to a company while also extending their own personal abilities. Opportunities to grow may include (in addition to the standard DBA duties):  experience with new technologies, a better understanding of the meaning of data, actively participating in application development, or perhaps just a better understanding of business. read more...

A day in the life of a DBA {1}

by Kevin S
Now that we are creating databases, I thought that I would share an article that I found in where a DBA describes a day in his work and some tips on supporting the daily tasks. The article, named “The Case of the Missing Index”, starts off by going through almost humorously through his day as his co-workers ask him to fix an issue with the DB application. He runs through his routine of troubleshooting and eventually finds the culprit which, as you may of guessed, was a missing index file which had been deleted by a co-worker in order to create more room on the hard drive. read more...

Being a DBA {1}

by Abel R
For this week, I found an article on ProQuest titled ” Database Administrator”. This article gives you a good idea on what a database administrator does. DBA’s are responsible for storing, managing, and organizing data. As a DBA you work with software and find ways to do all this. Other tasks that must be performed are to make sure the system performs as it should and plan the system’s security measures. These measures include data integrity, backup, and security which are critical parts of the job. read more...

Being an Effective DBA (Database Admin) {5}

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). read more...

Improving as Database Administrator {Comments Off on Improving as Database Administrator}

by Chris S
The Database Administer has the job of overseeing and maintaining the integrity of a database. Many corporations hire DBAs to make sure that their database receives regular maintenance, quick fixes if any problems arise, and to work with others to make sure any other problems with the database get resolved. One issue with DBAs is utilizing their productivity in a way that can make them more efficient and valuable.  Teams that work with DBAs can work to fix issues but may sometimes fail to find the cause of the problem.  Some common ways in which DBAs are not successful are, read more...

Data warehouse management {Comments Off on Data warehouse management}

by Chris S
Data warehouses are databases that are used for reporting and analysis of data. Therefore, for businesses it is important to maintain a data warehouse that is reliable. Managing a data warehouse is up to the database administrators. Top priority is recovery of data that may be temporarily lost. Data availability is second, as businesses need to be able to access their data whenever necessary. Next, is security because many data warehouses hold crucial information on customers and employees as well as business partners. Making this data secure is big part of administration. Last, performance is important to make sure that the data warehouse provides the data in a timely manner. Almost always data warehouses are the most important part of a business and need to be working efficiently and be secure. Managing data warehouses is an important job and many companies can’t afford to have any issues with their data warehouses. Enterprise data warehouses are harder to manage since they are a lot larger than a typical data warehouse and contain historical data for a business. read more...