Database Administrator

Database Administrator Work Role ID: 421 (NIST: OM-DA-001) Category/Specialty Area: Operate & Maintain / Data Administration Workforce Element: IT (Cyberspace)

Administers databases and/or data management systems that allow for the storage, query, and utilization of data.


Items denoted by a * are CORE KSATs for every Work Role, while other CORE KSATs vary by Work Role.

Core KSATs

KSAT ID Description KSAT
22

* Knowledge of computer networking concepts and protocols, and network security methodologies.

Knowledge
28

Knowledge of data administration and data standardization policies and standards.

Knowledge
29

Knowledge of data backup, types of backups (e.g., full, incremental), and recovery concepts and tools.

Knowledge
32

Knowledge of database management systems, query languages, table relationships, and views.

Knowledge
104

Knowledge of query languages such as SQL (structured query language).

Knowledge
108

* Knowledge of risk management processes (e.g., methods for assessing and mitigating risk).

Knowledge
208

Skill in maintaining databases.

Skill
213

Skill in optimizing database performance.

Skill
400A

Implement data management standards, requirements, and specifications.

Task
401

Analyze and plan for anticipated changes in data capacity requirements.

Task
664A

Install and configure database management systems and software.

Task
684

Maintain database management systems software.

Task
712

Monitor and maintain databases to ensure optimal performance.

Task
740

Perform backup and recovery of databases to ensure data integrity.

Task
1154

Performs configuration management, problem management, capacity management, and financial management for databases and data management systems.

Task
1157

* Knowledge of national and international laws, regulations, policies, and ethics as they relate to cybersecurity.

Knowledge
1158

* Knowledge of cybersecurity principles.

Knowledge
1159

* Knowledge of cyber threats and vulnerabilities.

Knowledge
6900

* Knowledge of specific operational impacts of cybersecurity lapses.

Knowledge

Additional KSATs

KSAT ID Description KSAT
31

Knowledge of data mining and data warehousing principles.

Knowledge
35

Knowledge of digital rights management.

Knowledge
44

Knowledge of enterprise messaging systems and associated software.

Knowledge
79

Knowledge of network access, identity, and access management (e.g., public key infrastructure [PKI]).

Knowledge
90

Knowledge of operating systems.

Knowledge
98

Knowledge of policy-based and risk adaptive access controls.

Knowledge
120

Knowledge of sources, characteristics, and uses of the organization’s data assets.

Knowledge
137

Knowledge of the characteristics of physical and virtual data storage media.

Knowledge
152

Skill in allocating storage capacity in the design of data management systems.

Skill
166

Skill in conducting queries and developing algorithms to analyze data structures.

Skill
201

Skill in generating queries and reports.

Skill
520A

Implement data mining and data warehousing applications.

Task
688

Maintain directory replication services that enable information to replicate automatically from rear servers to forward units via optimized routing.

Task
690

Maintain information exchanges through publish, subscribe, and alert functions that enable users to send and receive critical information as required.

Task
702

Manage the compilation, cataloging, caching, distribution, and retrieval of data.

Task
815

Provide recommendations on new database technologies and architectures.

Task
910

Knowledge of database theory.

Knowledge
1034A

Knowledge of Personally Identifiable Information (PII) data security standards.

Knowledge
1034B

Knowledge of Payment Card Industry (PCI) data security standards.

Knowledge
1034C

Knowledge of Personal Health Information (PHI) data security standards.

Knowledge
1123A

Knowledge of current and emerging data encryption (e.g., Column and Tablespace Encryption, file and disk encryption) security features in databases, including built-in cryptographic key management features.

Knowledge
1124A

Knowledge of current and emerging data remediation security features in databases.

Knowledge
1128A

Knowledge of database access application programming interfaces (APIs) (e.g., Java Database Connectivity [JDBC]).

Knowledge
1141A

Knowledge of an organization’s information classification program and procedures for information compromise.

Knowledge
1155

Supports incident management, service level management, change management, release management, continuity management, and availability management for databases and data management systems.

Task
2541

Maintain assured message delivery systems.

Task