Hi, Requirement for SQL Server Application DBA for 6 Months in CA. ** *Job Code: *86768
*Job Title: *SQL Server Application DBA *Experience Level* 6-10YEAR *Location Of Posting : Country *USA *City *San Francisco *Contract Duration: *6 Months *Maximum Rate payable to the Staffing Agency: *USD 40 Per Hour *Expected Joining Date: *26-05-2010 *Area Of Expertise *IT Infrastructure *Description/Skills Required: * - Understanding of Database Architecture Concepts Awareness on Application DBA Basics - Ability to understand Basic DB Administration - Ability to understand DB Administration Tools Working Knowledge of database specific data movement tools - Strong knowledge in Database Architecture Able to Implement Application DBA Skills (Like Application/ Development Support Admin) - Working knowledge on DB Administration using Tools ( SQL Server Enterprise Manager) - Ability to understand Database Upgrade Ability to understand Database Migration Process Expertise in using Database Tuning and Monitoring tools for performance improvements Knowledge of Database Replication - Able to work on Database Upgrade Able to work on Database Migrations - Ability to use Data Migration Tools for implementing Database Migrations." RDBMS - Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model,etc - Ability to understand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques MS SQL - SQL Constructs - Ability to understand and implement Data Types, Basic SQL SELECT Statements, Restricting and Sorting Data, System Functions, Joins, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views SQL Query Tuning Basics - Understanding of concepts like Tuning Methodology, SQL Statement Processing, SHOWPLAN, Introduction to the Optimizer, Indexes and Basic Access Methods, Gathering Statistics, Optimizer Hints, Monitoring queries, Optimizing queries. Adv SQL: COMPUTE Clause, Advanced INSERT, Transact-SQL conditions and expressions. *Do we have the flexibility for telephonic interviews? *YES * Thanks & Regards, Santhosh Rao, P: (508) 329 0577 | 1-888-4ADVANS ADVANS | www.AdvansIT.com<https://outlook.advanstec.com/exchweb/bin/redir.asp?URL=http://www.advansit.com/> | E: [email protected] Join Our Green IT Initiative: www.GridIsGreen.com<http://www.gridisgreen.com/> Join Our Monthly E-Newsletter List<https://outlook.advanstec.com/exchweb/bin/redir.asp?URL=http://visitor.constantcontact.com/d.jsp?m=1102771162946%26p=oi> * -- To unsubscribe, reply using "remove me" as the subject.
