Hi *Please send resume at [email protected] *
*Job Title: Oracle Data Architect Location : Boston ,MA Duration : 6+ Months * *ORACLE Data Architect/Consultant*- 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 and TKPROF Basics, Indexes and Basic Access Methods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics, Optimizer Hints Basics, Gathering Statistics Basics • Adv SQL Basics: Able to understand and implement Date time Functions, Advanced Sub queries, 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: Ability to understand and implement Collections, Multilevel collections, Ref Cursors, Bulk Processing, Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performance aspects in PL./SQL • 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) *Please respond with Resume, Rate and Phone numbers. Make sure the skills match the requirement.* *Thanks & Regards,* *Lex Hall Technical Recruiter* TEKTREE LLC., 3104 Drummond Plaza ; Newark , DE 19711 Contact no.: 302 248 8013; Fax: 302 397 2097 Email: [email protected] <about://mc/[email protected]> Website: www.tektreeinc.com -- You received this message because you are subscribed to the Google Groups "ORACLE DWH DBA" 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/oracle-dwh-dba?hl=en.
