Data Administration

Develops and administers databases and/or data management systems that allow for the storage, query, protection, and utilization of data.
Examines data from multiple disparate sources with the goal of providing new insight. Designs and implements custom algorithms, flow processes and layouts for complex, enterprise-scale data sets used for modeling, data mining, and research purposes.
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 |
166 | Skill in conducting queries and developing algorithms to analyze data structures. |
Skill |
201 | Skill in generating queries and reports. |
Skill |
1120 | Ability to interpret and incorporate data from multiple tool sources. |
Ability |
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 |
Additional KSATs
KSAT ID | Description | KSAT |
---|---|---|
21 | Knowledge of computer algorithms. |
Knowledge |
23 | Knowledge of computer programming principles such as object-oriented design. |
Knowledge |
28 | Knowledge of data administration and data standardization policies and standards. |
Knowledge |
31 | Knowledge of data mining and data warehousing principles. |
Knowledge |
32 | Knowledge of database management systems, query languages, table relationships, and views. |
Knowledge |
35 | Knowledge of digital rights management. |
Knowledge |
44 | Knowledge of enterprise messaging systems and associated software. |
Knowledge |
65A | Knowledge of Information Theory (e.g., source coding, channel coding, algorithm complexity theory, and data compression). |
Knowledge |
74 | Knowledge of low-level computer languages (e.g., assembly languages). |
Knowledge |
75A | Knowledge of mathematics, including logarithms, trigonometry, linear algebra, calculus, statistics, and operational analysis. |
Knowledge |
79 | Knowledge of network access, identity, and access management (e.g., public key infrastructure [PKI]). |
Knowledge |
90 | Knowledge of operating systems. |
Knowledge |
98 | Knowledge of policy-based and risk adaptive access controls. |
Knowledge |
102 | Knowledge of programming language structures and logic. |
Knowledge |
104 | Knowledge of query languages such as SQL (structured query language). |
Knowledge |
120 | Knowledge of sources, characteristics, and uses of the organization’s data assets. |
Knowledge |
135 | Knowledge of the capabilities and functionality associated with various technologies for organizing and managing information (e.g., databases, bookmarking engines). |
Knowledge |
172 | Skill in creating and utilizing mathematical or statistical models. |
Skill |
186 | Skill in developing data dictionaries. |
Skill |
187 | Skill in developing data models. |
Skill |
224A | Skill in the use of design modeling (e.g., unified modeling language). |
Skill |
238A | Skill in writing code in a currently supported programming language (e.g., Java, C++). |
Skill |
342 | Knowledge of Unix command line (e.g., mkdir, mv, ls, passwd, grep). |
Knowledge |
400 | Analyze and define data requirements and specifications. |
Task |
401 | Analyze and plan for anticipated changes in data capacity requirements. |
Task |
520B | Develop and implement data mining and data warehousing programs. |
Task |
529 | Develop data standards, policies, and procedures. |
Task |
702 | Manage the compilation, cataloging, caching, distribution, and retrieval of data. |
Task |
796 | Provide a managed flow of relevant information (via web-based portals or other means) based on a mission requirements. |
Task |
815 | Provide recommendations on new database technologies and architectures. |
Task |
904 | Knowledge of interpreted and compiled computer languages. |
Knowledge |
905 | Knowledge of secure coding techniques. |
Knowledge |
910 | Knowledge of database theory. |
Knowledge |
1088 | Skill in using binary analysis tools (e.g., Hexedit, command code xxd, hexdump). |
Skill |
1091 | Skill in one way hash functions (e.g., Secure Hash Algorithm [SHA], Message Digest Algorithm [MD5]). |
Skill |
1115 | Skill in reading Hexadecimal data. |
Skill |
1116 | Skill in identifying common encoding techniques (e.g., Exclusive Disjunction [XOR], American Standard Code for Information Interchange [ASCII], Unicode, Base64, Uuencode, Uniform Resource Locator [URL] encode). |
Skill |
1124 | Knowledge of advanced data remediation security features in databases. |
Knowledge |
1128 | Knowledge of Java-based database access application programming interface (API) (e.g., Java Database Connectivity [JDBC]). |
Knowledge |
3722 | Skill in data mining techniques (e.g., searching file systems) and analysis. |
Skill |
5030 | Analyze data sources to provide actionable recommendations. |
Task |
5080 | Assess the validity of source data and subsequent findings. |
Task |
5100 | Collect metrics and trending data. |
Task |
5120 | Conduct hypothesis testing using statistical processes. |
Task |
5140 | Confer with systems analysts, engineers, programmers and others to design application. |
Task |
5220 | Develop and facilitate data-gathering methods. |
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 |
5550 | Program custom algorithms. |
Task |
5570 | Provide actionable recommendations to critical stakeholders based on data analysis and findings. |
Task |
5640 | Utilize technical documentation or resources to implement a new mathematical, data science, or computer science method. |
Task |
6050 | Ability to build complex data structures and high-level programming languages. |
Ability |
6120 | Ability to dissect a problem and examine the interrelationships between data that may appear unrelated. |
Ability |
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 |
6190 | Effectively allocate storage capacity in the design of data management systems. |
Task |
6200 | Knowledge of applications that can log errors, exceptions, and application faults and logging. |
Knowledge |
6300 | Knowledge of how to utilize Hadoop, Java, Python, SQL, Hive, and PIG to explore data. |
Knowledge |
6311 | Knowledge of machine learning theory and principles. |
Knowledge |
6470 | Read, interpret, write, modify, and execute simple scripts (e.g., PERL, VBS) on Windows and UNIX systems (e.g., those that perform tasks such as: parsing large data files, automating manual tasks, and fetching/processing remote data). |
Task |
6490 | Skill in assessing the predictive power and subsequent generalizability of a model. |
Skill |
6520 | Skill in data pre-processing (e.g., imputation, dimensionality reduction, normalization, transformation, extraction, filtering, smoothing). |
Skill |
6570 | Skill in identifying hidden patterns or relationships. |
Skill |
6610 | Skill in performing format conversions to create a standard representation of the data. |
Skill |
6620 | Skill in performing sensitivity analysis. |
Skill |
6650 | Skill in developing machine understandable semantic ontologies. |
Skill |
6651 | Skill in Regression Analysis (e.g., Hierarchical Stepwise, Generalized Linear Model, Ordinary Least Squares, Tree-Based Methods, Logistic). |
Skill |
6690 | Skill in transformation analytics (e.g., aggregation, enrichment, processing). |
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 |
6730 | Skill in using data mapping tools. |
Skill |
6750 | Skill in using outlier identification and removal techniques. |
Skill |
6760 | Skill in writing scripts using R, Python, PIG, HIVE, SQL, etc. |
Skill |
6780 | Utilize different programming languages to write code, open files, read files, and write output to different files. |
Task |
6790 | Utilize opens source language such as R and apply quantitative techniques (e.g., descriptive and inferential statistics, sampling, experimental design, parametric and non-parametric tests of difference, ordinary least squares regression, general line). |
Task |
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 |
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 |
32 | Knowledge of database management systems, query languages, table relationships, and views. |
Knowledge |
104 | Knowledge of query languages such as SQL (structured query language). |
Knowledge |
108 | * Knowledge of risk management processes (e.g., methods for assessing and mitigating risk). |
Knowledge |
208 | Skill in maintaining databases. |
Skill |
213 | Skill in optimizing database performance. |
Skill |
400A | Implement data management standards, requirements, and specifications. |
Task |
401 | Analyze and plan for anticipated changes in data capacity requirements. |
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 |
1154 | Performs configuration management, problem management, capacity management, and financial management for databases and data management systems. |
Task |
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 |
Additional KSATs
KSAT ID | Description | KSAT |
---|---|---|
31 | Knowledge of data mining and data warehousing principles. |
Knowledge |
35 | Knowledge of digital rights management. |
Knowledge |
44 | Knowledge of enterprise messaging systems and associated software. |
Knowledge |
79 | Knowledge of network access, identity, and access management (e.g., public key infrastructure [PKI]). |
Knowledge |
90 | Knowledge of operating systems. |
Knowledge |
98 | Knowledge of policy-based and risk adaptive access controls. |
Knowledge |
120 | Knowledge of sources, characteristics, and uses of the organization’s data assets. |
Knowledge |
137 | Knowledge of the characteristics of physical and virtual data storage media. |
Knowledge |
152 | Skill in allocating storage capacity in the design of data management systems. |
Skill |
166 | Skill in conducting queries and developing algorithms to analyze data structures. |
Skill |
201 | Skill in generating queries and reports. |
Skill |
520A | Implement data mining and data warehousing applications. |
Task |
688 | Maintain directory replication services that enable information to replicate automatically from rear servers to forward units via optimized routing. |
Task |
690 | Maintain information exchanges through publish, subscribe, and alert functions that enable users to send and receive critical information as required. |
Task |
702 | Manage the compilation, cataloging, caching, distribution, and retrieval of data. |
Task |
815 | Provide recommendations on new database technologies and architectures. |
Task |
910 | Knowledge of database theory. |
Knowledge |
1034A | Knowledge of Personally Identifiable Information (PII) data security standards. |
Knowledge |
1034B | Knowledge of Payment Card Industry (PCI) data security standards. |
Knowledge |
1034C | Knowledge of Personal Health Information (PHI) 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 |
1141A | Knowledge of an organization’s information classification program and procedures for information compromise. |
Knowledge |
1155 | Supports incident management, service level management, change management, release management, continuity management, and availability management for databases and data management systems. |
Task |
2541 | Maintain assured message delivery systems. |
Task |