*Position : **DB2/UDB consultant*** *Location : NYC, NY*
*Duration : 6 months* *Rate: 260/ day* *Required:* · 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 SQL Constructs · Ability to understand and implement Data Types, Basic SQL SELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views · *Query Tuning Basics: * · Understanding of SQL Tuning concepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Trace Basics, Indexes and Basic Access Methods Basics, Introduction to the Optimizer Basics, Gathering Statistics Basics · · *Adv SQLBasics:* · Able to understand and implement Datetime Functions, Advanced Subqueries, Hierarchical Queries, DDL & DML Extensions, Transaction Management · Tools Level 1 usage · · *Database Programming Basics:* · Ability to understand and implement Declaring Variables, Executable Statements, Control Structures, Composite Data Types, Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Creating Database Triggers · · *Adv Database Programming:* · Tuning Methodology, SQL Statement Processing, Capturing and Understanding Query Plan, Introduction to the Optimizer, Indexes and Basic Access Methods, Gathering Statistics · 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 · SQL Constructs Ability to understand and implement Data Types, Basic SQL SELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions, Sub- Queries, Creating & Managing DB Objects, Manipulating Data (DML),Constraints, Views · · *SQL Query Tuning Basics:* · Understanding of SQL Tuning concepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Trace Basics, Indexes and Basic Access Methods Basics, Introduction to the Optimizer Basics, Gathering Statistics Basics · · *Adv SQL Basics:* Able to understand and implement Datetime Functions, Advanced Subqueries, Hierarchical Queries, DDL &DML Extensions, Transaction Management Regards Ejaz Talent Acquisition Manager Symphony Enterprises LLC 412 250 7227 (Tel) | 412 774 9230 (Fax) [email protected] | www.symphonyenterprises.com WMBE & NWBE Certified Company A Member of Women's Business Enterprise National Council (WBENC) and National Association of Women Business Owners (NAWBO) -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/us_itgroups?hl=en.
