*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: [email protected]* -- You received this message because you are subscribed to the Google Groups "GTA DBA" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/gtadba. For more options, visit https://groups.google.com/groups/opt_out.
