Oracle Database Administrator - Pune, India - Tenet Computer And Communication Pvt

Tenet Computer And Communication Pvt

Verified Company

Pune, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

1. Knowledge of Different Oracle Releases

Installation of Oracle Software, Silent Install, Binary copying from existing server, re-linking of Oracle Home
Database Creation, manual and through Database Configuration Assistant
Create / Alter / Drop database objects viz. Tablespaces, Schemas, tables, views, indexes, Materialized Views, Procedures, functions, packages.
Setting Archivelog / No archivelog mode
Knowledge of different type of Indexes (Normal, Bitmap, Function Based, Composite indexes)
Database Backup / Recovery through Export, Import, RMAN
Use of utilities like TOAD, SQL Developer, SQL Loader etc.
Making Tablespaces / Data Files Online / Offline.
Use of Data Dictionaries, gather different statistics (table / system / dictionary / database)
Startup and Shutting Down database / listener,
Different Open Mode of databases, viz, mount, read only
Database Reorganization
Database Upgrade / Migration
Modification of Instance Parameters in / spfiles
Acquaintance of using Oracle Support, creation of SRs etc.
Knowledge of Basic Unix / Linux command viz. cp, mv, rm, mkdir, chown, chmod, vi editor etc
Knowledge of Windows
Performance Tuning (Query Tuning & Instance Tuning)
Generation and Interpretation of AWR and ADDM Reports