How do they match: Database Architects

  • Data Warehouse Programmer
  • Database Programmer

  • 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.

  • 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.
  • Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
  • Develop data models for applications, metadata tables, views or related database structures.
  • Develop or maintain archived procedures, procedural codes, or queries for applications.
  • Test programs or databases, correct errors, and make necessary modifications.

  • Design computer modeling or simulation programs.
  • Modify software programs to improve performance.
  • Write computer programming code.