| Home | A database administrator (DBA) is
responsible for recoverability, integrity, security, availability,
performance, and development and testing support. Recoverability is the
process of creating and testing backups. Integrity is being able to
verify the data. Security is providing data access controls.
Availability is ensuring maximum uptime and performance is ensuring
maximum performance. Development and testing support is helping users to
efficiently utilize the database. A DBA's job depends on the job description, corporate and information technology policies for the organization, and the technical features and capabilities of the database management system (DBMS). Most DBAs are usually responsible for database recovery, performance analysis, data dictionary maintenance, and basic database design. A DBA may have to install new software or updates to the current software. Testing the new software or updates is important for the DBA and other employees. A DBA would also have to assist with the configuration of the hardware and software with the system administrator. The DBA is also responsible for the security of the DBMS including adding and removing users, administering quotas, auditing, and making sure the database remains secure. The DBA must also analyze the data in the database, monitor systems for optimum performance and capacity constraints, and make recommendations on the performance and efficiency of the data. The DBA is also involved in data modeling and database optimization. The DBA should be able to interpret and write complex Structured query language (SQL) queries as well as establish standards and best practices for SQL. The DBA also helps the database design team to eliminate problems with the DBMS. The DBA is responsible for existing databases and analysis, design, and creation of new databases. |
| Overview | |
| History | |
| Microsoft Excel vs. Access | |
| Database Management | |
| Relational Database | |
| Database Administration | |
| Data Security | |
| Data Mining | |
| Metadata | |
| Links | |
Home | Overview | History | Microsoft Excel vs. Access | Database Management | Relational Database | Database Administration | Data Security | Data Mining | Metadata | Links