Hi Associates, Please let me know if you have any resource on this..
Required : "MS SQL Admin" Location : "Omaha,NE" Duration : "6+Months" Job Description :- Experience Level 3+ YEAR Skills Required Skill(s) Database Admin (L1) , Database Admin (L2) , Shell scripting (L1) , Database Performance Tuning (L2) , Database Backup and Recovery (L2) , Platform Administration for DB (L1) Essential Skill(s) MS SQL Admin (L2) Essential Skill(s) Skill1 - MS SQL Admin (L2) Understand New Features in SQL Server 2005 Data transfer and connectivitycommand list BCP, OSQL, ISQL, DTS Security -- Creation of logins / users. Grant/ deny permissions. Advanced Database Maintenance work -- moving databasesbetween servers, planning and sizing databases. Configuration Management: Goodknowledge of SP_configure, clear understanding of configuration parameters ofSQL Server at server level as well as database level. Understanding Queryexecution plan Understanding of SQL Profiler & other Windows performancemonitoring tools , Performace counters , analyzing profiler outputs RemoteAccess --Advanced -- Linked Server, Querying linked server data TSQL --Advanced -- Writing complex queries / SP. Resolving performance issues in SP /Queries. Log Shipping -- Setup / Initialization / Failover Replication -- Setup/ Initialization Connectivity Issues - resolving any connection issue to SQLServer like SSPI context error / SSL error. Handling Fragmentation / Statistics/ Index related issues related to slow performance. Logical & Physical DatabaseDesign, normalization, Codd's Rule Access Violation -- monitoring andtroubleshooting any AV's in SQL Server. SQL Cluster Management Low Free MemoryBasic Log Shipping Troubleshooting Basic Replication TroubleshootingInstallation of SQL Server instance on Cluster server. Cluster Administration -- Understanding of Cluster Administration tool, Start/Stop SQL resources,Online/Offline Cluster Resources, getting SQL Cluster status usingquery(command line), moving resources between nodes. SQL Server 2000 / 2005Service Account Selection and Management, Network Connectivity, Lockdown ofSystem Stored Procedures, Schema, Encryption, Patching Installing Service Packsand Applying Hot fixes Trouble shooting SQL-Agent job, Full-Text Searchfailure. Basic Database Mirroring Troubleshooting Thanks and Regards *Yash Chauhan* Ph: 609-897-9670 Ext- 2161 -- 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.