Oracle DBA | Online Jobs | Optimhire

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


Job Type

Payroll


Positions

Software Consultant


Must have Skills

  • SQL Queries
  • Database Administrator - 2 Years
  • Oracle
  • SQL

6 - 7 K/Year USD (Annual salary)

Longterm (Duration)

Onsite Pune, Maharashtra, India

India


Bharat G

India