Define DBA. Discuss role of DBA.

-

Solution:-

  • Database Administrator(DBA):-

  1. A database administrator, database analyst or database developer is the person responsible for managing the information within an organization.
  2. As most companies continue to experience inevitable growth of their database,these positions are probably the most solid within the IT Industry.
  3. The DBA has most probably responsibility but the overall goal of the DBA is to keep the server up at all times and to provide users with access to the required information when they need it.
  4. The DBA makes sure that the database is protected and that the any chance od data loss is minimized.
  5. the DBA can be a system administrator who was given the added responsibility of maintaining SQL server.
  6. DBA can even come from unrelated fields,such as accounting or the help desk,and switch to information systems to become DBA'S.
  • DBA Responsibility:-
1. Installing and upgrading SQL server:-
a. The DBA is responsible for installing SQL servers or upgrading an existing SQL server.
b. The DBA is also responsible for applying SQL service packs.
 2. Monitoring the database servers health and tunning accordingly:-
a. monitoring the health means making sure the server is running with optimal performance.
b. making sure the error log or event log is monitored for database errors. 
3. Using storage properly:-
            SQL server 2000 enables you to automatically grow the size of your database and transaction logs, or you can choose to select a fixed size for the database and transaction log 
4. Performing backup and Recovery Duties:-
a. Establishing and recovery is the most critical task of DBA's.
b. Establishing standards and schedules for database backups.
c. Developing recovery procedures for each database.
5. Managing database users and security:-
            with SQL server 2000, the DBA works tightly with the windows NT administrator to add users NT logins to the database. In non-NT domains, the DBA add user login.
6.  working with Developers:- 
            It is important for the DBA to work closely with development teams to assist in overall database design, such as creating normalized database,helping developers tune queries, assigning proper indexes, and aiding developers in the creation of triggers and stored procedures.
7. Establishing and Enforcing Standards:-
           The DBA should establish naming conventions and standards for the SQL server and databases and make sure that everyone sticks to them.
8. Transferring Data:-
            The DBA is responsible for importing and exporting data to and from the SQL server. In the current trend to downsize and combine client/server systems with mainframe systems with mainframe systems and web technologies to create Enterprise systems, importing data from the mainframe to SQL server is a common occurrence that is about to become more common with the SQL server 2000 Data Transformation services. 
9. Replicating Data:-
             SQL server version 2000 has many different replication capabilities such as Merge replication and Queued replication. 
10. Data Warehousing:-
              Data warehousing provides new and interesting challenges to the DBA and in some companies a new career as a warehouse specialist. 
11. Scheduling Events:-
               The database administrator is responsible for setting up and scheduling various events using windows NT and SQL server to aid in performing many tasks such as backups and replication.  
12. Providing 24 hrs Access:-
                The database server must stay up, protected and online. be prepared to perform some maintenance and upgrade after hour.Also be prepared to carry out that dreaded beeper.If the database server should go down, be ready to server up and running.after all thats your job.
13. Learning Constantly:- 
                To be a good DBA, you must continue to study and practice your mission-critical procedures, such as testing your backups by recovering to a test database.

 

NOTE:  Explain any 6 roles or 8 roles and remaining you can list down no need to explain.

Comments

Post a Comment

Popular posts from this blog

What is the process and project matrics? Explain 3 P's in software engineering.

-
Solution:-  a) Process Metrics These are the metrics pertaining to the Process Quality. They measure efficiency and effectiveness of various processes. b) Project Metrics These are the metrics pertaining to the Project Quality. They measure defects, cost, schedule, productivity and estimation of various project resources and deliverables.found in acceptance)/ total no of testing defects) x 100 THE THREE Ps:- The People • People factor is very much important in the process of software development. • There are following areas for software people like, recruiting, selection performance management, training, compensation, career development, organization and work design, and team/culture development. • Organizations achieve high levels of maturity in the people management area. The Product • Before a project can be planned, product objectives and scope should be established, alternative solutions should be considered and technical and management constraints should be identified. • With...
Read more

Explain general format of Software Requirement Specification (SRS).

-
 Solution:- Software requirements specification (SRS) is a document that is created when a detailed description of all aspects of the software to be built must be specified before the project is to commence.  It is important to note that a formal SRS is not always written. In fact, there are many instances in which effort expended on an SRS might be better spent in other software engineering activities.  However, when software is to be developed by a third party, when a lack of specification would create severe business issues, or when a system is extremely complex or business critical, an SRS may be justified.  Karl Wiegers has developed a worthwhile template that can serve as a guideline for those who must create a complete SRS.  A topic outline follows: 1. Introduction 1.1. Purpose1.2. Document Conventions 1.3. Intended Audience and Reading Suggestions 1.4. Project Scope 1.5. References 2. Overall Description 2.1 Product Perspective 2.2 Product Features 2.3 U...
Read more

Difference between IPv4 and IPv6.

-
                               IPv4                                   IPv6 1. Source and Destination addresses are 32 bits in length. 1. Source and Destination addresses are 128 bits in length. 2. IPv4 addresses are binary numbers represented in decimals. 2. IPv6 addresses are binary numbers represented in hexadecimals. 3. IPsec supports in optional. 3. IPsec is inbuilt. 4. Security is dependent on application. 4. IPsec is inbuilt in IPv6 protocol. 5. No packet flow identification. 5. Packet flow identification is available within the IPv6 header using flow label field. 6. Header includes a checksum. 6. Header does not include a checksum. 7. Encryption and Aut...
Read more