Hi Friends,
*Experience/Skills:* - Should be able to architect a solution in this technology area for a given problem statement. In depth knowledge of multitier architecture. - Should be able to design and architect solution around J2EE, should be well versed with stacking and layering of architecture modeling, should be conversant with decision making in terms of technology comparison with J2EE technologies - Should be able to understand customer business requirements and propose optimal solutions around J2EE technologies focusing on simplifications, virtualization, aggregation and automation. - 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, Dealing with collation sequences, Using scalar and aggregate functions, Multiple Table Queries Tools Level 1 usage T-SQL Programming - Database - Programming Basics: Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Cursors, Error Handing, Creating Procedures and Creating Database Triggers Adv Database Programming: - Ability to understand and implement programming with locks and isolation and working with temporary tables. 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) 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, Dealing with collation sequences, Using scalar and aggregate functions, Multiple Table Queries Tools Level 1 usage Adv SQL & SQL Tuning Techniques: - Able to implement Executing full-text searches, Managing Data and Concurrency, Writing Scripts and Batches, querying System tables - Ability to implement Tuning Concepts/Techniques like Show Plan, Managing Optimizer Statistics, Indexes, Plan Stability, Application Tracing Tools SQL Access Advisor - 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 Able to use SQL Server Query Analyzer for Development Able to use SQL Server Enterprise Manager for Development SQL Constructs *Resumes with the following information will be given preference.* * * *Full Name:* *Current Location:* *Relocation:* *Availability:* *Work Authorization in US:* *Contact Number:* *Email:* *Rate on C2C:* * * *Please ensure all candidates have all skills listed under "Required Skills" in their resume.* *Reply - pa...@everestcom <pa...@everestcom.com>.com* <http://www.linkedin.com/pub/pavan-kumar/1b/75b/13a> -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to sap-a...@googlegroups.com. To unsubscribe from this group, send email to sap-abap+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.