** ** ** *Dear Associate*,****
Hope you are doing well. **** I am trying to reach you regarding an opportunity for *“SQL Server Developer”* Position based in *“Redmond, WA”* and the description and Skills required are copied below.**** Please revert back to me if you are available & interested in below opportunity with word version of your resume, best time & number to contact you along with the hourly rates. Please feel free to contact me to discuss more about this opportunity. Just In case if you are not available and interested then please send me a copy of your resume along with your availability. May be in future we can get in touch.**** * Position : SQL Server Developer***** *Location : Redmond, WA***** *Duration : 6+ Month Contract***** **** *Description:***** **· **Setting up, Managing, Scheduling, Monitoring and Troubleshooting SQL Server Jobs**** **· **Understanding of TSQL Syntax and be able to right queries for data extraction and reporting**** **· **Determining and resolving Blocking/Deadlocking issues**** **· **Basic Database Concepts including Relational Databases (Entity/Referential/Domain Integrity) and Normalization**** **· **Resolving SQL Server related Connectivity/Security Issues**** **· **Database Maintenance including Backup/Restore, Attach/Detach, and various DBCC commands**** **· **Setting up and Managing Database Recovery Models. Making sure that these do not adversly effect Database and Log Backups**** **· **SQL Server Table Index design and implementation**** **· **Query Optimization concepts. Including Join queries (Hash Join, Merge Join, and Nested Loop Join). How do Indexes, Statisitics and Fragmentation effect query performance**** **· **Database Design, Implementation, Maintenance, and Optimization **** **· **Stored Procedures and Triggers Design and Implementation**** **· **Creating, Scheduling and Troubleshooting SQL DTS and SQL SSIS Packages**** **· **SQL Server Profiler Trace**** **· **Setting Up and Interpreting Performance Monitor**** **· **Using Windows API’s for managing Scheduled Tasks/Services and collecting System Stats**** **· ******Reading**** and writing MS-DOS code ( .BAT/ .CMD) for processes like File Copy/Move, File CRC check, Collecting File stats and Collecting Files lists**** **· **Read Pearl scripts to troubleshoot problems with the system*** * **· **Schedule automated tasks for Moving Data to various locations* *** **· **Communicate effectively with the Business Team**** **· **Communicate effectively with the Feed providers. Keep the escalation document updated as needed**** **· **Update the Process Documents as and when needed **** **· **Identify Code problems and enhancements for the various processes. Effectively communicate the issues to the Dev team and Document the changes**** **· **Monitor SAN Drives using the EMC2 PowerPath Console**** **· **Monitor and run EMC2Replication Manager Clone jobs**** **** **** Click here to view current job openings.<http://www.maxhire.net/cp/?E15E6A361D43515B7D501329> **** *Thanks & Regards, Bhageerath| Sr. Resourcing Specialist SYSTEL INC. Direct: 678-261-5238 | Board: 678-261-5220 Ext 324 Fax: 678-623-5938 | **http://www.systelinc.com*<http://www.systelinc.com/><http://www.systelinc.com/> *E-mail ID: **bhageera...@systelinc.com* <bhageera...@systelinc.com>* Yahoo IM: speak2bhageeratha *http://www.linkedin.com/in/bhageerathm**** ** ** -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To post to this group, send email to business_intelligence@googlegroups.com. To unsubscribe from this group, send email to business_intelligence+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/business_intelligence?hl=en.
