| In the Information Technology world there are many | | | | recovery." |
| options to pursue if one is looking for a solid and | | | | Integrity requires DBAs to provide means to protect, |
| trustworthy career. One particular job specifically has | | | | but more importantly, to prevent data giving users from |
| proved being of great interest and is currently in dire | | | | breaking the system's business rules. Security is |
| need of more recruits. This IT job is that of a | | | | obviously just what it implies. And DBAs must tailor |
| "Database Administrator" or for short, a DBA. | | | | what they create to conform to a company's security |
| Database administrators obviously work with | | | | policies in terms of user ability, both in access and |
| databases, specifically database management | | | | changing data. Availability here is just asking DBAs to |
| systems software. The basic requirements of DBAs is | | | | provide accessible means to authorized users to |
| to create databases, maintain them and write | | | | access and change data as necessary for business |
| programs for database administration. | | | | interest. |
| DBA Obligations | | | | Performance from a DBAs point of view is simply a |
| Responsibilities of database administrators differ upon | | | | task of maintaining efficiency in online response times |
| many factors. Depending on one's specific DBA job | | | | and workability between all other aspects tying into the |
| description, the interwoven corporate and IT policies as | | | | database maintenance process. If performance |
| well as the technical issues of Database Management | | | | problems arise, DBAs will examine SQL statements, |
| Systems (or DBMS) one's duties can vary greatly. | | | | table processes and overall system architecture, |
| What is certain, duty wise, is that a few definite and | | | | individually speaking. And lastly, the Development and |
| necessary tasks need to be fulfilled by all DBAs. DBAs | | | | Testing Support aspect for DBAs is a rather less |
| are often required to conduct operations including | | | | important task, one involving the collecting of sample |
| disaster recovery, performance analysis and tuning, | | | | production data for testing new and/or altered |
| data dictionary maintenance and some database | | | | programs, consulting with programmers about overall |
| design. | | | | performance tuning and making certain table design |
| DBA obligations in clear cut form involve safeguarding | | | | modifications as to provide new means of storage for |
| and guaranteeing either a corporation's or | | | | new program functions. |
| organization's functional databases and coinciding | | | | Prerequisite Action |
| applications that reach those databases, making sure | | | | Before actually heading out into the real IT working |
| to monitor both efficiency and functionality. | | | | world as a DBA, one must get their Microsoft |
| 6 Required Tasks | | | | certification, or gain what is referred to as a Microsoft |
| Beyond the above obligations, DBAs are also | | | | Certified Database Administrator certification or |
| responsible for 6 main tasks including issues of | | | | MCDBA for short. This involves going through various |
| recoverability, integrity, security, availability, performance | | | | steps from training, to testing and actual certification |
| and development and testing support. | | | | attainment. It doesn't necessarily come easy, but in the |
| Recoverability here is done as a means to take | | | | long run, to become a successful, accelerated and |
| precautionary action in case of major errors in terms | | | | respected DBA, one must have their MCDBA |
| of data entry, program bugs or overall hardware | | | | certification as validity to one's IT and specific DBA |
| malfunctions. The objective for a DBA in recoverability | | | | skills and capabilities. And once this is had, a DBA |
| terms is to be able to bring back a database in the | | | | position can be acquired and the above responsibilities |
| state it was prior to the malfunction or lose. Rightfully | | | | are then put into effect. |
| so, recoverability is also sometimes called "disaster | | | | |