July 17, 2008 at 4:28 am
Hi,
I would like to know that what is work for Sql server DBA in a project?
Thanks
Sunil Kumar
July 17, 2008 at 6:20 am
I'm not sure if you asking for the role of a SQL Server DBA, but if you are:
The Database Administrator (DBA) who is like the super-user of the system. The role of the DBA is very important and is defined by the following functions.
Defining the Schema
The DBA defines the schema which contains the structure of the data in the application. The DBA determines what data needs to be present in the system ad how this data has to be represented and organized.
Liaising with Users
The DBA needs to interact continuously with the users to understand the data in the system and its use.
Defining Security & Integrity Checks
The DBA finds about the access restrictions to be defined and defines security checks accordingly. Data Integrity checks are also defined by the DBA.
Defining Backup / Recovery Procedures
The DBA also defines procedures for backup and recovery. Defining backup procedures includes specifying what data is to backed up, the periodicity of taking backups and also the medium and storage place for the backup data.
Monitoring Performance
The DBA has to continuously monitor the performance of the queries and take measures to optimize all the queries in the application.
July 17, 2008 at 6:35 am
Thanks for reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply