Database Reference
In-Depth Information
DBA
Conduct periodic database recovery tests.
DBA
Reorganize files as and when necessary.
DBA
Schedule regular database maintenance.
DBA
Assist analysts and programmers in resolving database-related
application problems.
DBA
As necessary, import external data into the database system or
export data from the database.
DBA/DA
Grant and revoke access privileges as conditions change.
Maintenance of Service Levels
In a database environment, as the number of users increases and the patterns of
data usage change, service levels tend to deteriorate. The database system becomes
sluggish, and database transactions are apt to slow down. The DBA has the prime
responsibility of maintaining and improving service levels.
DBA
Gather statistics to monitor database performance.
DBA
Add indexes and drop indexes based on changes in usage patterns.
DBA
Perform other performance improvement techniques as necessary.
DBA
Revise memory buffering as necessary.
DBA
Verify concurrency control procedures and revise when needed.
DBA
Work with application programmers to tune database access routines in
application programs.
DBA
Recommend and install productivity and efficiency software tools.
Enhancements to Database System
This is a common feature of every database environment. Vendors continue to fix
problems in the current version of the DBMS and also produce new versions with
sustained regularity. The DBA interacts with the database vendor and assumes a
primary role in enhancing the database system.
DBA
Apply software patches and enhancements to existing DBMS version
received from vendor.
DBA
Install version upgrades to DBMS.
DBA
Organize testing of DBMS version upgrades.
DA
Liaise with users to test enhancements to database system.
DBA
Recommend and test infrastructure upgrades and enhancements to
storage system.
Growth and Change
After deployment, the database grows in a few different ways. The data volume con-
tinues to increase as rows are added to the database tables. As business conditions
change additional database tables become necessary. Even in existing tables, the
Search WWH ::
Custom Search