Hi Assoc, Warm Greetings from Entellects Corp!
Our client is looking to fill the position mentioned below. Kindly go ahead and revert me back if you have someone suitable. Response Time: Immediate Requirement: Title: SQL Server 2008 DBA Position: 2 Duration: NYC, NY Location: 12 months Interview: Immediate Description: The client is developing a new application that involves Business Intelligence. At this early stage, the intent for this application is to track "collect usage/events and then report". As times progresses, they envision that this application will be enriched. This application was primarily developed in conjunction with SAP and is in fact "hosted" by them and they have developed the reporting tools. This application will primarily be used by internal users to produce reports, search, etc. Problem: - Large number of clustered indexes. The indexing is done at load time. To give an idea as to the degree of indexing, a 3GB input file (CSV files) became 16GB of application data and 23GB of index data once loaded into the warehouse. (This suggests that all insert operation during the load are then made more expensive as the data is shuffled and the indexes updates.) - Numerous degenerate dimensions. The data warehouse loading has been over-complicated by tagging event with dimension information that is then carried exclusively within the fact records themselves (right from the XML source input). As a consequence, the load program is later forced to aggregate across billions of event records to scan these "degenerate dimension records" searching to determine for example if there are new items in the master enumerated list they manage as a dimension. - Numerous aggregate calculations. Numerous aggregates are calculated during the load process allowing subsequent reports to view the data by day/week/month/quarter/etc. While this is very convenient for reporting, the scanning of records to calculate these sums contributes to the performance degradation. - Original amount of load time for 3GB was at 39 hours. By securing the correct hardware per SAP, the amount has been lowered to 15 hours. Ideally the client wants it down to 6 to 7 hours or less. - Foreign key assignments/Referential Integrity Checks. While foreign key assignment and maintaining referential integrity are clearly best practices they do contribute to slowness while loading. - This database has never been optimized. - 1700 tables They are looking for a resource that can analyze these issues, provide a prioritized action plan as to which measures would give them the best performance improvements, help them to implement these changes and to test the improvements to see what has been gained. The client is not looking for a wholesale re-design at this time because they need to launch this product in May 2010. They want to improve the performance so that it can run in production for at least 2 years. Currently the Database seems to very normalized with 1000's of indexes. This is thought to provide a very flexible database for report running as they are expecting to run a wide variety of reports. Changes made to improve the data load time should not adversely impact the reporting running performance. Very Critical: The client will be increasing significantly the number of internal users as well as the amount of data per day. Client understands that SQL Server was only released about a year ago but they do want a very senior DBA. Keep in mind that SAP hosts the production system so we will be working on the test platform. The client wants a resource who can: - Optimize the system - Performance Monitoring and Tuning - Ideally have Data Integrator knowledge and experience. - If not Data Integrator, the candidates should have Data Warehousing - Investigate, analyze, recommend, implement and test improvements - Excellent Communications skills (verbal and written) Tools being used: - Globalscape - ETL - Data Integrator (from SAP) - Secured FTP Thanks & Regards Acer Mc Entellects Corp. Mailto: [email protected] | (V) 847-483-1814 ------------------------------------------------------------------------------------------ We respect your email and Internet privacy. If you have received this email in error or wish to be removed from our email list, please reply to us with the word "REMOVE" in the subject line and your ID will be removed from our mailing list immediately. We apologize for any inconvenience caused. -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
<<clip_image002.jpg>>
