Database Administrator

Responsibilities of 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.

• Problem Management
• Incident Management
• Chain Management
• Capacity Planning

Types of DBA

• Administrative DBA maintains the work on the server and keeps it running.
• Administrative DBA is mostly concerned with backups, security, replication etc.

• Development DBA builds queries, stored procedures etc. which mostly meet business needs.
• Development DBA is equivalent to a programmer.

• Architect builds table, design schema, foreign keys, primary keys etc. which meets the business needs.

• Data Warehouse DBA is responsible for merging the data from multiple sources into a data warehouse.

• OLAP DBA builds multi-dimensional cubes for decision support or OLAP systems.
• The primary language in SQL Server is MDX.