Kforce Domain Architect in Chicago, Illinois

Kforce has a client in search of Domain Architect in Chicago, Illinois (IL).Essential Functions:

  • Responsible for one or more or the components of the infrastructure of the Revenue Management Data Warehouse and Business Intelligence environments

  • Responsible for ensuring the RMDW/BI environment supports the business requirements for data content, availability and currency of supportable vendor software release levels

  • In conjunction with the Project Managers of Business Intelligence and ETL, partners with various Application Development portfolios to design and implement changes to the environment to achieve business goals

  • Contributes to the adoption of DW infrastructure standards and best practices

  • Performs environment administration, monitoring, tuning and support for one or more RMDW/ETL/BI capabilities (MSFT APS/PDW, SSDT, SSIS, SSAS, SSRS, Teradata, SAS, Spot fire) with a solid understanding of the infrastructure components

  • Leads source control and change management activities

  • Partners with Project Managers over the Business Intelligence and ETL capabilities to understand business requirements for various project efforts

  • Partners with logical modelers to ensure physical models and implementations are aligned with business requirements

  • Leads the activities of other team members assisting with environment support

  • Exhibits strong leadership skills with a proactive, participative management style while creating strong partnerships with IT Server Engineering and Change Management

  • Strong SQL and data warehouse organization (3NF/Dimensional) skills required

  • Strong programming skills required

  • Infrastructure knowledge of one or more of the following: MSFT APS/PDW, Teradata, DW administration (Automate, source control) or BI tools (SAS, Spotfire) required

  • Working knowledge of MSFT APS/PDW preferred

  • Excellent communication and interpersonal skills required

  • Ability to work as an individual contributor, team player and leader required

  • Ability to address production issues after core hours required

  • Ability to setup and support PDW/APS Servers

  • Ability to upgrade to the latest version of the platform, apply hotfixes, windows updates & security patches

  • Ability to setup BAR Server (Backup & Recovery), Landing zone for PDW/APS, schedule backups, schedule & monitor maintenance plans, 24x7 hardware support

  • Ability to capacity planning, Database-sizing, Disaster recovery testing/implementation, PDW/APS scale up scoping, troubleshooting PDW/APS, BAR, Landing zone server issues & root cause analysis

  • Expected to actively partner with Microsoft on product bug fixes and provide insights for future product enhancements with the MS product team and administer the servers with minimum downtime

  • Ability to provide training to team members on PDW/APS MPP architecture, best practices to load/process/query and how to avoid costly data moment operations like shuffle & broadcast move

  • Ability to manage workload balancing in PDW (10 load slots & 32 query slots)

  • Ability to setup PDW databases (user databases & staging), database sizing/resizing, Server level security & database level security

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.Compensation Type:Hours