Job Description

Job Profile :

Database Administrator, Oracle

Job Location :

Gurugram

Experience Required :

4-5 yrs

:

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