NSXNational Skills ExchangeSign in
Back to Framework

Database Architects

SOC 15-1243.00Job Zone 4 · Considerable Preparationv.26.05

Context coveredThis framework covers database architecture practice in enterprise and technology-sector environments, spanning design, modeling, integration, governance, and strategic leadership for relational, distributed, and cloud-based database systems.

Emerging
Entry / Apprentice
  1. Database architecture documentationdraft and organize under direct supervision using established templates in a structured enterprise environment.
  2. Business requirementsgather and record by attending stakeholder meetings alongside senior architects on assigned projects.
  3. Data modelsconstruct basic entity-relationship diagrams for simple applications following mentor-provided guidelines.
  4. Database management system softwareinstall, configure, and perform routine maintenance tasks under close technical oversight.
  5. Database development standardsapply pre-established coding and naming conventions when writing SQL scripts in a supervised development environment.
  6. System scalability conceptsidentify and flag potential bottlenecks in proposed database designs during peer-review sessions.
  7. Backup and archival softwareexecute scheduled backup procedures and verify completion logs according to documented runbooks.
  8. Technical specificationsread and interpret requirements documents to extract relevant data structure needs for assigned schema components.
  9. Commercial database productsassist senior architects in customizing configuration settings to meet project-specific requirements.
  10. Database interfacessupport development of basic data transfer mechanisms by following approved design patterns under team guidance.
Developing
Mid-level / Established
  1. Database architecturesdevelop and document end-to-end designs for moderately complex systems with limited oversight in an enterprise setting.
  2. Stakeholder collaborationparticipate actively in cross-functional sessions with system architects and design analysts to translate business needs into data requirements.
  3. Data modelsdesign normalized relational and dimensional models including metadata tables and views for business application support.
  4. Database securityimplement role-based access controls, encryption policies, and audit logging in accordance with organizational security standards.
  5. Performance tuninganalyze query execution plans and apply indexing strategies, including function-based indexes, to optimize database response times.
  6. Architectural strategiesapply layered modeling and design approaches across development lifecycle phases to satisfy documented business requirements.
  7. Database application componentsbuild data partitions, global temporary tables, and stored procedures to enable efficient access to enterprise data structures.
  8. Product integrationdevelop and test methods for connecting disparate database products and middleware within a multi-system environment.
  9. Database development standardsenforce team-level coding and design conventions through code reviews and written guidelines.
  10. ERP and enterprise softwareconfigure and extend commercial database schemas to align with organization-specific operational workflows.
Proficient
Senior / Expert IC
  1. Database architectural strategiesdesign and implement comprehensive strategies spanning modeling, physical design, and deployment for large-scale enterprise systems autonomously.
  2. Business and industry requirementslead discovery sessions with diverse stakeholders including software architects and operations analysts to translate complex needs into actionable database designs.
  3. Scalable database systemsarchitect databases that address concurrent scalability, high availability, disaster recovery, and regulatory compliance across heterogeneous environments.
  4. Advanced data modelingproduce multi-tier data models encompassing OLTP, OLAP, and NoSQL structures aligned to varied application performance profiles.
  5. Database application designengineer complex interfaces, partitioning schemes, and indexing frameworks that optimize throughput for mission-critical workloads.
  6. Integration architecturedesign and validate end-to-end data integration pipelines connecting commercial, custom, and cloud-based database systems without introducing latency or data loss.
  7. Systems evaluationassess existing database architectures against emerging business demands, producing gap analyses and remediation roadmaps.
  8. Development standardsauthor and maintain organization-wide database development standards, patterns, and best-practice libraries used across project teams.
  9. Security and reliability designembed threat modeling, redundancy planning, and performance benchmarking into architectural decisions for sensitive data environments.
  10. Technology selectionevaluate and recommend database management platforms and tooling using structured criteria aligned to long-term organizational strategy.
Advanced
Lead / Principal / Executive
  1. Enterprise database strategydefine and own the multi-year data architecture roadmap, aligning database investments with organizational technology and business objectives.
  2. Organizational standards governanceestablish, publish, and continuously evolve enterprise-wide database development standards and architectural governance frameworks.
  3. Cross-functional leadershipdirect collaboration among software architects, data engineers, security officers, and business executives to ensure cohesive data architecture decisions.
  4. Architectural innovationpioneer adoption of emerging database paradigms such as distributed ledger, graph, or cloud-native architectures to address evolving industry requirements.
  5. Risk and compliance oversightlead enterprise-level database risk assessments, ensuring architectures meet regulatory, audit, and data sovereignty obligations across all systems.
  6. Mentorship and capability buildingcoach and evaluate architects at all experience levels, establishing structured learning pathways and technical review processes.
  7. Enterprise integration designapprove and oversee complex multi-product integration strategies that unify heterogeneous data ecosystems at organizational scale.
  8. Technology portfolio managementguide procurement, licensing, and retirement decisions for enterprise database management systems and supporting tooling.
  9. Performance and scalability standardsset organizational benchmarks for database reliability, response time, and fault tolerance, holding teams accountable through architecture review boards.
  10. Thought leadershiprepresent the organization's database architecture practice through published standards, industry engagement, and executive-level reporting on data infrastructure strategy.

AI-at-Work Competency Framework

A 4-level framework describing how a worker at each mastery level uses, directs, and evaluates AI tools in this occupation. Each statement cites its evidence inline. Subscribe for $19.99/mo to read the full framework — or sign in if you have a subscription.

  1. Emerging
  2. Developing
  3. Proficient
  4. Advanced
Monthly subscription · Stripe-hosted · unlocks AI-at-Work and Pathsmith Durable Skills across the full library

Ten durable-skill domains mapped to four proficiency levels for this occupation. Subscribe to unlock the full Pathsmith Durable Skills Framework across all 1,016 occupations.

Monthly subscription · Stripe-hosted · unlocks AI-at-Work and Pathsmith Durable Skills across the full library
Show O*NET source anchors58 anchors · skillscrosswalk.com

O*NET enrichment · skillscrosswalk.com

Suggest an O*NET correction

Source anchors that ground each statement

Related titles
ADP Planner (Automatic Data Processing Planner) · Big Data Architect · Big Data Engineer · Cloud Architect · Cloud Infrastructure Architect · Computer Architect · Data Analyst · Data Architect · Data Engineer · Data Governance Analyst · Data Integration Specialist · Data Management IT Specialist (Data Management Information Technology Specialist)
RAPIDS apprenticeships
O*NET skills
Reading ComprehensionCritical ThinkingComplex Problem SolvingJudgment and Decision MakingSystems AnalysisActive ListeningSpeakingProgrammingSystems EvaluationActive LearningOperations AnalysisWritingMonitoringTime ManagementTechnology DesignMathematicsSocial PerceptivenessCoordinationService Orientation
Knowledge domains
Computers and ElectronicsEngineering and TechnologyDesignMathematicsEnglish Language
Abilities
Deductive ReasoningOral ComprehensionWritten ComprehensionOral ExpressionProblem SensitivityInformation OrderingInductive ReasoningSpeech ClarityNear VisionCategory Flexibility
Work styles
Attention to DetailDependabilityIntellectual CuriosityAchievement OrientationCautiousnessInnovation
Technology
Word processing softwareEnterprise resource planning ERP softwareAccess softwareBackup or archival softwareDevelopment environment softwareData base management system softwareDocument management softwareWeb page creation and editing softwareObject or component oriented development softwareWeb platform development software
Tasks · seed anchors for statements
  1. Develop and document database architectures.
  2. Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
  3. Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
  4. Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
  5. Develop data models for applications, metadata tables, views or related database structures.
  6. 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.
  7. Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
  8. Create and enforce database development standards.
CIP education codes
11.010111.010311.040111.050111.070111.080211.090211.100314.090114.090314.270130.700130.709952.1201

Sources: O*NET v30.2 (CC BY 4.0), SkillsCrosswalk.com, LER.me®, Anthropic Economic Index, SAFI (Jadhav & Danve, 2026), WEF Skills Taxonomy 2021, Pathsmith Durable Skills Framework. © 2026 EBSCOed.