Oracle DBA

Position: Oracle DBA

No of Positions: 2

Job Location: Pune (Work from Office)

Experience Level: 3 Years to 4 Years

Notice Period: Immediate to 15 Days Comments: These are work from office openings. (Can go Hybrid depends upon management decision, but no commitments.)

Job Description

 Identifying and Removing locking and Blocking sessions

 Session tracing using SID

 Strong knowledge of writing SQL Queries and joins

 Stats Gather - Table , Index , Partition

 Understanding execution and implementation of Plan Fix and SQL Profiler

 Monitoring SR's, Alert Logs, TNS Logs

 Raise Change request , Prepare Plan of Action

 Object compilation

 index rebuilding, Table ReOrg

 Implementation of compression

 DB Links creation

 Generation of various reports on database

 Preparation of various reports - SR, SOS reports, Incident reports,

 Configuring Rman backups

 Resolve MRP problems for DR, DR switch over , Failovers

 Managing Flashback, DR Drills, DG Broker

 Database User and Role Management

 ASM Space Management - Adding / Release space

 Export / EXP , Import / Impdp of tables

 Understanding on SQLT , AWR , ASH and other reports

 Knowledge of Oracle Enterprise Manager