@@@@ Oracle Application DBA @ New Jersey @@@@

Oracle Application DBA @ New Jersey

Duration: 6 Months

 

 

-->Oracle Application Admin(L2)-Understanding of Database Architecture Concepts  Awareness on Application DBA Basics  Ability to understand Basic DB Administration  Ability to understand DB 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 Upgrade Ability to understand Database Migration Process

 

-->PL/SQL(L4)-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  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/SQL Exposure 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  Woking 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 (LikeERWin, ER Studio, Visio, Power Designer, SELECT etc)  Implementation Experienceof Logical &  Physical Database Modeling for Small / Medium Application Databases.

 

 

Thanks & Regards,

N.Sivakumar || siva.n@terminalcontacts.com || 813 600 5429

 

G-Talk: sk.us.staffing

Yahoo IM: sk1usstaffing