Looking for Data base (PL/SQL) Admin,Stamford,3 Months

HI

This is satya, - Recruitment and Resources from SancroSoft USA Inc.
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to satya@sancrosoftusa.com

YOU CAN CALL ME ON MY NUMBER:916-6715575

 

JOB TITLE: Looking for DB Admin(PL/SQL)

Location: Stamford

Duration:3 Months

Skills: Oracle Application Admin, PL/SQL(L4)-Database Programming Basics, DB Modeling.

 

 

The Job Description is as follows:

Oracle Application Admin-

Understanding of Database Architecture Concepts  Awareness on Application DBA Basics  Ability to understand Basic DB

Administration  Ability to understand DBA administration Tools  Working Knowledge of database specific data movement tools  Strong knowledge in

Database Architecture  Able to Implement Application DBA Skills (Like Application/ Development Support Admin)  Working knowledge on DB

Administration using Tools (OEM)  Ability to understand Database Upgradeability to understand Database Migration Process

 

PL/SQL-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 andimplement Collections, Multilevel

collections, Ref Cursors, Bulk Processing ,Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performance aspects inPL./SQL  Adv Database

Programming:  Ability to understand and implement Advanced Explicit Cursors, Managing Subprograms, Creating Packages, Oracle Supplied Packages, Adv.

Triggers, Managing Dependencies  SQL Developer Tool for Database Programming Tools Level 1 Usage  Adv Database Programming:  Ability to Tune PL/SQL

Applications for Performance, Using PL/SQL With Object Types, Performing SQL Operations with Native Dynamic SQL  Understanding of Database

Migration Process:   Understanding of Database Upgrade:   Ability to work on Database Upgrade using PL/SQL  Ability to work on Database Migrations using

PL/SQLExposure to Data Migration Tools  Exposure to Multi DB – Multi Platform Migration

 

DB Modeling(L1)-RDBMS - 

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)  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.

 

 

 

 

Thanks & Regards

SatyanarayanaG

  

 The power of focus

SancroSoft USA INC

4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628
Phone : 916-671-5575 ,916-671-5561          || Fax: 916-200-0305
E-Mail : satya@sancrosoftusa.com || www.sancrosoftusa.com