Dear Folks, Please share profiles to *[email protected]* <[email protected]>
*Position: Oracle - L4 - Tech Lead Position @ Stamford, CT || 6 Months* *Requirement Details:* *Position: Oracle - L4 - Tech Lead Location: Stamford, CT Duration: 6months* *Job Description:* 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 Ablility 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 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:* 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 Woking knowledge of DB Design/Modeling techniques(Logical and Physical DB modeling) SQL Constructs Ablility 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 & Mana *Thanks & Regards,* SK Sr. Recruitment - Executive [email protected] Javaji Systems Solutions 703 880 4214 -- You received this message because you are subscribed to the Google Groups "Oracle Users" 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-users?hl=en.
