OM-DTA-001 Database Administrator
Provides the support, administration, and maintenance necessary to ensure effective and efficient information technology (IT) system performance and security.
Develops and administers databases and/or data management systems that allow for the storage, query, protection, and utilization of data.
Administers databases and/or data management systems that allow for the secure storage, query, protection, and utilization of data.
Knowledges 26
| Code | Description | Work Roles |
|---|---|---|
| K0001 | Knowledge of computer networking concepts and protocols, and network security methodologies. | 52 |
| K0002 | Knowledge of risk management processes (e.g., methods for assessing and mitigating risk). | 52 |
| K0003 | Knowledge of laws, regulations, policies, and ethics as they relate to cybersecurity and privacy. | 52 |
| K0004 | Knowledge of cybersecurity and privacy principles. | 52 |
| K0005 | Knowledge of cyber threats and vulnerabilities. | 52 |
| K0006 | Knowledge of specific operational impacts of cybersecurity lapses. | 52 |
| K0020 | Knowledge of data administration and data standardization policies. | 2 |
| K0021 | Knowledge of data backup and recovery. | 9 |
| K0022 | Knowledge of data mining and data warehousing principles. | 2 |
| K0023 | Knowledge of database management systems, query languages, table relationships, and views. | 2 |
| K0025 | Knowledge of digital rights management. | 2 |
| K0031 | Knowledge of enterprise messaging systems and associated software. | 2 |
| K0056 | Knowledge of network access, identity, and access management (e.g., public key infrastructure, Oauth, OpenID, SAML, SPML). | 11 |
| K0060 | Knowledge of operating systems. | 13 |
| K0065 | Knowledge of policy-based and risk adaptive access controls. | 5 |
| K0069 | Knowledge of query languages such as SQL (structured query language). | 2 |
| K0083 | Knowledge of sources, characteristics, and uses of the organization’s data assets. | 2 |
| K0097 | Knowledge of the characteristics of physical and virtual data storage media. | 1 |
| K0197 | Knowledge of database access application programming interfaces (e.g., Java Database Connectivity [JDBC]). | 2 |
| K0260 | Knowledge of Personally Identifiable Information (PII) data security standards. | 16 |
| K0261 | Knowledge of Payment Card Industry (PCI) data security standards. | 17 |
| K0262 | Knowledge of Personal Health Information (PHI) data security standards. | 17 |
| K0277 | Knowledge of current and emerging data encryption (e.g., Column and Tablespace Encryption, file and disk encryption) security features in databases (e.g. built-in cryptographic key management features). | 2 |
| K0278 | Knowledge of current and emerging data remediation security features in databases. | 1 |
| K0287 | Knowledge of an organization's information classification program and procedures for information compromise. | 18 |
| K0420 | Knowledge of database theory. | 4 |
Skills 5
| Code | Description | Work Roles |
|---|---|---|
| S0002 | Skill in allocating storage capacity in the design of data management systems. | 1 |
| S0013 | Skill in conducting queries and developing algorithms to analyze data structures. | 2 |
| S0037 | Skill in generating queries and reports. | 2 |
| S0042 | Skill in maintaining databases. (i.e., backup, restore, delete data, transaction log files, etc.). | 1 |
| S0045 | Skill in optimizing database performance. | 1 |
Abilities 1
| Code | Description | Work Roles |
|---|---|---|
| A0176 | Ability to maintain databases. (i.e., backup, restore, delete data, transaction log files, etc.). | 1 |
Tasks 14
| Code | Description | Work Roles |
|---|---|---|
| T0305 | Performs configuration management, problem management, capacity management, and financial management for databases and data management systems. | 1 |
| T0306 | Supports incident management, service-level management, change management, release management, continuity management, and availability management for databases and data management systems. | 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 |
| T0490 | Install and configure database management systems and software. | 1 |
| T0008 | Analyze and plan for anticipated changes in data capacity requirements. | 2 |
| T0137 | Maintain database management systems software. | 1 |
| T0139 | Maintain directory replication services that enable information to replicate automatically from rear servers to forward units via optimized routing. | 1 |
| T0140 | Maintain information exchanges through publish, subscribe, and alert functions that enable users to send and receive critical information as required. | 1 |
| T0146 | Manage the compilation, cataloging, caching, distribution, and retrieval of data. | 2 |
| T0152 | Monitor and maintain databases to ensure optimal performance. | 1 |
| T0162 | Perform backup and recovery of databases to ensure data integrity. | 1 |
| T0210 | Provide recommendations on new database technologies and architectures. | 2 |