Database Administrator


Administers databases and/or data management systems that allow for the storage, query, and utilization of data.
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 |