Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Create and optimize data models for warehouse infrastructure and workflow. Integrate new systems with existing warehouse structure and refine system performance and functionality.
Work Activities
-
Design databases to support business applications, ensuring system scalability, security, performance and reliability.
-
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
-
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
-
Develop data models for applications, metadata tables, views or related database structures.
-
Set up database clusters, backup, or recovery processes.
-
Create and enforce database development standards.
-
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.
-
Develop and document database architectures.
-
Document and communicate database schemas, using accepted notations.
-
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
-
Demonstrate database technical functionality, such as performance, security and reliability.
-
Develop or maintain archived procedures, procedural codes, or queries for applications.
-
Develop load-balancing processes to eliminate down time for backup processes.
-
Provide technical support to junior staff or clients.
-
Identify and correct deviations from database development standards.
-
Plan and install upgrades of database management system software to enhance database performance.
-
Critical Thinking
Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
-
Judgment and Decision Making
Considering the relative costs and benefits of potential actions to choose the most appropriate one.
-
Reading Comprehension
Understanding written sentences and paragraphs in work-related documents.
-
Deductive Reasoning
The ability to apply general rules to specific problems to produce answers that make sense.
-
Information Ordering
The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
-
Problem Sensitivity
The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing that there is a problem.
-
Computers and Electronics
Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
-
English Language
Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
-
Design
Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
- Education Bachelor's degree
- Work Experience No work experience
- Training No on-the-job training
-
Looking for technical training programs?
Check out these programs:
Investigative: People interested in this work like activities that include ideas, thinking, and figuring things out.They do well at jobs that need:
-
Analytical Thinking
-
Attention to Detail
-
Initiative
-
Integrity
-
Dependability
-
Innovation
-
Mainframe computers
-
Laser fax machine
-
Hard disk drives
-
Hard disk arrays
-
Desktop computers
-
Web platform development software
-
Operating system software
-
Metadata management software
-
Development environment software
-
Data base management system software
