Oracle DBA - L2

JOB Description For Oracle DBA L2 Customer Name

MSIL LOCATION

Gurgaon DOMAIN

Oracle Level (L1/L2/L3)

L2 Required Relevant Domain Experience

4-5 Years Job Type (Onsite/Remote)

Onsite Shift details (General/ 24X7)

24X7 Qualification

B.E/B.Tech/ BCA Certifications Required if ANY

ITIL Certified, OEM Certified Specific Remarks/Requirement by customer

Oracle Apps knowledge will add an advantage Budget

12 LPA Certifications preference

OEM Certification like OCP (Oracle Certified Professional)

Role Purpose

We are looking for a passionate candidate who can perform Database Administration tasks in Oracle Database.

Designs and builds simple to complex database structures from data models. Installs configure and patches in Oracle. Implements HA and DR systems using Data guard and RAC.

Job Responsibilities

Installing and upgrading the Oracle server and application tools

Allocating system storage and planning future storage requirements for the database system

Creating primary database storage structures (tablespaces) after application developers have designed

an application

Working knowledge of RMAN Data guard RAC Data pump ASM Networking Oracle 11G Performance Tuning

SQL Database Grid CRS management Firewall.

Change/Release Management and maintenance and management of databases using Oracle Enterprise

Management Grid Control.

Complex database migrations. Working knowledge with offshore partners and various cultures.

Knowledge of the ITIL framework.

Database: grant access rights, manage authorizations.

OS Service Monitoring: Monitoring OS Services of the Applications (Up/Down).

Database structure creation at the schema level and active reporting (data collection and report build).

Install Database Server Security based upon Service Level.

Respond to database security alerts.

Applying simple/repeatable Security Patch. Regular Oracle DB admin password change.

Process Monitoring: Monitoring OS processes of the DB (Up/Down). Service Monitoring: Monitoring OS

Services of the DB (Up/Down).

Upgradation of Database version from existing to the latest recommended version in coordination with

MSIL domain owner.

Database System Performance monitoring gathering d report build (buffer hit ratio, etc. for reporting).

Work in close coordination with the application and other teams to resolve issues and optimize the database performance.

Facilitate new database deployments, execute and manage cronjobs and perform another routine database

administration activities from a remotlocationson.

Monitoring and management of table space usage, buffer cache hit ratio, no. of segments approaching

max extent, chain counts index usability, invalid object counts, etc

Technical Skills/Knowledge requirement

• Oracle Server Installation and Upgrades
• Storage Allocation and Planning
• Oracle Enterprise Manager (OEM) and Grid Control