Completion requirements
Read this summary report for data consultants/architects. Familiarize yourself with the knowledge, skills, abilities, and education level organizations look for when seeking to hire a data consultant.
Details
Tasks
Importance | Category | Task |
---|---|---|
89 | Core |
Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
|
85 | Core |
Develop database architectural strategies at the modeling, design, and implementation stages to address business or industry requirements.
|
80 | Core |
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
|
80 | Core |
Develop data models for applications, metadata tables, views or related database structures.
|
79 | Core |
Set up database clusters, backup, or recovery processes.
|
74 | Core |
Create and enforce database development standards.
|
71 | Core |
Develop and document database architectures.
|
71 | Core |
Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
|
68 | Core |
Document and communicate database schemas, using accepted notations.
|
66 | Core |
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
|
64 | Core |
Demonstrate database technical functionality, such as performance, security and reliability.
|
63 | Core |
Develop or maintain archived procedures, procedural codes, or queries for applications.
|
63 | Core |
Develop load-balancing processes to eliminate down time for backup processes.
|
61 | Core |
Provide technical support to junior staff or clients.
|
61 | Core |
Identify and correct deviations from database development standards.
|
55 | Core |
Plan and install upgrades of database management system software to enhance database performance.
|
Not available | Not available |
Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
|
Not available | Not available |
Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
|
Not available | Not available |
Establish and calculate optimum values for database parameters, using manuals and calculator.
|
Not available | Not available |
Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
|
Not available | Not available |
Review project requests describing database user needs to estimate time and cost required to accomplish project.
|
Not available | Not available |
Test programs or databases, correct errors, and make necessary modifications.
|
Not available | Not available |
Train users and answer questions.
|
Not available | Not available |
Work as part of a project team to coordinate database development and determine project scope and limitations.
|
Not available | Not available |
Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
|