IO-WRL-002
Database Administration OPM Code: 421

Provides implementation, administration, configuration, operation, and maintenance to ensure effective and efficient technology system performance and security.

Responsible for administering databases and data management systems that allow for the secure storage, query, protection, and utilization of data.

Code Description Work Roles
T0137 Maintain database management systems software 1
T0330 Maintain assured message delivery systems 1
T0422 Implement data management standards, requirements, and specifications 1
T0459 Implement data mining and data warehousing applications 1
T1020 Determine the operational and safety impacts of cybersecurity lapses 37
T1065 Determine data capacity requirements 3
T1066 Plan for anticipated changes in data capacity requirements 2
T1230 Maintain directory replication services 1
T1231 Maintain information exchanges through publish, subscribe, and alert functions 1
T1249 Perform backup and recovery of databases 1
T1297 Recommend new database technologies and architectures 2
T1402 Manage databases and data management systems 1
T1564 Install database management systems and software 1
T1565 Configure database management systems and software 1
Code Description Work Roles
K0674 Knowledge of computer networking protocols 40
K0675 Knowledge of risk management processes 41
K0676 Knowledge of cybersecurity laws and regulations 41
K0677 Knowledge of cybersecurity policies and procedures 41
K0678 Knowledge of privacy laws and regulations 41
K0679 Knowledge of privacy policies and procedures 41
K0680 Knowledge of cybersecurity principles and practices 40
K0681 Knowledge of privacy principles and practices 40
K0682 Knowledge of cybersecurity threats 40
K0683 Knowledge of cybersecurity vulnerabilities 40
K0684 Knowledge of cybersecurity threat characteristics 40
K0685 Knowledge of access control principles and practices 21
K0686 Knowledge of authentication and authorization tools and techniques 21
K0698 Knowledge of cryptographic key management principles and practices 10
K0699 Knowledge of data administration policies and procedures 2
K0700 Knowledge of data standardization policies and procedures 2
K0701 Knowledge of data backup and recovery policies and procedures 8
K0702 Knowledge of data warehousing principles and practices 3
K0703 Knowledge of data mining principles and practices 4
K0704 Knowledge of database management system (DBMS) principles and practices 2
K0705 Knowledge of database query language capabilities and applications 2
K0706 Knowledge of database schema capabilities and applications 2
K0707 Knowledge of database systems and software 9
K0708 Knowledge of digital rights management (DRM) tools and techniques 2
K0716 Knowledge of host access control (HAC) systems and software 10
K0717 Knowledge of network access control (NAC) systems and software 10
K0742 Knowledge of identity and access management (IAM) principles and practices 10
K0744 Knowledge of operating system (OS) systems and software 16
K0746 Knowledge of policy-based access controls 15
K0747 Knowledge of Risk Adaptive (Adaptable) Access Controls (RAdAC) 15
K0750 Knowledge of query languages 2
K0751 Knowledge of system threats 40
K0752 Knowledge of system vulnerabilities 40
K0759 Knowledge of client and server architecture 16
K0766 Knowledge of data asset management principles and practices 5
K0777 Knowledge of data storage media characteristics 1
K0859 Knowledge of encryption tools and techniques 13
K0862 Knowledge of data remediation tools and techniques 3
K0865 Knowledge of data classification standards and best practices 18
K0866 Knowledge of data classification tools and techniques 18
K0867 Knowledge of database application programming interfaces (APIs) 2
K0874 Knowledge of key management service (KMS) principles and practices 3
K0875 Knowledge of symmetric encryption principles and practices 3
K0876 Knowledge of key management service (KMS) key rotation policies and procedures 3
K0917 Knowledge of Personally Identifiable Information (PII) data security standards and best practices 15
K0918 Knowledge of Payment Card Industry (PCI) data security standards and best practices 16
K0919 Knowledge of Personal Health Information (PHI) data security standards and best practices 16
K0934 Knowledge of data classification policies and procedures 18
K0942 Knowledge of cryptology principles and practices 10
K0983 Knowledge of computer networking principles and practices 39
K0991 Knowledge of database administration principles and practices 3
K0992 Knowledge of database maintenance principles and practices 3
K1014 Knowledge of network security principles and practices 40
K1114 Knowledge of capacity management 1
K1121 Knowledge of configuration management 1
K1147 Knowledge of data integrity principles and practices 3
K1161 Knowledge of financial management 1
Code Description Work Roles
S0045 Skill in optimizing database performance 2
S0545 Skill in designing data storage solutions 1
S0546 Skill in implementing data storage solutions 1
S0558 Skill in developing algorithms 5
S0559 Skill in performing data structure analysis 5
S0579 Skill in preparing reports 11
S0586 Skill in administering databases 3
S0728 Skill in preparing briefings 6
S0791 Skill in presenting to an audience 9
S0819 Skill in caching data 2
S0820 Skill in cataloging data 2
S0828 Skill in compiling data 2
S0835 Skill in distributing data 2
S0897 Skill in retrieving data 2