Skills: SQL DBA, Stored Procedures, Erwin, Shell Scripts, and PERL
we are looking out for SQL DBA with following skills
Problem solving skills Scripting (VBScript, Perl, Windows Shell) Communication skills Ability to follow documented instructions - Backup and restore of user databases; backup and restore of system databases - Configure sqlserver to use specific about of RAM, specific number of CPUs - Understand pros and cons of having indexes on large tables; Understand how are the indexes used my sqlserver - Understand pros and cons of "parallel query execution" - Understand what row, page, and table db-locks are; and how they effect performance and data availability - Understand Constraint, Trigger, Default, Stored procedure, and View s - What is: page and extent ? - What is: clustered and non-clustered index ? - What is: query Execution-Plan ? - What are the database network protocols for connecting to sqlserver ? - Windows Authentication" - DML, DDL
|
