- Knowledge of computer networking concepts and protocols, and network security methodologies.
- Knowledge of risk management processes (e.g., methods for assessing and mitigating risk).
- Knowledge of laws, regulations, policies, and ethics as they relate to cybersecurity and privacy.
- Knowledge of cybersecurity and privacy principles.
- Knowledge of cyber threats and vulnerabilities.
- Knowledge of specific operational impacts of cybersecurity lapses.
- Knowledge of data administration and data standardization policies.
- Knowledge of data backup and recovery.
- Knowledge of data mining and data warehousing principles.
- Knowledge of database management systems, query languages, table relationships, and views.
- Knowledge of digital rights management.
- Knowledge of enterprise messaging systems and associated software.
- Knowledge of network access, identity, and access management (e.g., public key infrastructure, Oauth, OpenID, SAML, SPML).
- Knowledge of operating systems.
- Knowledge of policy-based and risk adaptive access controls.
- Knowledge of query languages such as SQL (structured query language).
- Knowledge of sources, characteristics, and uses of the organization's data assets.
- Knowledge of the characteristics of physical and virtual data storage media.
- Knowledge of database access application programming interfaces (e.g., Java Database Connectivity [JDBC]).
- Knowledge of Personally Identifiable Information (PII) data security standards.
- Knowledge of Payment Card Industry (PCI) data security standards.
- Knowledge of Personal Health Information (PHI) data security standards.
- 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).
- Knowledge of current and emerging data remediation security features in databases.
- Knowledge of an organization's information classification program and procedures for information compromise.
- Knowledge of database theory.
Database Administrator
Administers databases and/or data management systems that allow for the secure storage, query, protection, and utilization of data.
- Skill in allocating storage capacity in the design of data management systems.
- Skill in conducting queries and developing algorithms to analyze data structures.
- Skill in generating queries and reports.
- Skill in maintaining databases. (i.e., backup, restore, delete data, transaction log files, etc.).
- Skill in optimizing database performance.
- Ability to maintain databases. (i.e., backup, restore, delete data, transaction log files, etc.).
- Analyze and plan for anticipated changes in data capacity requirements.
- Maintain database management systems software.
- Maintain directory replication services that enable information to replicate automatically from rear servers to forward units via optimized routing.
- Maintain information exchanges through publish, subscribe, and alert functions that enable users to send and receive critical information as required.
- Manage the compilation, cataloging, caching, distribution, and retrieval of data.
- Monitor and maintain databases to ensure optimal performance.
- Perform backup and recovery of databases to ensure data integrity.
- Provide recommendations on new database technologies and architectures.
- Performs configuration management, problem management, capacity management, and financial management for databases and data management systems.
- Supports incident management, service-level management, change management, release management, continuity management, and availability management for databases and data management systems.
- Maintain assured message delivery systems.
- Implement data management standards, requirements, and specifications.
- Implement data mining and data warehousing applications.
- Install and configure database management systems and software.
