Database Administrator
Administers databases and/or data management systems that allow for the secure storage, query, protection, and utilization of data.
NICE CATEGORY | Operate and Maintain |
NICE SPECIALIST AREA | Data Administration |
NICE WORK ROLE ID | OM-DTA-001 |
OPM CODE | 421 |
KSA-T
Below are the Knowledge, Skills, Abilities and Tasks (KSA-T) identified as being required to perform this work role.
Learn More about the KAS-T's.
ID | DESCRIPTION |
---|---|
K001 | Knowledge of computer networking concepts and protocols, and network security methodologies. |
K0002 | Knowledge of risk management processes (e.g., methods for assessing and mitigating risk). |
K0003 | Knowledge of laws, regulations, policies, and ethics as they relate to cybersecurity and privacy. |
K0004 | Knowledge of cybersecurity and privacy principles. |
K0005 | Knowledge of cyber threats and vulnerabilities. |
K0006 | Knowledge of specific operational impacts of cybersecurity lapses. |
K0020 | Knowledge of data administration and data standardization policies. |
K0021 | Knowledge of data backup and recovery. |
K0022 | Knowledge of data mining and data warehousing principles. |
K0023 | Knowledge of database management systems, query languages, table relationships, and views. |
K0025 | Knowledge of digital rights management. |
K0031 | Knowledge of enterprise messaging systems and associated software. |
K0056 | Knowledge of network access, identity, and access management (e.g., public key infrastructure, Oauth, OpenID, SAML, SPML). |
K0060 | Knowledge of operating systems. |
K0065 | Knowledge of policy-based and risk adaptive access controls. |
K0069 | Knowledge of query languages such as SQL (structured query language). |
K0083 | Knowledge of sources, characteristics, and uses of the organization??s data assets. |
K0097 | Knowledge of the characteristics of physical and virtual data storage media. |
K0197 | Knowledge of database access application programming interfaces (e.g., Java Database Connectivity [JDBC]). |
K0260 | Knowledge of Personally Identifiable Information (PII) data security standards. |
K0261 | Knowledge of Payment Card Industry (PCI) data security standards. |
K0262 | Knowledge of Personal Health Information (PHI) data security standards. |
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). |
K0278 | Knowledge of current and emerging data remediation security features in databases. |
K0287 | Knowledge of an organization's information classification program and procedures for information compromise. |
K0420 | Knowledge of database theory. |
ID | DESCRIPTION |
---|---|
S0002 | Skill in allocating storage capacity in the design of data management systems. |
S0013 | Skill in conducting queries and developing algorithms to analyze data structures. |
S0037 | Skill in generating queries and reports. |
S0042 | Skill in maintaining databases. (i.e., backup, restore, delete data, transaction log files, etc.). |
S0045 | Skill in optimizing database performance. |
ID | DESCRIPTION |
---|---|
A0176 | Ability to maintain databases. (i.e., backup, restore, delete data, transaction log files, etc.). |
ID | DESCRIPTION |
---|---|
T0008 | Analyze and plan for anticipated changes in data capacity requirements. |
T0137 | Maintain database management systems software. |
T0139 | Maintain directory replication services that enable information to replicate automatically from rear servers to forward units via optimized routing. |
T0140 | Maintain information exchanges through publish, subscribe, and alert functions that enable users to send and receive critical information as required. |
T0146 | Manage the compilation, cataloging, caching, distribution, and retrieval of data. |
T0152 | Monitor and maintain databases to ensure optimal performance. |
T0162 | Perform backup and recovery of databases to ensure data integrity. |
T0210 | Provide recommendations on new database technologies and architectures. |
T0305 | Performs configuration management, problem management, capacity management, and financial management for databases and data management systems. |
T0306 | Supports incident management, service-level management, change management, release management, continuity management, and availability management for databases and data management systems. |
T0330 | Maintain assured message delivery systems. |
T0422 | Implement data management standards, requirements, and specifications. |
T0459 | Implement data mining and data warehousing applications. |
T0490 | Install and configure database management systems and software. |