Monday, April 20, 2009

database administration

A database administrator (DBA) is responsible for the environmental aspects of databases. The role of a database administrator is to design database. So DBA also can called a database analyst or database designer.

A DBA perform following duties:
  • Installation of new software
  • Configuration of hardware and software with the system administrator
  • Security administration
  • Data analysis
  • Database design
  • Data modeling and optimization
  • Understanding and implementation of database schemas
  • Ability to interpret and write complex Structured Query Language (SQL) queries
  • Monitor systems for optimum Performance and capacity constraints
  • Establish standards and best practices for SQL
  • Interact with and coach developers in SQL scripting

No comments:

Post a Comment