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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/groups/opt_out.
