By: Jacomus Beresford
Submitted: 2011-12-23 12:41:03 | Word Count: 870
Database administration and the database administrator (both referred to as DBA) is the job of overseeing the installation, ongoing function and upgrades/changes/modifications made to a database system designed for a number of users. The typical DBA performs a variety of functions and has several responsibilities within the corporate environment. What the DBA does, exactly, will change according to the organization, its size, and the scope of its data storage and retrieval needs.
For the most part, the DBA's basic responsibility is installing new databases and maintaining them at peak operating performance while managing the hardware, software, and network connections that facilitate this. Most DBAs also control access to the database, assigning users access privileges and abilities according to their needs and the database's abilities.
[ advertisement ]
When things go wrong (or could be going wrong), the DBA also oversees troubleshooting, diagnosis, and repair for the database. This includes one of the most important functions of database administration: backups. A competent DBA not only sets up the automated backup systems, but also routinely tests and verifies them to ensure that they are doing a complete job and that the results are recoverable - so if anything happens, the backups are actually useful.
With this comes also the responsibility of maintaining the database as the business grows and the software and hardware change with time. Servers eventually need replacing, software eventually needs upgrading, and business needs often outgrow both with time. So the DBA stays ahead of the game by anticipating needs and budgeting and upgrading accordingly.
When in a meeting with a competent DBA, managers will not only learn about what's happening today or what happened yesterday, but be presented with what is likely to be happening tomorrow, next week, next month, and next year. Most DBAs think ahead in order to forestall problems that could happen. A large part of database administration is anticipating problems and growth so that it does not become a serious issue that was not planned for.
These are the basic roles of the DBA and of administration for a company's data. Most businesses realize the extreme importance that their data has to their overall success and therefore know that getting the most competent DBA available is paramount. Those who do not realize this will be left behind.
Other DBA tasks, often outsourced or hired for temporary need, involve upgrades and installations. While the DBA for the business may be able to maintain the corporate database, that person may not be qualified or have the time and resources necessary to conduct major upgrades or software revisions/customizations. This is often hired out with the DBA acting as the liaison and overseer.
Database analysts and designers may be brought in to conduct these changes while the DBA works closely with them to oversee the project and to learn about how those changes will affect his or her job in administering the database.
Whether all or part of your DBA is outsourced, your company likely benefits greatly from good DBA.
Author Resource:- [About] The DBA Shoppe specializes in remote DBA services for clients with Oracle, DB2 and SQL Server databases. Providing certified Database Administrators for your day to day requirements, the DBA Shoppe saves you time and money. How healthy are your databases? Discover today at http://www.TheDBAShoppe.com
