Database Administrator

Database Administrator Work Role ID: 421 (NIST: OM-DA-001) Workforce Element: IT (Cyberspace)

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


Qualification Matrix

  BasicIntermediateAdvancedNotes
Foundational Qualification OptionsEducation A BS degree in Information Technology, Cybersecurity, Data Science, Information Systems, or Computer Science, from an ABET accredited or CAE designated institution fulfills the educational requirement for this WRCA BS degree in Information Technology, Cybersecurity, Data Science, Information Systems, or Computer Science, from an ABET accredited or CAE designated institution fulfills the educational requirement for this WRCTBDFor additional information pertaining to ABET: www.abet.org or CAE: www.caecommunity.org
Foundational Qualification OptionsOR OR OR
Foundational Qualification OptionsDoD/Military TrainingC-150-2012 or C-150-2011 or F07DZZ1DISA-US1378C-555-2016 (P/L) or C-555-2015 (P/L) or A-150-0929 (P/L) or C-555-0050/ C-555-2014 C See TAB C (DCWF Training Repository) below for additional course information.
Foundational Qualification OptionsCommercial TrainingTBDTBDTBD
Foundational Qualification OptionsOR OR OR
Foundational Qualification OptionsPersonnel CertificationCloud+ or SSCP or Security+ or GSECCASP+ or CCNP Security or CISA or CISSP or CISSP-ISSAP or CISSP-ISSEPSee TAB B (Certification Index) below for certification vendor information. Courses at higher proficiency levels qualify lower levels.
Foundational Qualification AlternativeExperienceConditional AlternativeConditional AlternativeConditional AlternativeRefer to Section 3 of the DoD 8140 Manual for more information.
Residential QualificationOn-the-Job QualificationAlways RequiredAlways RequiredAlways RequiredIndividuals must demonstrate capability to perform their duties in their resident environment.
Residential QualificationEnvironment-Specific RequirementsComponent DiscretionComponent DiscretionComponent Discretion
Annual Maintenance Continuous Professional Development Minimum of 20 hours annually or what is required to maintain certification; whichever is greater.Minimum of 20 hours annually or what is required to maintain certification; whichever is greater.Minimum of 20 hours annually or what is required to maintain certification; whichever is greater.

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
79

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

Knowledge
98

Knowledge of policy-based and risk adaptive access controls.

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
137

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

Knowledge
179B

Skill in establishing data security controls.

Skill
208

Skill in maintaining databases.

Skill
213

Skill in optimizing database performance.

Skill
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
815

Provide recommendations on new database technologies and architectures.

Task
910

Knowledge of database theory.

Knowledge
952

Knowledge of emerging security issues, risks, and vulnerabilities.

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
1128A

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

Knowledge
1154

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

Task
1155

Supports incident management, service level management, change management, release management, continuity management, and availability 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
5890

Identify data consolidation opportunities across database systems, including data sharing and access between business lines.

Task
6900

* Knowledge of specific operational impacts of cybersecurity lapses.

Knowledge
6935

* Knowledge of cloud computing service models Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS).

Knowledge
6938

* Knowledge of cloud computing deployment models in private, public, and hybrid environment and the difference between on-premises and off-premises environments.

Knowledge
7029

Knowledge of how to collect, store, and monitor data.

Knowledge

Additional KSATs

KSAT ID Description KSAT
31

Knowledge of data mining and data warehousing principles.

Knowledge
520A

Implement data mining and data warehousing applications.

Task
942

Knowledge of the organization’s core business/mission processes.

Knowledge
1034A

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

Knowledge
1034C

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

Knowledge
1124A

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

Knowledge
6945

Skill in migrating workloads to, from, and among the different cloud computing service models.

Skill
7036

Knowledge of laws, regulations, and policies related to AI, data security/privacy, and use of publicly procured data for government.

Knowledge