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

  • 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.
  • Develop and document database architectures.
  • 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.
  • 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.
  • Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
  • Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
  • Establish and calculate optimum values for database parameters, using manuals and calculator.
  • Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
  • Review project requests describing database user needs to estimate time and cost required to accomplish project.
  • Test programs or databases, correct errors, and make necessary modifications.
  • Train users and answer questions.
  • Work as part of a project team to coordinate database development and determine project scope and limitations.
  • Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
Work Context
  • Electronic Mail — 96% responded "Every day".
  • Spend Time Sitting — 84% responded "Continually or almost continually".
  • Indoors, Environmentally Controlled — 92% responded "Every day".
  • Face-to-Face Discussions — 70% responded "Every day".
  • Telephone — 53% responded "Every day".
  • Importance of Being Exact or Accurate — 50% responded "Extremely important".
  • Freedom to Make Decisions — 46% responded "A lot of freedom".
  • Read More
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.
  • Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.
  • Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
  • 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.
  • Read More
Detailed Work Activities
  • Provide technical support for software maintenance or use.
  • Develop database parameters or specifications.
  • Evaluate utility of software or hardware technologies.
  • Provide recommendations to others about computer hardware.
  • Create databases to store electronic data.
  • Install computer software.
  • Read More

Knowledge

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

Skills

Critical Thinking
  • Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
Reading Comprehension
  • Understanding written sentences and paragraphs in work related documents.
Judgment and Decision Making
  • Considering the relative costs and benefits of potential actions to choose the most appropriate one.
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.
Read More

Abilities

Deductive Reasoning
  • The ability to apply general rules to specific problems to produce answers that make sense.
Written Comprehension
  • The ability to read and understand information and ideas presented in writing.
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 there is a problem.
Read More

Personality

People interested in this work like activities that include ideas, thinking, and figuring things out.
They do well at jobs that need:
  • Achievement/Effort
  • Persistence
  • Initiative
  • Leadership
  • Cooperation
  • Concern for Others
  • Social Orientation
  • Self Control
Read More

Technology

You might use software like this on the job:

Web platform development software
  • JavaScript Object Notation JSON Hot Technology
  • PHP: Hypertext Preprocessor Hot Technology
  • Hypertext markup language HTML Hot Technology
  • JavaScript Hot Technology
  • Drupal Hot Technology
  • Django Hot Technology
  • React Hot Technology
  • Google AngularJS Hot Technology
  • Node.js Hot Technology
  • Oracle JavaServer Pages JSP Hot Technology
  • Microsoft ASP.NET Core MVC Hot Technology
  • Microsoft ASP.NET Hot Technology
  • Microsoft Active Server Pages ASP Hot Technology
  • Apache Struts Hot Technology
  • Apache Tomcat Hot Technology
  • Backbone.js Hot Technology
  • AJAX Hot Technology
  • Spring Framework Hot Technology
  • Ruby on Rails Hot Technology
  • Cascading Style Sheets CSS Hot Technology
  • Oracle Application Express APEX
  • Oracle Designer
  • LAMP Stack
  • Extensible HyperText Markup Language XHTML
  • Ext JS
  • Enterprise JavaBeans
  • Dynamic hypertext markup language DHTML
Operating system software
  • Oracle Solaris Hot Technology
  • Microsoft Windows Hot Technology
  • Red Hat Enterprise Linux Hot Technology
  • Microsoft Windows Server Hot Technology
  • Linux Hot Technology
  • Apple macOS Hot Technology
  • Bash Hot Technology
  • UNIX Shell Hot Technology
  • UNIX Hot Technology
  • Shell script Hot Technology
  • Ubuntu
  • Perl shell
  • Cisco IOS
  • C shell
  • KornShell
  • Job control language JCL
  • Hewlett Packard HP-UX
  • IBM AIX
  • DOS shell script
Application server software
  • Oracle WebLogic Server Hot Technology
  • Red Hat OpenShift Hot Technology
  • Red Hat WildFly Hot Technology
  • Docker Hot Technology
  • GitHub Hot Technology
  • Spring Boot Hot Technology
  • Oracle Application Server
  • Application server software
Read More

Education

Get started on your career:

Job Outlook

New job opportunities are very likely in the future.
Salary
NA
NA
NA

Explore More