*Position: MS SQL Server DBA* *Location: Dearborn, MI* *Duration: 4-6 month*
- Writing and improving DDL and DML queries for MSSQL Server (2008 R2) - Designing tables,views and picking datatypes - Using Profiler traces and other tools to find the most frequently run queries - Understanding the Query profile ,Network and time statics , validate the cost of the query and identify fix and - Using open source / Microsoft tools like sp_BlitzIndex and DMV queries as well as modeling tools like IBM Power Designer - Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem - Supporting the Load & Performance testing and review of performance scenarios and design fix . - Data load experience using SSIS from multiple data bases. -- *Thanks And Regards* *Dilvir Singh* * * *SRS Consulting Inc.* *Fremont, CA 94538* *Ph :510.256.0377 Ext 102* *Fax:510-252-0626* *Email: dil...@srsconsultinginc.com* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/groups/opt_out.