How to say Data Base Environment is a Human Component (OR) explain DBA Managerial role & Technical role ?

Data base system can not operate without the human component.

Effective data administration requires both technical and managerial skills.

DA & DBA direct and control personal staffing and training within their respective departments.

DA also set data administration goals.

Data Sharability & time availability.

Data consistency & integrity.

The DA is responsible for providing a global & comprehensive administrative strategy for all of the organizations data.

Data security & privacy.

Data quality standards.

Extent & type of data use.

DA & DBA activities:

DA
DBA
Strategic planning
 Controls & supervises
sets long–term goals
 Executes plans to reach goals.
 Sets policies & standards
Enforces , policies & procedures
Is broad in scope
Narrow in scope
Focus on long term
Focus on short term
Has a managerial orientation
Has a technical orientation.
Is DBMS – Independent
Is DBMS– specific



dba activities


DBA Activities:

The DBA skills can be divided in to 2 categories.

  1. Managerial
  2. Technical
Managerial
Technical
®Broad business understanding
®Broad data processing back ground
®co-ordination skills
®System development life cycle knowledge
®Analytical skills
®Structured methodologies
  • Data flow diagrams
  • Structure charts
  • Programming languages
®conflict resolution skills
®Data base life cycle knowledge
®communication skills
®Data base modeling & design skills
Conceptual
Logical
Physical
®Negotiation skills
®operational skills.
Database implementation, data dictionary management, security and so on.

DBA Managerial Roles :

®As a manager, DBA must concentrate on the control & planning dimensions of data base administration.

®Coordinating, monitoring and allocating data base administration resources: people and data.

®Defining goals & plans for data base administration function.

DBA Activities & Services :


dba activities


End user support :DBA interacts with the end user by providing information & data because end users have dissimilar computer backgrounds . End ® user support services include:

1. Gathering user requirements : 

The DBA ‘s communication skills are very important at this stage because DBA gathering of user requirements & provide solutions.

2. Building End –user confidence:

Finding solutions to end user’s problems, increase end user trust & confidence in DBA function. The DBA function is provided & how those services enhance also to educate the end user in the services.

3. Resolving conflicts and problems  :

Finding solutions to end users problems in one department might trigger conflicts with other departments.

®When data conflicts arise the DBA function has the authority and responsibility to resolve them.

4. Finding solutions to information needs  :

The ability and authority resolve data , conflicts enables the DBA to develop solutions that will properly fit within the existing data management framework. The DBA’s primary objective is to provide solutions to the end users information needs.

5.Ensuring quality & integrity of data & applications :

once the right solution has been found it must be properly implemented and used. The DBA must also make sure that the data base transactions do not affect the quality of the data.

6. Managing the training and support of DBMA users:

one of the most time consuming DBA activities is teaching end users how to use the data base properly. The DBA coordinates & monitors all activities concerning end user education.

Related

DBMS 6395830869023738094

Post a Comment

emo-but-icon
:noprob:
:smile:
:shy:
:trope:
:sneered:
:happy:
:escort:
:rapt:
:love:
:heart:
:angry:
:hate:
:sad:
:sigh:
:disappointed:
:cry:
:fear:
:surprise:
:unbelieve:
:shit:
:like:
:dislike:
:clap:
:cuff:
:fist:
:ok:
:file:
:link:
:place:
:contact:

item