Friday 5 April 2013

Requirement For DBA


Knowledge, skills, and abilities needed to be successful in this role include:
* Knowledge of SQL Server 2005/2008
* Ability to perform database and SQL performance analysis and to make tuning changes, including but not limited to the use of SQL Profiler
* Expertise in the use and design of SQL Server Analysis Services 2008
* Expertise in the use of SQL Server Reporting Services 2008
* Experience estimating storage requirements for an application
* Excellent verbal and written communication skills
* Ability to work individually or within a team environment
* Ability to take direction and work to specified deadlines
* Displays professionalism and a commitment to quality
* Experience with design and maintenance of data warehouse

No comments:

Post a Comment

Check if column exists or not in the SQL server

--method 1 IF EXISTS(SELECT 1 FROM sys.columns with (nolock)           WHERE Name = N'LoginName'           AND Object_ID = Objec...