Logo of Huzzle

Home

Matches

Explore

Manage

Oracle Database Administrator

image

Virtusa

1mo ago

  • Job
    Full-time
    Senior Level
  • Software Engineering
    IT & Cybersecurity
  • Pune

AI generated summary

  • You should have 7+ years as an Oracle DBA on version 12c, AWS experience, performance tuning skills, and expertise in RAC, Grid, ASM, backups, and mentoring juniors. Good communication is essential.
  • You will manage user setups, performance stats, backups, tuning, and database objects. Work with RAC and ASM, support team members, and ensure database integrity and reliability.

Requirements

  • Resource having 7+ experience and strong working knowledge as Oracle Database Administrator preferably on latest Oracle version 12c using RHEL 7 or 8.
  • Good Communication Skills.
  • Should have worked in a demanding environment with limited time.
  • Hands-on Knowledge of AWS is mandatory.
  • DevOps will be an added advantage.
  • Expertise in creating users, providing quotas, roles, privileges, profiles, etc., import & export, data pump (expdp/impdp) utilities.
  • Expertise in collecting performance statistics using AWR, Analyzing by using ADDM (Automatic Database Diagnostic Monitor), viewing Pre & Post execution plans using TKPROF (Trace Kernel Profile) utilities, like Explain Plan, Auto Trace and SQL Trace.
  • Strong knowledge of backup & recovery, Performance Tuning, patching and Database cloning.
  • Work with cross-cultural, multi-national teams; strong problem-solving skills
  • Hands on knowledge on Creating and managing database objects like tables, views and indexes.
  • Finding and re-validating invalid database objects
  • Knowledge and expertise working on RAC(REAL APPLICATION CLUSTER)
  • Expertise in Grid Administration and ASM administration using Oracle Cluster ware
  • Expertise in Backup/Recovery using RAC.
  • Groom junior resource so that the resource can support Critical activities independently in their absence.

Responsibilities

  • Expertise in creating users, providing quotas, roles, privileges, profiles, etc., import & export, data pump (expdp/impdp) utilities.
  • Expertise in collecting performance statistics using AWR, Analyzing by using ADDM (Automatic Database Diagnostic Monitor), viewing Pre & Post execution plans using TKPROF (Trace Kernel Profile) utilities, like Explain Plan, Auto Trace and SQL Trace.
  • Strong knowledge of backup & recovery, Performance Tuning, patching and Database cloning.
  • Work with cross-cultural, multi-national teams; strong problem-solving skills.
  • Hands on knowledge on Creating and managing database objects like tables, views and indexes.
  • Finding and re-validating invalid database objects.
  • Knowledge and expertise working on RAC(REAL APPLICATION CLUSTER).
  • Expertise in Grid Administration and ASM administration using Oracle Cluster ware.
  • Expertise in Backup/Recovery using RAC.
  • Groom junior resource so that the resource can support Critical activities independently in their absence.

FAQs

What is the minimum experience required for the Oracle Database Administrator position?

The minimum experience required is 7+ years in a similar role.

Is familiarity with Oracle version 12c mandatory for this position?

Yes, strong working knowledge of Oracle version 12c is preferred for this role.

What operating systems should candidates be experienced with?

Candidates should have experience working on RHEL 7 or 8.

Are AWS skills required for this position?

Yes, hands-on knowledge of AWS is mandatory for this role.

Is experience in DevOps considered an advantage?

Yes, having DevOps experience will be an added advantage.

What specific tasks are expected from an Oracle Database Administrator in this job?

The responsibilities include creating users, managing roles and privileges, using data pump utilities, performance tuning, backup & recovery, and database cloning, among others.

Are there specific tools mentioned for performance analysis?

Yes, expertise in collecting performance statistics using AWR, analyzing with ADDM, and using TKPROF utilities is required.

Will the Oracle Database Administrator be involved in training junior resources?

Yes, one of the responsibilities is to groom junior resources to support critical activities independently.

Is there a need for knowledge in RAC and ASM administration?

Yes, expertise in RAC (Real Application Cluster) and ASM (Automatic Storage Management) administration is essential.

What is Virtusa's approach to diversity and inclusion?

Virtusa is committed to equal opportunity and does not discriminate based on race, religion, gender identity, sexual orientation, or other protected statuses. All employment decisions are based on qualifications, merit, and business need.

image

Virtusa

Business transformation that lasts starts with Engineering First.

Technology
Industry
10,001+
Employees
1996
Founded Year

Mission & Purpose

Virtusa Corporation provides digital engineering and technology services to Forbes Global 2000 companies worldwide. Our Engineering First approach ensures we can execute all ideas and creatively solve pressing business challenges. With industry expertise and empowered agile teams, we prioritize execution early in the process for impactful results. We combine logic, creativity and curiosity to build, solve, and create. Every day, we help clients engage with new technology paradigms, creatively building solutions that solve their most pressing business challenges and move them to the forefront of their industry.