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