Design strategies for enterprise database systems and set standards for operations, programming, and security. Design and construct large relational databases. Integrate new systems with existing warehouse structure and refine system performance and functionality.

Also known as: Data Administrator, Data Architect, Data Officer, Database Architect, Database Consultant, Information Architect, Information Modeling Engineer Specialist, Information Technology Architect (IT Architect), System Engineer, Technical Operations Vice President

Daily Tasks / Routine Tasks

1. Design databases to support business applications, ensuring system scalability, security, performance and reliability.

2. Develop data models for applications, metadata tables, views or related database structures.

3. Create and enforce database development standards.

4. Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.

5. Develop and document database architectures.

6. Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.

7. 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.

8. Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.

9. Document and communicate database schemas, using accepted notations.

10. Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.

11. Demonstrate database technical functionality, such as performance, security and reliability.

12. Develop load-balancing processes to eliminate down time for backup processes.

Work Activities

Interacting With Computers — Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.

Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.

Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.

Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.

Processing Information — Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.

Updating and Using Relevant Knowledge — Keeping up-to-date technically and applying new knowledge to your job.

Communicating with Supervisors, Peers, or Subordinates — Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.

Provide Consultation and Advice to Others — Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.

Evaluating Information to Determine Compliance with Standards — Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.

Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.

Developing Objectives and Strategies — Establishing long-range objectives and specifying the strategies and actions to achieve them.

Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work.

Coordinating the Work and Activities of Others — Getting members of a group to work together to accomplish tasks.

Key Knowledge Areas

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.

Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.

Engineering and Technology — Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.

Top Skills

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.

Active Listening — Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.

Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.

Speaking — Talking to others to convey information effectively.

Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.

Coordination — Adjusting actions in relation to others' actions.

Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.

Programming — Writing computer programs for various purposes.

Systems Evaluation — Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.

Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.