Database Administrator

Work Role ID: 421  |  Workforce Element: Cyber IT

What does this role do? Administers databases and/or data management systems that allow for the storage, query, and utilization of data.

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
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
1034C Knowledge of Personal Health Information (PHI) data security standards. Knowledge
1034B Knowledge of Payment Card Industry (PCI) data security standards. Knowledge
1034A Knowledge of Personally Identifiable Information (PII) 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