An SQL Server DBA is a database administrator who is an expert in Microsoft's Structured Query Language (SQL) Server. They utilize software designed to track and store large amounts of personal and financial data and organize and analyze that data using the SQL Server platform.
Creating and maintaining database standards and policies.
Supporting database design, creation, and testing activities.
Managing the database availability and performance, including incident and problem management
Administering database objects to achieve optimum utilization
Defining and implementing event triggers that will alert on potential database performance or integrity issues
Performing database housekeeping, such as tuning, indexing etc
Monitoring usage, transaction volumes, response times, concurrency levels etc
Identifying, reporting, and managing database security issues, audit trails, and forensics
Designing database backup, archiving, storage strategy and restoration.
45LWhXyPzXyBMGOPnwgXRJ45