MCITP Database Administrator job role involves designing and developing logical data models, create physical databases and create data services by using Transact-SQL. They manage, monitor and optimize databases. Administrators also play an important role in the installation and configuration of SQL Server.
Database administrators have to maintain SQL Server instances and manage SQL Server security. Database Administrators monitor and resolve any issues related to SQL Server. They further assist in developing solutions relating to SQL Server instances and databases. They must also successfully implement high-availability database solutions.
Administrators also must monitor security issues and respond to threats. They must have strong knowledge of data archiving, consolidation, distribution and recovery techniques. Administrators must understand the importance of capacity analysis and be able to focus on its design. It is their responsibility to design security measures for database systems using Microsoft SQL Server.
Read more: database administrator job description
