Screening

Name
Total IT Exp			2 years 1 months
Relevant Exp in Oracle		2 years 1 months
Current CTC			3.9 Lakhs
Expected CTC			5.0 Lakhs (Negotiable)
Notice Period			2 months
Company Name			Wipro Technologies
Contract / Permanant			Permanant
Designation			Production Support Engineer
Role				L1, L2 Production Support
Team size				20+
Telecom / Insurance			Yes
SQL				3.5/5		 70%		80%
PLSQL				3.5/5
UNIX SHELL SCRIPTING		3.5/5
PERFORMANCE Tuning		3.5/5
Relocation				Yes
Contract to Hire			Yes
Bank Statement			HDFC Bank
Form 16				Yes
PF				Yes
Production Support			Yes
Development			Yes
Reason for Change			Career Growth
official email id			first_name.last_name@wipro.com
Certification			OCA, OCP
Versions				10g, 11g, 12c


Tools

Tools Used

Oracle Developer		SQLPLUS, TOAD, SQL Developer
UNIX			Putty, F-Secure SSH Client
Ticket tracking		Service Now, ITT, JIRA, Remedy
Version Control		CVS, SVN, VSS
Data Modeling		ERWIN, VISIO
Job Scheduling		Autosys
Database			Oracle, Sybase
Server			Oracle Solaris 10
Application Server
Middleware		Oracle WebLogic Server 12cR2 (12.2.1)

Name
Company name
Phone		Extn
email
Job Description

89399 15577

Performance Tuning

Explain Plan
DBMS_Profiler
Automatic Workload Repository (AWR) 
TKProf
Index
Table Partition
Hints
Parallel Query
Bind Variables
Pipelined Table Function
Query rewrite
Global Temporary table
Materialized Views
XML
Bulk Collect
Bulk Bind
Gather Table Statistics
Rebuilt Index
Direct Path loader
Conventional Path loader
NoLogging
V$SQLTEXT, V$SQLAREA, V$SQLPLAN
Table Fragmentation
Last Analyzed - Index, Table, Schema, Database