Apprentices progress at their own pace – they demonstrate
competency in skills and knowledge through assessment tests,
but are not required to complete a specific number of hours.
competency in skills and knowledge through assessment tests,
but are not required to complete a specific number of hours.
Database Architect
USDOL
National (OA)
Documents
View Original Document
Individual state requirements may vary. Please contact your local apprenticeship office to ensure this version is suitable to your state’s requirements.
Work Process Content
On the Job Training
Anonymous
34
Skills
Create Databases to Store Electronic Data
3
Create Databases to Store Electronic Data
3
- Design databases to support business applications, ensuring system scalability, security, performance, and reliability
- Develop and document database architectures
- Plan and install upgrades of database management system software to enhance database performance
Develop Procedures for Data Management
3
Develop Procedures for Data Management
3
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements
- Create and enforce database development standards
- Develop or maintain archived procedures, procedural codes, or queries for applications
Develop Models of Information or Communications Systems
2
Develop Models of Information or Communications Systems
2
- Develop data models for applications, metadata tables, views or related database structures
- Develop data model describing data elements and their use, following procedures and using pen, template or computer software
Collaborate with others to determine Design Specifications or Details
1
Collaborate with others to determine Design Specifications or Details
1
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements
Design Computer Modeling or Simulation Programs
1
Design Computer Modeling or Simulation Programs
1
- Develop data models for applications, metadata tables, views or related database structures
Develop Database Parameters or Specifications
4
Develop Database Parameters or Specifications
4
- Set up database clusters, backup, or recovery processes
- 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
- Establish and calculate optimum values for database parameters, using manuals and calculator
- Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions
Develop Performance Metrics or Standards Related to Information Technology
1
Develop Performance Metrics or Standards Related to Information Technology
1
- Create and enforce database development standards
Develop Technical Specifications or Requirements
1
Develop Technical Specifications or Requirements
1
- Develop and document database architectures
Communicate Project Information to Others
1
Communicate Project Information to Others
1
- Document and communicate database schemas, using accepted notations
Document Design or Development Procedures
1
Document Design or Development Procedures
1
- Document and communicate database schemas, using accepted notations
Evaluate Utility of Software or Hardware Technologies
1
Evaluate Utility of Software or Hardware Technologies
1
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance
Provide Recommendations to others about Computer Hardware
1
Provide Recommendations to others about Computer Hardware
1
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance
Assess Database Performance
2
Assess Database Performance
2
- Demonstrate database technical functionality, such as performance, security and reliability
- Test programs or databases, correct errors, and make necessary modifications
Create Electronic Data Backup to prevent loss of Information
1
Create Electronic Data Backup to prevent loss of Information
1
- Develop load-balancing processes to eliminate down time for backup processes
Provide Technical Support for Software Maintenance or Use
1
Provide Technical Support for Software Maintenance or Use
1
- Provide technical support to junior staff or clients
Resolve Computer Software Problems
1
Resolve Computer Software Problems
1
- Identify and correct deviations from database development standards
Install Computer Software
1
Install Computer Software
1
- Plan and install upgrades of database management system software to enhance database performance
Analyze Data to Identify Trends or Relationships among Variables
1
Analyze Data to Identify Trends or Relationships among Variables
1
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management
Analyze Market or Customer Related Data
1
Analyze Market or Customer Related Data
1
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management
Coordinate Project Activities with other Personnel or Departments
1
Coordinate Project Activities with other Personnel or Departments
1
- Work as part of a project team to coordinate database development and determine project scope and limitations
Develop Guidelines for System Implementation
1
Develop Guidelines for System Implementation
1
- Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs
Estimate Time or Monetary Resources needed to Complete Projects
1
Estimate Time or Monetary Resources needed to Complete Projects
1
- Review project requests describing database user needs to estimate time and cost required to accomplish project
Modify Software Programs to Improve Performance
1
Modify Software Programs to Improve Performance
1
- Test programs or databases, correct errors, and make necessary modifications
Train Others in Computer Interface or Software Use
1
Train Others in Computer Interface or Software Use
1
- Train users and answer questions
Write Computer Programming Code
1
Write Computer Programming Code
1
- Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions
Related Instruction Content
Training Provider(s):
Privileged Access Management Fundamentals
Privileged Access Management Fundamentals
Intro to Data Science
Intro to Data Science
CIS Critical Security Control 3: Data Protection
CIS Critical Security Control 3: Data Protection
Introduction to SQL
Introduction to SQL
Intermediate SQL
Intermediate SQL
Microsoft Database Administration Fundamentals
Microsoft Database Administration Fundamentals
Working with a SQL Database Lab
Working with a SQL Database Lab
Developing SQL Databases
Developing SQL Databases
Developing SQL Databases Lab
Developing SQL Databases Lab
Database Fundamentals - SQL Server 2016 Update
Database Fundamentals - SQL Server 2016 Update
Regex (Regular Expression Tester)
Regex (Regular Expression Tester)
SQL Injection
SQL Injection
Analyze SQL Injection Attack
Analyze SQL Injection Attack
Assign Server and Database Roles by Using SQL Server
Assign Server and Database Roles by Using SQL Server
Restore SQL Server Databases
Restore SQL Server Databases
Microsoft 70-464: Developing Microsoft SQL Server Databases
Microsoft 70-464: Developing Microsoft SQL Server Databases
Azure Storage Accounts
Azure Storage Accounts
AZ-301 Microsoft Azure Architect Design
AZ-301 Microsoft Azure Architect Design
AZ-305 Designing Microsoft Azure Infrastructure Solutions
AZ-305 Designing Microsoft Azure Infrastructure Solutions
Provisioning a MySQL Database Lab
Provisioning a MySQL Database Lab
Provision An Azure Database for MySQL Database
Provision An Azure Database for MySQL Database
Provision Relational Databases for a Web App
Provision Relational Databases for a Web App
Database and SQL Fundamentals
Database and SQL Fundamentals
Oracle Database 12c SQL Fundamentals
Oracle Database 12c SQL Fundamentals
Oracle Database 12c Installation and Administration Virtual Lab
Oracle Database 12c Installation and Administration Virtual Lab
Oracle IZO-144: Program with PLISQL
Oracle IZO-144: Program with PLISQL
Oracle IZO-071: Database SQL
Oracle IZO-071: Database SQL
Exfiltration to Cloud Storage
Exfiltration to Cloud Storage
System Hardening
System Hardening
Teamwork and Collaboration
Teamwork and Collaboration
Communication
Communication
Problem Solving
Problem Solving
Critical Thinking
Critical Thinking
Conflict Management
Conflict Management
Time Management
Time Management
Customer Service
Customer Service
Similar Programs
System Administrator (1130HYV1) Hybrid
Hybrid
•
15-1242.00
Systems Analyst & Software Development (2017CBV1) Competency-Based
Competency
•
15-1211.00
Full Stack Software Engineer (1129HYV1) Hybrid
Hybrid
•
15-1252.00
Application Developer
Competency
•
15-1252.00
Computer Science+ Human Centered Design and Innovation
Competency
•
15-1211.00