DBA Roles and responsibilities
- similar responsibilities as system administrator, network administrator -responsilble for managing servers
- monitor database health, performance metrix,example performance monitor in windows sql server -sql management studio (Gui based) -backups, recovery. create backup plan, or work with backup IT team -updating databse software, updating new version -installing new applications on the databse -designing database infrastructure (how many sql servers do they need, setup needed for database, replicating database across servers -security of Database ( permissions that need to be applied) -migrating databases to new hardware or between servers -creating reports (requested from different departments, about what is going on with the software, sometimes consists of running sql query that might need help from a database programmer) -create a new database -database upgrade -troubleshooting -work with vendors -work with IT team, relationship with co-workers, for easy communication
-You don’t have to know code. But you should be familiar with some of the basic database language. ie Sql
Source:
https://www.youtube.com/watch?v=0LFa8DH_6f4