Occupation Details
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.
Quick Navigation
Interests
Investigative
Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally.
Enterprising
Enterprising occupations frequently involve starting up and carrying out projects. These occupations can involve leading people and making many decisions. Sometimes they require risk taking and often deal with business.
Conventional
Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow.
Work Values
Achievement
Occupations that satisfy this work value are results oriented and allow employees to use their strongest abilities, giving them a feeling of accomplishment. Corresponding needs are Ability Utilization and Achievement.
Working Conditions
Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions.
Independence
Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.
Salary & Job Outlook
Starting Salary
$84,580.00
New York StateMedian Salary
$134,740.00
New York StateExperienced Salary
$165,230.00
New York StateNational Average for Comparison
New York State Job Market Outlook
Jobs Right Now (2018)
291,900
professionals in NYFuture Job Growth (2030)
359,610
+6,771 jobs/yearNew Jobs Every Year
29,521
new opportunities yearlyGrowth Rate
0.2%
projected increasePreparation: Experience, Training, and Education
The list below outlines the prior educational experience required to perform in this occupation.
Degree Needed - Four-year college
Experience Requirements
A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.
Education Requirements
Most of these occupations require a four-year bachelor's degree, but some do not.
Training Details
Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
Transferrable Skills and Experience
Many of these occupations involve coordinating, supervising, managing, or training others. Examples include real estate brokers, sales managers, database administrators, graphic designers, conservation scientists, art directors, and cost estimators.
School Programs
The following lists school programs which are applicable to this occupation.
Licensing & Certification
State License and Certifications Requirements are not currently associated with this occupation.
Skills
The list below includes the skills required by workers in this occupation; skills are what allow you to learn more quickly and improve your performance.
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.
Complex Problem Solving
Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
Writing
Communicating effectively in writing as appropriate for the needs of the audience.
Programming
Writing computer programs for various purposes.
Skill level is measured on a seven point scale, where one means 'some competence required for this occupation' and seven means 'a high level of expertise required for this occupation'.
Knowledge
The list below includes knowledge items, the principles and facts required by this occupation.
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.
Knowledge level is measured on a seven point scale, where one means 'some competence required for this occupation' and seven means 'a high level of expertise required for this occupation'.
Work Environment
The list below includes the physical and social factors that influence the nature of work in this occupation.
Hover over or tap each factor to see its description.
Work Styles
Included in the list below are the personal work style characteristics that can affect how well a worker is likely to perform in this occupation.
Achievement/Effort
Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.
Analytical Thinking
Job requires analyzing information and using logic to address work-related issues and problems.
Attention to Detail
Job requires being careful about detail and thorough in completing work tasks.
Dependability
Job requires being reliable, responsible, and dependable, and fulfilling obligations.
Initiative
Job requires a willingness to take on responsibilities and challenges.
Innovation
Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.
Integrity
Job requires being honest and ethical.
Leadership
Job requires a willingness to lead, take charge, and offer opinions and direction.
Persistence
Job requires persistence in the face of obstacles.
Stress Tolerance
Job requires accepting criticism and dealing calmly and effectively with high-stress situations.
Tools & Technology
This list below describes the machines, equipment, tools, software, and information technology that workers in this occupation will use.
Tools
- Copy machines
- Desktop computers
- Hard disk drives
- Laser facsimile machines
- Load balancers
- Mainframe computers
- Notebook computers
- Personal computers
- Redundant array of independent disks RAID systems
Technology
- 3M Post-it App
- ADO.NET
- AJAX
- ASG Technologies ASG-Zeke
- Ab Initio
- Access management software
- Acronis Recovery Expert
- Adeptia ETL Suite
- Adobe Systems Adobe Acrobat
- Adobe Systems Adobe Dreamweaver
- Advanced business application programming ABAP
- Altova MapForce
- Amazon DynamoDB
- Amazon Elastic Compute Cloud EC2
- Amazon Kinesis
- Amazon Redshift
Duties
Job duties information is not available for this occupation.
Tasks
The list below outlines specific tasks that a worker in this occupation is called upon to do regularly.
- Develop data model describing data elements and their use, 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.
- 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.
- Develop data models for applications, metadata tables, views or related database structures.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- 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.