Database Administrator

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

Below are the Knowledge, Skills, Abilities and Tasks identified as being required to perform this work role.

Knowledge of computer networking concepts and protocols, and network security methodologies.
Knowledge of risk management processes (e.g., methods for assessing and mitigating risk).
K0003Knowledge of laws, regulations, policies, and ethics as they relate to cybersecurity and privacy.
K0004Knowledge of cybersecurity and privacy principles.
K0005Knowledge of cyber threats and vulnerabilities.
K0006Knowledge of specific operational impacts of cybersecurity lapses.
K0020Knowledge of data administration and data standardization policies.
K0021Knowledge of data backup and recovery.
K0022Knowledge of data mining and data warehousing principles.
K0023Knowledge of database management systems, query languages, table relationships, and views.
K0025Knowledge of digital rights management.
K0031Knowledge of enterprise messaging systems and associated software.
K0056Knowledge of network access, identity, and access management (e.g., public key infrastructure, Oauth, OpenID, SAML, SPML).
K0060Knowledge of operating systems.
K0065Knowledge of policy-based and risk adaptive access controls.
K0069Knowledge of query languages such as SQL (structured query language).
K0083Knowledge of sources, characteristics, and uses of the organization??s data assets.
K0097Knowledge of the characteristics of physical and virtual data storage media.
K0197Knowledge of database access application programming interfaces (e.g., Java Database Connectivity [JDBC]).
K0260Knowledge of Personally Identifiable Information (PII) data security standards.
K0261Knowledge of Payment Card Industry (PCI) data security standards.
K0262Knowledge of Personal Health Information (PHI) data security standards.
K0277Knowledge 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).
K0278Knowledge of current and emerging data remediation security features in databases.
K0287Knowledge of an organization’s information classification program and procedures for information compromise.
K0420Knowledge of database theory.
S0002Skill in allocating storage capacity in the design of data management systems.
S0013Skill in conducting queries and developing algorithms to analyze data structures.
S0037Skill in generating queries and reports.
S0042Skill in maintaining databases. (i.e., backup, restore, delete data, transaction log files, etc.).
S0045Skill in optimizing database performance.
A0176Ability to maintain databases. (i.e., backup, restore, delete data, transaction log files, etc.).
T0008Analyze and plan for anticipated changes in data capacity requirements.
T0137Maintain database management systems software.
T0139Maintain directory replication services that enable information to replicate automatically from rear servers to forward units via optimized routing.
T0140Maintain information exchanges through publish, subscribe, and alert functions that enable users to send and receive critical information as required.
T0146Manage the compilation, cataloging, caching, distribution, and retrieval of data.
T0152Monitor and maintain databases to ensure optimal performance.
T0162Perform backup and recovery of databases to ensure data integrity.
T0210Provide recommendations on new database technologies and architectures.
T0305Performs configuration management, problem management, capacity management, and financial management for databases and data management systems.
T0306Supports incident management, service-level management, change management, release management, continuity management, and availability management for databases and data management systems.
T0330Maintain assured message delivery systems.
T0422Implement data management standards, requirements, and specifications.
T0459Implement data mining and data warehousing applications.
T0490Install and configure database management systems and software.