Data Administration

Develops and administers databases and/or data management systems that allow for the storage, query, protection, and utilization of data.
Analyzes and interprets data from multiple disparate sources and builds visualizations and dashboards to report insights.
Core KSATs
KSAT ID | Description | KSAT |
---|---|---|
22 | * Knowledge of computer networking concepts and protocols, and network security methodologies. |
Knowledge |
108 | * Knowledge of risk management processes (e.g., methods for assessing and mitigating risk). |
Knowledge |
1157 | * Knowledge of national and international laws, regulations, policies, and ethics as they relate to cybersecurity. |
Knowledge |
1158 | * Knowledge of cybersecurity principles. |
Knowledge |
1159 | * Knowledge of cyber threats and vulnerabilities. |
Knowledge |
6900 | * Knowledge of specific operational impacts of cybersecurity lapses. |
Knowledge |
6935 | * Knowledge of cloud computing service models Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS). |
Knowledge |
6938 | * Knowledge of cloud computing deployment models in private, public, and hybrid environment and the difference between on-premises and off-premises environments. |
Knowledge |
Additional KSATs
KSAT ID | Description | KSAT |
---|---|---|
31 | Knowledge of data mining and data warehousing principles. |
Knowledge |
104 | Knowledge of query languages such as SQL (structured query language). |
Knowledge |
166 | Skill in conducting queries and developing algorithms to analyze data structures. |
Skill |
201 | Skill in generating queries and reports. |
Skill |
796 | Provide a managed flow of relevant information (via web-based portals or other means) based on a mission requirements. |
Task |
942 | Knowledge of the organization’s core business/mission processes. |
Knowledge |
1034A | Knowledge of Personally Identifiable Information (PII) data security standards. |
Knowledge |
1034C | Knowledge of Personal Health Information (PHI) data security standards. |
Knowledge |
1120 | Ability to interpret and incorporate data from multiple tool sources. |
Ability |
3022 | Ability to communicate complex information, concepts, or ideas in a confident and well-organized manner through verbal, written, and/or visual means. |
Ability |
5030 | Analyze data sources to provide actionable recommendations. |
Task |
5100 | Collect metrics and trending data. |
Task |
5270 | Develop strategic insights from large data sets. |
Task |
5430 | Present technical information to technical and non-technical audiences. |
Task |
5440 | Present data in creative formats. |
Task |
5570 | Provide actionable recommendations to critical stakeholders based on data analysis and findings. |
Task |
5899 | Manipulate and clean large, disparate datasets for bulk analysis to identify connections. |
Task |
6130 | Ability to identify basic common coding flaws at a high level. |
Ability |
6180 | Ability to use data visualization tools (e.g., Flare, HighCharts, AmCharts, D3.js, Processing, Google Visualization API, Tableau, Raphael.js). |
Ability |
6300 | Knowledge of how to utilize Hadoop, Java, Python, SQL, Hive, and PIG to explore data. |
Knowledge |
6470A | Read, interpret, write, modify, and execute scripts, macros, and functions. |
Task |
6570 | Skill in identifying hidden patterns or relationships. |
Skill |
6710 | Skill in using basic descriptive statistics and techniques (e.g., normality, model distribution, scatter plots). |
Skill |
6720 | Skill in using data analysis tools (e.g., Excel, STATA SAS, SPSS). |
Skill |
6780 | Utilize different programming languages to write code, open files, read files, and write output to different files. |
Task |
6915A | Skill in communicating with all levels of the organization, including senior/mid-level executives, and operational-level personnel (e.g., interpersonal skills, approachability, effective listening skills, appropriate use of style and language for the audience). |
Skill |
7029 | Knowledge of how to collect, store, and monitor data. |
Knowledge |
7031 | Knowledge of how to structure and display data. |
Knowledge |
7032 | Knowledge of how to use data to tell a story. |
Knowledge |
7036 | Knowledge of laws, regulations, and policies related to AI, data security/privacy, and use of publicly procured data for government. |
Knowledge |
Administers databases and/or data management systems that allow for the storage, query, and utilization of data.
Core KSATs
KSAT ID | Description | KSAT |
---|---|---|
22 | * Knowledge of computer networking concepts and protocols, and network security methodologies. |
Knowledge |
108 | * Knowledge of risk management processes (e.g., methods for assessing and mitigating risk). |
Knowledge |
1157 | * Knowledge of national and international laws, regulations, policies, and ethics as they relate to cybersecurity. |
Knowledge |
1158 | * Knowledge of cybersecurity principles. |
Knowledge |
1159 | * Knowledge of cyber threats and vulnerabilities. |
Knowledge |
6900 | * Knowledge of specific operational impacts of cybersecurity lapses. |
Knowledge |
6935 | * Knowledge of cloud computing service models Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS). |
Knowledge |
6938 | * Knowledge of cloud computing deployment models in private, public, and hybrid environment and the difference between on-premises and off-premises environments. |
Knowledge |
Additional KSATs
KSAT ID | Description | KSAT |
---|---|---|
28 | Knowledge of data administration and data standardization policies and standards. |
Knowledge |
29 | Knowledge of data backup, types of backups (e.g., full, incremental), and recovery concepts and tools. |
Knowledge |
31 | Knowledge of data mining and data warehousing principles. |
Knowledge |
32 | Knowledge of database management systems, query languages, table relationships, and views. |
Knowledge |
79 | Knowledge of network access, identity, and access management (e.g., public key infrastructure [PKI]). |
Knowledge |
98 | Knowledge of policy-based and risk adaptive access controls. |
Knowledge |
104 | Knowledge of query languages such as SQL (structured query language). |
Knowledge |
137 | Knowledge of the characteristics of physical and virtual data storage media. |
Knowledge |
179B | Skill in establishing data security controls. |
Skill |
208 | Skill in maintaining databases. |
Skill |
213 | Skill in optimizing database performance. |
Skill |
401 | Analyze and plan for anticipated changes in data capacity requirements. |
Task |
520A | Implement data mining and data warehousing applications. |
Task |
664A | Install and configure database management systems and software. |
Task |
684 | Maintain database management systems software. |
Task |
712 | Monitor and maintain databases to ensure optimal performance. |
Task |
740 | Perform backup and recovery of databases to ensure data integrity. |
Task |
815 | Provide recommendations on new database technologies and architectures. |
Task |
910 | Knowledge of database theory. |
Knowledge |
942 | Knowledge of the organization’s core business/mission processes. |
Knowledge |
952 | Knowledge of emerging security issues, risks, and vulnerabilities. |
Knowledge |
1034C | Knowledge of Personal Health Information (PHI) data security standards. |
Knowledge |
1034A | Knowledge of Personally Identifiable Information (PII) data security standards. |
Knowledge |
1123A | Knowledge of current and emerging data encryption (e.g., Column and Tablespace Encryption, file and disk encryption) security features in databases, including built-in cryptographic key management features. |
Knowledge |
1124A | Knowledge of current and emerging data remediation security features in databases. |
Knowledge |
1128A | Knowledge of database access application programming interfaces (APIs) (e.g., Java Database Connectivity [JDBC]). |
Knowledge |
1154 | Performs configuration management, problem management, capacity management, and financial management for databases and data management systems. |
Task |
1155 | Supports incident management, service level management, change management, release management, continuity management, and availability management for databases and data management systems. |
Task |
5890 | Identify data consolidation opportunities across database systems, including data sharing and access between business lines. |
Task |
6945 | Skill in migrating workloads to, from, and among the different cloud computing service models. |
Skill |
7029 | Knowledge of how to collect, store, and monitor data. |
Knowledge |
7036 | Knowledge of laws, regulations, and policies related to AI, data security/privacy, and use of publicly procured data for government. |
Knowledge |