Before we begin let's first understand what are the roles and responsibility of a DBA are :
1 . Installation, Administration and Maintenance of SQL Server
Instances.
2. Creating logins, users, roles and assign permissions as needed.
3. Create Linked Servers to SQL Servers and other databases.
4. Design database Backup and Restoration Strategy.
5. Check the SQL Error logs for any errors.
6. Check available physical Disk space and capacity planning.
7. Setup High-Availability as part Disaster Recovery Strategy
for the databases.
8. Troubleshoot various problems that arise in a day-to-day
work and fix the issues.
9. Performance Tuning and query tuning.
10. Applying Service packs regularly.
11. Check the Event Viewer regularly.
12. Check job history daily.
13. Perform integrity and optimization check weekly.
14. Perform database health check and security audit every month
15. Set up alerts for your BCA applications.
1 . Installation, Administration and Maintenance of SQL Server
Instances.
2. Creating logins, users, roles and assign permissions as needed.
3. Create Linked Servers to SQL Servers and other databases.
4. Design database Backup and Restoration Strategy.
5. Check the SQL Error logs for any errors.
6. Check available physical Disk space and capacity planning.
7. Setup High-Availability as part Disaster Recovery Strategy
for the databases.
8. Troubleshoot various problems that arise in a day-to-day
work and fix the issues.
9. Performance Tuning and query tuning.
10. Applying Service packs regularly.
11. Check the Event Viewer regularly.
12. Check job history daily.
13. Perform integrity and optimization check weekly.
14. Perform database health check and security audit every month
15. Set up alerts for your BCA applications.
No comments:
Post a Comment