S FL Based firm is looking for someone to monitor & analyze the capacity workloads of their cloud based software application (SaaS), compute, network and storage units and validate if the client's SLA’s are met. This is long-term assignment of up to 12 months.
Â
***MUST have SQL Cloud Data Capacity Planning Experience. ***
Â
Monitoring & Optimizing indexes of hosted databases for best performance
Capacity planning, sizing and database growth projections
SSIS and SSRS-to transfer data (ETL) to Data warehouse using manual and automated SSIS Packages
Â
Experience in analyzing data through Forecasting, trending and What-If analysis to ensure that clients have adequate capacity to perform their operations.
Windows Performance monitoring
SQL server, T- SQL programming
Data analysis
SQL Server Analysis Services
Sharepoint
System Center Operations Manager
Â
Design and develop Data Models for monitoring large data customers
Create custom Dashboards from the model to visualize data
Correlate data from application with system resources to determine the impact, identify the areas of concern and evaluate the size of customers future needs
Understand the current usage of the infrastructure component, application services, and the maximum capacity of each component
Analyze historic data and establish a baseline and alert when the threshold has been exceeded
Work with Application owners to identify the areas of concern, include in the model for analysis to ensure the optimal performance analysis of the application
Â
Strong Expertise in Capacity Planning. Please do not submit your credentials if you do not have Professional experience with SQL Data Capacity Planning.
Â
SherlockTalent loves to share our $500 referral.
