Database Administrator

Responsibilities of DBA

Following are the responsibilities of Database Administrator (DBA),
  • Installation, configuration and upgradation of databases like Microsoft SQL/ MySQL/ Oracle Server Software.
  • Evaluating the features of various databases.
  • Establishing and maintaining sound backup and recovery policies and procedures.
  • Taking care of database design and implementation.
  • Implementing and maintaining the database security.
  • Database tuning, application tunning and performance monitoring.
  • Maintaining documentation and standards.
  • DBA does some technical trouble shooting and consultation to development teams.
Following skill set is required to be a successful Database Administrator,
  • Problem Management
  • Incident Management
  • Chain Management
  • Capacity Planning

Types of DBA

Following are the types of DBA,
1. Administrative DBA
2. Development DBA
3. Architect
4. Data Warehouse DBA
5. OLAP DBA

1. Administrative DBA
  • Administrative DBA maintains the work on the server and keeps it running.
  • Administrative DBA is mostly concerned with backups, security, replication etc.
2. Development DBA
  • Development DBA builds queries, stored procedures etc. which mostly meet business needs.
  • Development DBA is equivalent to a programmer.
3. Architect
  • Architect builds table, design schema, foreign keys, primary keys etc. which meets the business needs.
4. Data Warehouse DBA
  • Data Warehouse DBA is responsible for merging the data from multiple sources into a data warehouse.
5. OLAP DBA
  • OLAP DBA builds multi-dimensional cubes for decision support or OLAP systems.
  • The primary language in SQL Server is MDX.
▲