Career Details

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

Key Facts

Bright Outlook

Career Details

Green Job

Career Details

Current Employment

N/A

Estimate

Forecasted Employment

N/A

Estimate

Change in Employment

N/A

Estimate

Change in Employment %

N/A

Estimate

Tasks

The tasks listed below can be performed to prepare you for a career in this field.

Core

Provide technical support to junior staff or clients.
Set up database clusters, backup, or recovery processes.
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
Plan and install upgrades of database management system software to enhance database performance.
Identify and correct deviations from database development standards.
Document and communicate database schemas, using accepted notations.
Develop or maintain archived procedures, procedural codes, or queries for applications.
Develop load-balancing processes to eliminate down time for backup processes.
Develop data models for applications, metadata tables, views or related database structures.
Design databases to support business applications, ensuring system scalability, security, performance and reliability.
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.
Demonstrate database technical functionality, such as performance, security and reliability.
Create and enforce database development standards.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Develop and document database architectures.

Generic

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.

All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.

Knowledge

The items listed below are organized into sections that contain knowledge useful for pursuing a career in this field. Each section also contains a "Percentage of Importance" statistic that shows how relevant an item is to the occupation.

Computers and Electronics

English Language

Design

Mathematics

Engineering and Technology

Education and Training

Administration and Management

Telecommunications

All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.

Tools

The tools listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.

Media storage devices

Computers

Network service equipment

Duplicating machines

All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.

Technology

The technologies listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.

Business function specific software

Finance accounting and enterprise resource planning ERP software

Content authoring and editing software

Content management software

Data management and query software

Development software

Educational or reference software

Industry specific software

Network applications software

Network management software

Networking software

Operating environment software

Security and protection software

Utility and device driver software

Information exchange software

System management software

All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.

Certifications

The certifications listed below are useful to pursue if you are interested in a career in this field.

No specific certifications are listed for this career

All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.

Licensing

The licensing information below is organized into sections and is useful for pursuing if you are interested in a career in this field.

No specific licensing information is listed for this occupation in the area you have selected.

All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.

Related Programs

Programs related to this career, offered by participating institution(s), are listed below.

Clicking on the Degree programs in the list below will take you away from the Careers page.

INSTITUTION

PROGRAMS

Peirce College

Programs

Associate in Science Information Technology

Associate in Science

The Peirce Information Technology program prepares graduates to be successful information technology professionals by providing them crucial critical thinking, problem solving, and life-long learning skills needed to respond to the ever-changing demands of the information technology field while also providing practical skills in high demand, state-of-the-art technology.

Bachelor of Science Information Technology

Bachelor of Science

After meeting the requirements of the associate degree, students in the bachelor's program will deepen their knowledge of network operating system environments and gain understanding of material needed to design, build, secure, and maintain enterprise-grade networks. Most acquire the fundamental knowledge to pursue the industry's premier Microsoft Certified Systems Engineer (MCSE) certification. They will also learn the Cisco Certified Network Associate (CCNA) curriculum and that of CompTIA's Linux+. Students also have the opportunity to explore new security technologies and standards, while building critical thinking and problem solving skills. The concentration culminates in a capstone project that allows the student to highlight knowledge gained in applied networking and security.

Bachelor of Science Information Technology

Bachelor of Science

After meeting the requirements of the associate degree, graduates from this program make excellent candidates for positions as application developers, programmers, and systems analysts. Students are equipped to determine the customer's needs and design and implement a systems-based solution. Bachelor's students will study higher-level application development in the .NET environment involving courses in ASP, SQL, XML, and the component object model for application development. Students will also explore tools used in systems analysis such as Microsoft Project and Visio. This concentration culminates in a capstone project that requires the student to build a working program or prototype to demonstrate practical skills and knowledge gained in this area of study.

Certificate of Proficiency Cybersecurity

Certificate of Proficiency

The Certificate of Proficiency in Cybersecurity equips students with the technical skills and policy perspectives to enable organizations to more effectively secure their information assets. Students learn how to manage and mitigate risk, and to test and defend against network vulnerabilities. The program is designed for students from a variety of backgrounds, both in IT and nontechnical fields, seeking to start a career in the lucrative and fast-growing cybersecurity field.ï¿½ï¿½

Certificate of Proficiency Cloud Computing

Certificate of Proficiency

The Certificate of Proficiency in Cloud Computing equips students with the relevant practical skills and knowledge needed to participate in the field of cloud computing.ï¿½ With a focus on hands-on learning, students will build a solid foundation for pursuing industry certifications and effectively deploying, operations, and maintaining the cloud-based systems that are transforming how organizations provision IT services.

Bachelor of Science Technology Management

Bachelor of Science

This program is designed for current information technology professionals seeking a degree that will advance their careers and prepare them to step into supervisory or management roles in IT. As a degree completion program, it enables students to build on their previous studies to put together a program that blends technology and business courses customized to meet their career goals and the needs of today's organizations.

Jobs

Jobs related to this career may be found on Indeed.com or on the Google Job Search page.