* Hi Partner, * * *
*Role: TECH SQL SERVER LEAD* * * *Location: Boise, Idaho* *Duration: 9+ Months * * * *Skill: - SQL Server Application Admin* * **Experience Level: *5-8YEAR * * *Essential Skill(s): SQL Server Application Admin (L3), SQL Server T-SQL Programming (L4), DB Modeling (L1)* * * *Additional skills: SSRS (L3)* * * *Job Description:-* *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.* * * *Skill: - SQL Server T-SQL Programming* *Database Programming Basics: Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Creating Database Triggers and Transaction Management. Adv Database Programming: Ability to understand and implement Dynamic SQL Usage, Programming with locks and isolations and Working with Temporary Tables Adv Database Programming: Advanced Transact-SQL constructs, Business logic with stored procedures, Creating user-defined functions(UDF), Formulating triggers, Integrating XML with Transact-SQL, Transactions in T-SQL, Transferring data to and from SQL Server. Tools Level 1Usage Adv Database Programming: Ability to Tune T-SQL Applications for Performance, Advanced Query concepts, Adv Stored Procedure Programming, DTS Programming Understanding of Database Migration Process: Understanding of Database Upgrade: Ability to work on Database Upgrade using T-SQL Ability to work on Database Migrations using T-SQL Exposure to Data Migration Tools Exposure to Multi DB - Multi Platform Migration.* * * *Skill: - DB Modeling* *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 Working knowledge of DB Design/Modeling techniques(Logical and Physical DB modeling) Ability to understanding of Conceptual Model Ad knowledge of Logical & Physical modeling Knowledge of one Modeling Tool (Like Erwin, ER Studio, Visio, Power Designer, SELECT etc) Implementation Experience of Logical & Physical Database Modeling for Small / Medium Application Databases* * * *Skill: - SSRS)* *Knowledge in Design, Capacity Planning and Architecting Reporting solutions Sound knowledge in building custom assemblies and using in the Reports Good knowledge in Performance Tuning of the High volume reports Knowledge in programming with extension APIs provided by SSRS Good knowledge in Troubleshooting Reporting Issues.* *- Thanks...* Ramesh Reddy Direct: 201-616-7001 Email: [email protected] *G-talk: *ram.sourceone *Yahoo:* ram_bnice -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" 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/oracle-projects?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
