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.
- Data Administrator
- Data Analyst
- Data Architect
- Database Analyst
- Database Architect
- Database Consultant
- Database Design Analyst
- Data Base Design Analyst
- Database Designer
- Database Engineer
- 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.
- Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
- Document and communicate database schemas, using accepted notations.
People who work in this occupation generally have the interest code: ICE.
This means people who work in this occupation generally have Investigative interests, but also prefer Conventional and Enterprising environments.
People who work in this occupation generally prize Achievement, but also value Working Conditions and Independence in their jobs.
- 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.
- 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.
- Complex Problem Solving - Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- 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.
- 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.
Most of these occupations require a four-year bachelor's degree, but some do not.
In 2017, the average annual wage in Ohio was $78,430 with most people making between $37,660 and $116,750
During 2014, this occupation employed approximately 7,520 people in Ohio. It is projected that there will be 7,590 employed in 2024.
This occupation will have about 7 openings due to growth and about 93 replacement openings for approximately 100 total annual openings.