Urgent Opening for Oracle Developer- South Delhi

---------- Forwarded message ----------
From: india@pmsconsulting.in
Date: Sat, Jan 30, 2010 at 4:11 PM
Subject: Urgent Opening for Oracle Developer- South Delhi
To: me
Hi!!
We have an Urgent Opening for Leading MULTINATIONAL General Insurance Company as ORACLE Developer.
Job Title-> ORACLE Developer
Package-Negotiable
Postion Based at-South Delhi

• Creating Complex queries using functions. Creating triggers.
• Involved in creating packages, function, procedures.
• Creating Open Reports and complex queries for the reports using joins properly.
• Creating complex Procedures for Transactional database using new Oracle 10G-11!
• Concepts. Oracle 10G Installation on Windows as well as Linux. DBA Activities like Database Daily Backup, Replication. Creating Shell Scripts for Backup. Creating Cronjobs.
• Reading explain plan and tune the query accordingly.
• Remove loops from the procedures.
• Use of global temporary table to remove complex loops.
• Analyzing and designing of the Physical and Logical Database.
• Effective use of index like bitmap, function base index, primary & foreign key to access table data fast.
• Involved in writing script for SQL and PL/SQL.

Implemented features such as materialized views for better performance of snapshots, Autonomous Transactions etc.
Tuning application and optimization of queries.
Designed the database based on requirements of the system.
Created the database, table spaces, tables, indexes and other database objects.

Pls send ur resume with ur current CTC
Thanks & Regards
Kanika
india@pmsconsulting.in
www.pmsconsulting.in