Database Administrator

• 401Analyze and plan for anticipated changes in data capacity requirements.Core
• 520AImplement data mining and data warehousing applications.Additional
• 664AInstall and configure database management systems and software.Core
• 684Maintain database management systems software.Core
• 712Monitor and maintain databases to ensure optimal performance.Core
• 740Perform backup and recovery of databases to ensure data integrity.Core
• 815Provide recommendations on new database technologies and architectures.Core
• 1154Perform configuration management, problem management, capacity management, and financial management for databases and data management systems.Core
• 1155Support incident management, service level management, change management, release management, continuity management, and availability management for databases and data management systems.Core
• 5890Identify data consolidation opportunities across database systems, including data sharing and access between business lines.Core

• 22* Knowledge of computer networking concepts and protocols, and network security methodologies.Core
• 28Knowledge of data administration and data standardization policies and standards.Core
• 29Knowledge of data backup, types of backups (e.g., full, incremental), and recovery concepts and tools.Core
• 31Knowledge of data mining and data warehousing principles.Additional
• 32Knowledge of database management systems, query languages, table relationships, and views.Core
• 79Knowledge of network access, identity, and access management (e.g., public key infrastructure [PKI]).Core
• 98Knowledge of policy-based and risk adaptive access controls.Core
• 104Knowledge of query languages such as SQL (structured query language).Core
• 108* Knowledge of risk management processes (e.g., methods for assessing and mitigating risk).Core
• 137Knowledge of the characteristics of physical and virtual data storage media.Core
• 910Knowledge of database theory.Core
• 942Knowledge of the organization's core business/mission processes.Additional
• 952Knowledge of emerging security issues, risks, and vulnerabilities.Core
• 1034AKnowledge of Personally Identifiable Information (PII) data security standards.Additional
• 1034CKnowledge of Personal Health Information (PHI) data security standards.Additional
• 1123AKnowledge 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.Core
• 1124AKnowledge of current and emerging data remediation security features in databases.Additional
• 1128AKnowledge of database access application programming interfaces (APIs) (e.g., Java Database Connectivity [JDBC]).Core
• 1157* Knowledge of national and international laws, regulations, policies, and ethics as they relate to cybersecurity.Core
• 1158* Knowledge of cybersecurity principles.Core
• 1159* Knowledge of cyber threats and vulnerabilities.Core
• 6900* Knowledge of specific operational impacts of cybersecurity lapses.Core
• 6935* Knowledge of cloud computing service models Software as Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS).Core
• 6938* Knowledge of cloud computing deployment models in private, public, and hybrid environment and the difference between on-premises and off-premises environments.Core
• 7029Knowledge of how to collect, store, and monitor data.Core
• 7036Knowledge of laws, regulations, and policies related to AI, data security/privacy, and use of publicly procured data for government.Additional
• 7111* Knowledge of Zero Trust Security Model Principles.Core

• 179BSkill in establishing data security controls.Core
• 208Skill in maintaining databases.Core
• 213Skill in optimizing database performance.Core
• 6945Skill in migrating workloads to, from, and among the different cloud computing service models.Additional

The DCWF Tool lists no abilities for this work role.