Senior Data Architect
Click the Facebook, Google+ or LinkedIn icons to share this job with your friends or contacts. Click the Twitter icon to tweet this job to your followers. Click the link button to view the URL of the job, which then can be copied and pasted into an e-mail or other document.
Chicago, IL 60611
Provide technical and strategic consulting on large scale Enterprise Data platform projects including leadership and expertise in the development of standards, architectural governance, design patterns, and best practices. Design, develop and implement large scale Enterprise Data Warehouse, Data Marts, Data Integration, Data Extraction and maintains end-to-end Business Intelligence and reporting solutions including data validation, enrichment, transformation and visualization. Provide technical leadership in the development and support of technological application infrastructure and related data warehouses. Work with the customer stakeholders to understand business and technical requirements. Design and implement database high availability and disaster recovery strategy in on-premise and cloud environments using clustering, Backup, Log Shipping, Mirroring, Always On and Replication. Architect and monitor the ETL process to ensure data delivery into a data warehouse using data pipelines and data ingestion techniques. Configure and maintain SQL Server database servers and processes, including monitoring of system health and performance, to ensure a high level of performance, availability, and security. Perform in depth performance tuning utilizing SQL Traces, PSSDIAG, Perfmon, Resource monitor, third party tools, and SQL Dynamic Management Views. Identify and communicate issues/risks applying technical and root cause analysis skills. Support and review production applications and databases to ensure the stability of applications and appropriate access to data in the production environment. Migrate external relational database systems (like Oracle and Sybase) to SQL Server. Upgrade SQL Server systems using SQL Server Upgrade Advisor and SQL Server Migration Assistant.