According to people in this career, the main tasks are...
| Task | Importance |
|---|---|
| Develop and document database architectures. | 90% |
| Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements. | 89% |
| Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements. | 89% |
| Design databases to support business applications, ensuring system scalability, security, performance, and reliability. | 88% |
| Develop data models for applications, metadata tables, views or related database structures. | 81% |
| 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. | 81% |
| Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs. | 81% |
| Create and enforce database development standards. | 80% |
| Document and communicate database schemas, using accepted notations. | 79% |
| Develop data model describing data elements and their use, following procedures and using pen, template or computer software. | 79% |
| Work as part of a project team to coordinate database development and determine project scope and limitations. | 78% |
| Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management. | 77% |
| Set up database clusters, backup, or recovery processes. | 77% |
| Demonstrate database technical functionality, such as performance, security and reliability. | 75% |
| Develop load-balancing processes to eliminate down time for backup processes. | 74% |
| Plan and install upgrades of database management system software to enhance database performance. | 74% |
| Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. | 73% |
| Test programs or databases, correct errors, and make necessary modifications. | 72% |
| Identify and correct deviations from database development standards. | 71% |
| Review project requests describing database user needs to estimate time and cost required to accomplish project. | 69% |
| Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions. | 69% |
| Develop or maintain archived procedures, procedural codes, or queries for applications. | 65% |
| Provide technical support to junior staff or clients. | 64% |
| Establish and calculate optimum values for database parameters, using manuals and calculators. | 63% |
| Train users and answer questions. | 50% |
