Senior infrastructure architect vs data warehouse architect

Differences between senior infrastructure architect and data warehouse architect duties and responsibilities

Senior infrastructure architect example responsibilities.

• Manage and support Citrix application builds and release cycles.
• Manage Cisco ASA firewalls and Microsoft ISA firewalls in production environment providing secure configurations and monitoring of the firewall logs.
• Provision, configure and maintain cloud resources including server instances, load balancers, security groups, DNS management, certificates.
• Plan and implement a sophisticate Linux server environment for a major MVNO.
• Assist in the development of a long term vision and strategy regarding virtualization and storage.
• Install new servers, all new workstations, switches, backup system, and cabling.
Show more

Data warehouse architect example responsibilities.

• Design dimensional data models, develop SQL and UNIX scripts to automate extraction and loading of data.
• Report procedures against SSAS are constructed and ExcelWriter templates are developed to automate and replace existing manually generate, client-contract reports.
• Design and build PL/SQL code to extract, transform and load the data into the star schema objects.
• Design the data warehouse with star and snowflake schemas.
• Develop the SAS enterprise guide data research and ad hoc reports and store procedures.
• Debug and tune queries for semantic layer (consume by Java screens and MicroStrategy).
Show more