An official State of Ohio site. Here’s how you know
Contact

Welcome,
New User

User: New User

Date: 02/06/2025

Database Architects

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.

View All

    Work Activities

    Work Activities

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

    Skills

    • Speaking

      Talking to others.

    • Writing

      Writing things for co-workers or customers.

    • Technology Design

      Making equipment and technology useful for customers.

    • Monitoring

      Keeping track of how well people and/or groups are doing in order to make improvements.

    • Quality Control Analysis

      Testing how well a product or service works.

    • Management of Material Resources

      Managing equipment and materials.

    • Time Management

      Managing your time and the time of other people.

    • Negotiation

      Bringing people together to solve differences.

    • Instructing

      Teaching people how to do something.

    • Coordination

      Changing what is done based on other people's actions.

    • Systems Evaluation

      Measuring how well a system is working and how to improve it.

    • Social Perceptiveness

      Understanding people's reactions.

    • Operations Monitoring

      Watching gauges, dials, or display screens to make sure a machine is working.

    • Critical Thinking

      Thinking about the pros and cons of different ways to solve a problem.

    • Operation and Control

      Using equipment or systems.

    • Active Learning

      Figuring out how to use new ideas or things.

    • Equipment Maintenance

      Planning and doing the basic maintenance on equipment.

    • Mathematics

      Using math to solve problems.

    • Programming

      Writing computer programs.

    • Reading Comprehension

      Reading work-related information.

    • Active Listening

      Listening to others, not interrupting, and asking good questions.

    • Operations Analysis

      Figuring out what a product or service needs to be able to do.

    • Persuasion

      Talking people into changing their minds or their behavior.

    • Troubleshooting

      Figuring out what is causing equipment, machines, wiring, or computer programs to not work.

    • Judgment and Decision Making

      Thinking about the pros and cons of different options and picking the best one.

    • Management of Personnel Resources

      Selecting and managing the best workers for a job.

    • Installation

      Installing equipment, machines, wiring, or computer programs.

    • Systems Analysis

      Figuring out how a system should work and how changes in the future will affect it.

    • Service Orientation

      Looking for ways to help people.

    • Complex Problem Solving

      Noticing a problem and figuring out the best way to solve it.

    • Science

      Using scientific rules and strategies to solve problems.

    • Equipment Selection

      Deciding what kind of tools and equipment are needed to do a job.

    • Learning Strategies

      Using the best training or teaching strategies for learning new things.

    • Management of Financial Resources

      Making spending decisions and keeping track of what is spent.

    • Repairing

      Repairing machines or systems using the right tools.

    WorkKeys®

    Applied Math
    N/A
    Workplace Documents
    N/A
    Graphic Literacy
    N/A

    Abilities

    • Category Flexibility

      Grouping things in different ways.

    • Speed of Closure

      Quickly knowing what you are looking at.

    • Auditory Attention

      Paying attention to one sound while there are other distracting sounds.

    • Gross Body Equilibrium

      Keeping your balance or staying upright.

    • Near Vision

      Seeing details up close.

    • Perceptual Speed

      Quickly comparing groups of letters, numbers, pictures, or other things.

    • Spatial Orientation

      Knowing where things are around you.

    • Dynamic Strength

      Exercising for a long time without your muscles getting tired.

    • Peripheral Vision

      Seeing something to your side when your are looking ahead.

    • Mathematical Reasoning

      Choosing the right type of math to solve a problem.

    • Visualization

      Imagining how something will look after it is moved around or changed.

    • Speed of Limb Movement

      Quickly moving your arms and legs.

    • Arm-Hand Steadiness

      Keeping your arm or hand steady.

    • Finger Dexterity

      Putting together small parts with your fingers.

    • Speech Clarity

      Speaking clearly.

    • Response Orientation

      Quickly deciding if you should move your hand, foot, or other body part.

    • Rate Control

      Changing when and how fast you move based on how something else is moving.

    • Selective Attention

      Paying attention to something without being distracted.

    • Control Precision

      Quickly changing the controls of a machine, car, truck or boat.

    • Multilimb Coordination

      Using your arms and/or legs together while sitting, standing, or lying down.

    • Flexibility of Closure

      Seeing hidden patterns.

    • Extent Flexibility

      Bending, stretching, twisting, or reaching with your body, arms, and/or legs.

    • Number Facility

      Adding, subtracting, multiplying, or dividing.

    • Night Vision

      Seeing at night or under low light.

    • Explosive Strength

      Jumping, sprinting, or throwing something.

    • Stamina

      Exercising for a long time without getting out of breath.

    • Oral Expression

      Communicating by speaking.

    • Information Ordering

      Ordering or arranging things.

    • Problem Sensitivity

      Noticing when problems happen.

    • Glare Sensitivity

      Seeing something even if there is a glare or very bright light.

    • Speech Recognition

      Recognizing spoken words.

    • Gross Body Coordination

      Moving your arms, legs, and mid-section together while your whole body is moving.

    • Static Strength

      Lifting, pushing, pulling, or carrying.

    • Fluency of Ideas

      Coming up with lots of ideas.

    • Far Vision

      Seeing details that are far away.

    • Trunk Strength

      Using your lower back and stomach.

    • Dynamic Flexibility

      Quickly and repeatedly bending, stretching, twisting, or reaching out with your body, arms, and/or legs.

    • Depth Perception

      Deciding which thing is closer or farther away from you, or deciding how far away it is from you.

    • Reaction Time

      Quickly moving your hand, finger, or foot based on a sound, light, picture or other command.

    • Wrist-Finger Speed

      Making fast, simple, repeated movements of your fingers, hands, and wrists.

    • Hearing Sensitivity

      Telling the difference between sounds.

    • Visual Color Discrimination

      Noticing the difference between colors, including shades and brightness.

    • Deductive Reasoning

      Using rules to solve problems.

    • Time Sharing

      Doing two or more things at the same time.

    • Sound Localization

      Noticing the direction that a sound came from.

    • Written Expression

      Communicating by writing.

    • Memorization

      Remembering words, numbers, pictures, or steps.

    • Oral Comprehension

      Listening and understanding what people say.

    • Written Comprehension

      Reading and understanding what is written.

    • Inductive Reasoning

      Making general rules or coming up with answers from lots of detailed information.

    • Manual Dexterity

      Holding or moving items with your hands.

    • Originality

      Creating new and original ideas.

    Knowledge

    • Transportation

      Knowledge of principles and methods for moving people or goods by air, rail, sea, or road, including the relative costs and benefits.

    • Geography

      Knowledge of principles and methods for describing the features of land, sea, and air masses, including their physical characteristics, locations, interrelationships, and distribution of plant, animal, and human life.

    • Communications and Media

      Knowledge of media production, communication, and dissemination techniques and methods. This includes alternative ways to inform and entertain via written, oral, and visual media.

    • English Language

      Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.

    • Medicine and Dentistry

      Knowledge of the information and techniques needed to diagnose and treat human injuries, diseases, and deformities. This includes symptoms, treatment alternatives, drug properties and interactions, and preventive health-care measures.

    • Biology

      Knowledge of plant and animal organisms, their tissues, cells, functions, interdependencies, and interactions with each other and the environment.

    • Economics and Accounting

      Knowledge of economic and accounting principles and practices, the financial markets, banking, and the analysis and reporting of financial data.

    • Design

      Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.

    • Public Safety and Security

      Knowledge of relevant equipment, policies, procedures, and strategies to promote effective local, state, or national security operations for the protection of people, data, property, and institutions.

    • Psychology

      Knowledge of human behavior and performance; individual differences in ability, personality, and interests; learning and motivation; psychological research methods; and the assessment and treatment of behavioral and affective disorders.

    • Telecommunications

      Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.

    • Therapy and Counseling

      Knowledge of principles, methods, and procedures for diagnosis, treatment, and rehabilitation of physical and mental dysfunctions, and for career counseling and guidance.

    • Law and Government

      Knowledge of laws, legal codes, court procedures, precedents, government regulations, executive orders, agency rules, and the democratic political process.

    • Computers and Electronics

      Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.

    • Education and Training

      Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.

    • Physics

      Knowledge and prediction of physical principles, laws, their interrelationships, and applications to understanding fluid, material, and atmospheric dynamics, and mechanical, electrical, atomic and sub-atomic structures and processes.

    • Chemistry

      Knowledge of the chemical composition, structure, and properties of substances and of the chemical processes and transformations that they undergo. This includes uses of chemicals and their interactions, danger signs, production techniques, and disposal methods.

    • Food Production

      Knowledge of techniques and equipment for planting, growing, and harvesting food products (both plant and animal) for consumption, including storage/handling techniques.

    • Customer and Personal Service

      Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.

    • Mathematics

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

    • Building and Construction

      Knowledge of materials, methods, and the tools involved in the construction or repair of houses, buildings, or other structures such as highways and roads.

    • Sociology and Anthropology

      Knowledge of group behavior and dynamics, societal trends and influences, human migrations, ethnicity, cultures, and their history and origins.

    • Sales and Marketing

      Knowledge of principles and methods for showing, promoting, and selling products or services. This includes marketing strategy and tactics, product demonstration, sales techniques, and sales control systems.

    • History and Archeology

      Knowledge of historical events and their causes, indicators, and effects on civilizations and cultures.

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

    • Administration and Management

      Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.

    • Administrative

      Knowledge of administrative and office procedures and systems such as word processing, managing files and records, stenography and transcription, designing forms, and workplace terminology.

    • Personnel and Human Resources

      Knowledge of principles and procedures for personnel recruitment, selection, training, compensation and benefits, labor relations and negotiation, and personnel information systems.

    • Foreign Language

      Knowledge of the structure and content of a foreign (non-English) language including the meaning and spelling of words, rules of composition and grammar, and pronunciation.

    • Fine Arts

      Knowledge of the theory and techniques required to compose, produce, and perform works of music, dance, visual arts, drama, and sculpture.

    • Philosophy and Theology

      Knowledge of different philosophical systems and religions. This includes their basic principles, values, ethics, ways of thinking, customs, practices, and their impact on human culture.

    • Production and Processing

      Knowledge of raw materials, production processes, quality control, costs, and other techniques for maximizing the effective manufacture and distribution of goods.

    • Mechanical

      Knowledge of machines and tools, including their designs, uses, repair, and maintenance.

    Career Video

    Video not available
    Additional videos and more information available on CareerOneStop

    Pay

    • Ohio Annual Salary 127230/yr
    • Typical Salary
    • Ohio Hourly Wage 61.17/hr
    • Typical Hourly Wage

    Ohio Employment Trends

    • Currently Employed 68,000
    • Yearly Projected Openings 4200

    Typical Education

    Personality

    Conventional: People interested in this work like activities that include data, detail, and regular routines.They do well at jobs that need:
    • Analytical Thinking
    • Attention to Detail
    • Achievement/Effort
    • Initiative
    • Cooperation
    • Integrity

    Tools

    • Desktop computers
    • Hard disk arrays
    • Hard disk drives
    • Laser fax machine
    • Mainframe computers
    • Notebook computers
    • Personal computers
    • Photocopiers
    • Server load balancer
    • Tape arrays

    Technology

    • Access software
    • Administration software
    • Analytical or scientific software
    • Application server software
    • Backup or archival software
    • Business intelligence and data analysis software
    • Cloud-based data access and sharing software
    • Cloud-based management software
    • Cloud-based protection or security software
    • Clustering software
    • Communications server software
    • Computer aided design CAD software
    • Configuration management software
    • Content workflow software
    • Customer relationship management CRM software
    • Data base management system software
    • Data base reporting software
    • Data base user interface and query software
    • Data mining software
    • Desktop communications software
    • Desktop publishing software
    • Development environment software
    • Document management software
    • Electronic mail software
    • Enterprise application integration software
    • Enterprise resource planning ERP software
    • Enterprise system management software
    • Expert system software
    • File versioning software
    • Geographic information system
    • Information retrieval or search software
    • Manufacturing execution system MES software
    • Medical software
    • Metadata management software
    • Multi-media educational software
    • Network conferencing software
    • Network monitoring software
    • Network security and virtual private network VPN equipment software
    • Network security or virtual private network VPN management software
    • Object or component oriented development software
    • Object oriented data base management software
    • Office suite software
    • Operating system software
    • Portal server software
    • Presentation software
    • Process mapping and design software
    • Program testing software
    • Project management software
    • Requirements analysis and system architecture software
    • Spreadsheet software
    • Storage media loading software
    • Storage networking software
    • Transaction security and virus protection software
    • Transaction server software
    • Video conferencing software
    • Web page creation and editing software
    • Web platform development software
    • Word processing software
    Need help on researching occupations and careers? Download the Guide to Researching Occupations (PDF).

    Need help on how to research education and training programs? Download the Guide to Higher Education (PDF).

    Budget Calculator

    Answer a few questions to determine your target salary. Use this target salary to help choose the right occupation for you.

    Lifestyle Calculator

    Answer a few questions to determine your target salary. Use this target salary to help choose the right occupation for you.

    Workforce Supply Tool

    Workforce Supply Tool

    The Workforce Supply Tool provides statistics for the occupations in highest demand throughout Ohio.

    You can view statewide statistics as well as more region specific information.

    Visit Site
    Powered By: