Database Administrator

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

Tasks

The concrete work activities defined for this role in the DCWF v5.1 spreadsheet. Core tasks are required for the role; additional tasks are associated but not mandatory.

• T1154 additional Perform configuration management, problem management, capacity management, and financial management for databases and data management systems.
• T1155 additional Support incident management, service level management, change management, release management, continuity management, and availability management for databases and data management systems.
• T401 additional Analyze and plan for anticipated changes in data capacity requirements.
• T520A additional Implement data mining and data warehousing applications.
• T5890 additional Identify data consolidation opportunities across database systems, including data sharing and access between business lines.
• T664A additional Install and configure database management systems and software.
• T684 additional Maintain database management systems software.
• T712 additional Monitor and maintain databases to ensure optimal performance.
• T740 additional Perform backup and recovery of databases to ensure data integrity.
• T815 additional Provide recommendations on new database technologies and architectures.

Knowledge, Skills, and Abilities

KSA statements define what a person filling this role knows or can do. "Knowledge" is what they must know, "Skill" is what they can perform, and "Ability" is a durable capacity they bring to the work.

• K0028 knowledge core Knowledge of data administration and data standardization policies and standards.
• K0029 knowledge core Knowledge of data backup, types of backups (e.g., full, incremental), and recovery concepts and tools.
• K0032 knowledge core Knowledge of database management systems, query languages, table relationships, and views.
• K0079 knowledge core Knowledge of network access, identity, and access management (e.g., public key infrastructure [PKI]).
• K0098 knowledge core Knowledge of policy-based and risk adaptive access controls.
• K0104 knowledge core Knowledge of query languages such as SQL (structured query language).
• K0137 knowledge core Knowledge of the characteristics of physical and virtual data storage media.
• K0910 knowledge core Knowledge of database theory.
• K0952 knowledge core Knowledge of emerging security issues, risks, and vulnerabilities.
• K1123A knowledge core 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.
• K1128A knowledge core Knowledge of database access application programming interfaces (APIs) (e.g., Java Database Connectivity [JDBC]).
• K7029 knowledge core Knowledge of how to collect, store, and monitor data.
• S179B skill core Skill in establishing data security controls.
• S208 skill core Skill in maintaining databases.
• S213 skill core Skill in optimizing database performance.
• K0031 knowledge additional Knowledge of data mining and data warehousing principles.
• K0942 knowledge additional Knowledge of the organization's core business/mission processes.
• K1034A knowledge additional Knowledge of Personally Identifiable Information (PII) data security standards.
• K1034C knowledge additional Knowledge of Personal Health Information (PHI) data security standards.
• K1124A knowledge additional Knowledge of current and emerging data remediation security features in databases.
• K7036 knowledge additional Knowledge of laws, regulations, and policies related to AI, data security/privacy, and use of publicly procured data for government.
• S6945 skill additional Skill in migrating workloads to, from, and among the different cloud computing service models.

EWU courses that develop this role

NCAE CyberGames scoreboard errors for this role

• NCAE-79daa735d3 Postgres Access / failure: An error was encountered while trying to connect to the database
• NCAE-3de767b21e WWW Content / failure: Failed to connect to host
• NCAE-b68a8a7bdc WWW Content / timeout: Timeout
• NCAE-6773086ba2 WWW Content / failure: Website cannot be reached
• NCAE-72b4452011 WWW Content / failure: admin was unable to login
• NCAE-ea7df50c18 WWW Content / failure: [SSL] record layer failure (_ssl.c:1010)
• NCAE-4312daca49 WWW Content / failure: Failed to detect correct content
• NCAE-dccbbf4ea4 WWW Content / failure: admin was not able to request the login page

Other roles in this element