Saturday, June 9, 2012

WIPRO | Administrator TIS-Database

Job Code: T154960
JOB Type: Fresher
Skills & Experience Required:
Skills: Oracle Admin , Database Administration
Experience Required(Description) : Database Administration(L1)-Entry level position. Works under close supervision to perform low-leveldatabase management tasks such as adding users, managing space etc.Participates in testing back-ups, ensuring maximum up-time and maximumperformance of database. Familiarity with basic administrative commands isexpected at this level. Front-line interaction with users to assist with lowlevel trouble-shooting requirements. Oracle Admin(L1)-Have Knowledge on Oracle Database Architecture ( Physical Database Structure,Logical Database Structure, Memory Structures, Background process etc), SQLPlusCommands, Basic Datadictionary views(like dba_data_files, dba_free_space,v$instance, v$session, v$process, etc) Be able to identify and kill Oraclesession (by identifying the process, spid). Startup and Shutdown Database andInstance Monitor Alert Log, Scheduled Jobs. Monitor the disk space in theserver and take action accordingly ( Including bdump, udump, cdump & archivelogdirectory). Troubleshoot Temp tablespace issues, Monitor CPU Load of theServer. Understand how connectivity is established between client and server.Perform Export & import.

 Roles & Responsiblities:
Entry level position. Works on allocated incidents/ problems on maintenance of hardware / software - servers, laptops, PCs etc. with high degree of supervision. Provides support for simple trouble shooting requirements. May be required to work as on-call support of in shifts to provide 24x7 type of support.



1 comment:

Holy_antony said...

wen is d intrvw???

Post a Comment