Oct 30

Data Warehouse Platform Services


KPSoft administrators will collaborate with CLIENT production environment staff, management team and customer representatives for supporting the operational environments for EDIM. All preplanned activities will be communicated in advance. We will provide documentation highlighting the list of activities that will be performed during the initial communications and subsequently provide complete documentation with step-by-step procedures and administrative guides for conducting the activities. For all issues identified, our technical staff will conduct an impact analysis, find the root cause and then communicate list of steps to the production staff for addressing the issue. Our high level steps for providing the operational support are as follows:

Operational Activity Support Procedures
Platform Availability Develop SLAs (e.g. high availability) for each component of DATA WAREHOUSE AND ANALYTICS, develop documentation and support configuration, setup monitors and alarms, and provide support as described above.
DATA WAREHOUSE AND ANALYTICS Technical Forum KPSoft representatives from our architectural council will provide leadership to the technical forum; Collaborate with other stakeholders on the forum for governance and enforcement of SLAs on the DATA WAREHOUSE AND ANALYTICS platform; create wikis using Google Sites for documenting blogs, knowledge articles, tips and tuning steps for each significant component of DATA WAREHOUSE AND ANALYTICS, review implementation plans with the forum and provide support for executing them. KPSOFT’s AGC facilitated communication between stakeholders and provided leadership for USDA FS’ VIPR BI project.
Platform Performance KPSOFT administrators will configure auto scaling features (e.g. AWS) for increasing computing resources during peak and normal hours in an elastic fashion; Issues will be address as discussed above.
Impacts Assessment Impacts will be analyzed by our technical staff, dependent steps will be developed, risks will be analyzed, and resolution will be executed.
Platform Upgrade/Patching Quarterly, security and major/minor release patches will be reviewed, dependencies will be highlighted and executions steps will be documented.
Platform Bug Fixes All reported bugs will be tracked in our configuration management, development teams will provide fixes, QC team will test and release them to production as emergency fixes or minor releases.
DATA WAREHOUSE AND ANALYTICS Platform Vulnerabilities All tiers (database, application server and application) will be tracked for vulnerabilities using web app, O/S and RDBMS scanning tools. All reports will be analyzed, fixed and released to the production teams.
Security Documentation KPSOFT will comply with the CLIENT IT Security Office requirements, develop documentation and implement controls as needed.
Audit Support KPSOFT will comply with the CLIENT audit support requirements.
Configuration Management KPSOFT will subject our development and QC environments to the same levels of security, major and minor release patching of the vendor software; KPSOFT will follow NIST and other CLIENT federal security guidelines.
Security Assessment & Authorization KPSOFT will comply and provide support to the CLIENT ATO A&A activities. We will coordinate with CLIENT IT Security Office and conduct A&A on KPSOFT’s internal environments, identify and mitigate issues in advance.