ORACLE Tech Lead(T89278) Wipro Technologies

Summary

Experience: 6 - 10 Years

Location:

Pune

Education: UG - B.Tech/B.E. - Computers PG - Post Graduation Not Required

Industry Type: IT-Software/ Software Services

Role: Team Lead/Tech Lead

Functional Area: Application Programming, Maintenance

Posted Date: 27 May

Desired Candidate Profile

Qualification: BE / BTech

Experience: 6-10 YEARS

Skills: 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 Datetime 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 inPL./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 , Normali

Area of expertise: Oracle

Job Description

Roles and Responsibilities: DB Modeling, Scripting, racle

Skill & Job Requirements: " Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model, etc Ability to understand basics of DBDesign , Logical modeling , Normalization & De-Normalization Techniques Working knowledge of DB Design/Modeling techniques(Logical and Physical DB modeling)Ability to understanding of Conceptual Model Adv 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. Implementation experience of Conceptual, Logical & Physical modeling for Large/ complex enterprise application Database(s). Able to implement Database Reverse Engineering & Re-engineering Techniques. Ability to work with more than one modeling Tools (Like ERWin, ER Studio, Visio, Power Designer, SELECTetc)""[Maintenance of Shell scripts] - Maintenance and enhancements of shell scripts- Debugging and trouble shooting the shell scripts - Ability to develop scripts interfacing with databases - Ability to handle large scripts that in-turn use multiple executables and external scripts - Error logging [Debugging] -Enabling debugging - Syntax Checking Shell Tracing - Using echo -Using Standard Error -Options for Debugging - Script Tracing - Conditional Debugging OR Perl- -Database Programming (DBI/DBD modules etc) - Installing and Using Perl Modules- C & Perl Interworking - Parsing Techniques - Multitasking with Perl ( fork, exec etc)

Keywords: ORACLE Tech LeadT89278

Company Profile

We are the first PCMM Level 5 and SEI CMM Level 5 certified IT Services Company globally. We provide comprehensive IT solutions and services, including systems integration, information systems outsourcing, package implementation, software application development and maintenance, and research and development services to corporations globally.

In the Indian market, we are a leader in providing IT solutions and services for the corporate segment in India offering system integration, network integration, software solutions and IT services. In the Asia Pacific and Middle East markets, we provide IT solutions and services for global corporations. We also have a profitable presence in the niche market segments of consumer products and lighting.

Our ADSs are listed on the New York Stock Exchange, and our equity shares are listed in India on the Bombay Stock Exchange, and the National Stock Exchange. For more information, please visit our websites at www.wipro.com and www.wipro.co.in

Wipro Technologies is a global provider of consulting, IT Services, and outsourced R&D, infrastructure outsourcing and business process services. We deliver technology-driven business solutions that meet the strategic objectives of Global 2000 customers. With over 25 years in the Information Technology business, Wipro is the largest outsourced R & D Services provider and one of the pioneers in the remote delivery of services.

We deliver unmatched business value to customers through a combination of process excellence, quality frameworks and service delivery innovation. Wipro is the Woorld's first PCMM, CMM and CMMi Level 5 certified software Services Company and the first outside USA to receive the IEEE Software Process Award. We are the first services company to embrace Six Sigma, lean manufacturing and factory model concepts to software engineering.

We have a wide geographical diversity of operations with over 40 development centers and 10 near shore centers spread across India, Japan, China, Eastern Europe, France, Austria, Sweden, Germany, UK and USA.

Contact Details

Company Name: Wipro Technologies

Website: http://careers.wipro.com

Executive Name: Wipro Technologies

Address: Not Mentioned

Telephone: Not Mentioned

Reference ID: Job Code T89278