Database Administrator Assistant Duties
The Database Administrator is responsible for the installation
and setup of the database
management system (DBMS), establishing security and access
control procedures, performing
ongoing administrative functions, and ensuring business
continuity and disaster recovery plans
are in place for the organization's databases. The work of a
database administrator will vary
according to the nature of the employing organization and the
level of responsibility associated
with the post.
DUTIES AND RESPONSIBILITIES
Perform initial software installation, setup and testing.
Perform daily operations of managing DBMS.
Develop and implement security controls and access protocols.
Monitor and evaluate operating efficiency and tune performance
Maintain software, including testing, evaluation and
installation of new versions.
Perform software patching and keep systems in compliance with
Troubleshoot hardware/software problems and system failures.
Determine and initiate appropriate and immediate actions needed
to restore normal services with minimal down time.
Investigate recurring and related failures/inefficiencies by
reviewing system logs, dumps
and other information from clients or technical personnel.
Identify trends and source of problem(s), and recommend/initiate
Manage capacity and systems resource allocation.
Perform long-range and capacity-planning studies to determine
the type of resources needed
to support expected volume, types of application systems and
Monitor DBMS backup procedures and execute recovery operations
Devise and deploy disaster recovery and archiving procedures.
Provide consultation for development staff regarding application
design and integration.
Prepare documentation of systems and software for permanent
Advise and train clients regarding DBMS.
Perform additional duties as assigned.