Database Administrators-C-DOT-New Delhi

Full–time
Roles and Responsibilities

1.

Essential job duties include, but are not limited to, the following:

Installation, Configuration and Administration of Oracle and mysql Databases

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

Creating primary objects (tables, views, indexes) once application developers have designed an application

Modifying the database structure, as necessary, from information given by application developers

Enrolling users and maintaining system security

Controlling and monitoring user access to the database

Monitoring and optimizing the performance of the database

Performance Tuning

Point-in-Time Backup and Restore and maintaining archived data on tape

Replication and DR methodology Planning and Implementation

LOCATION : Delhi
• Qualifications

1.

B.E. /B.Tech /MCA (ECE/IT/CSE)
• Experience

1.

minimum 5 years in the areas defined (Certified Professionals in the area of Database Administration desirable)
• No. of Persons

1.

2
• Skill Set and Experience

1.

Should have sound knowledge and experience of installation and administration of large Oracle 11GR2 (RAC) Databases ASM, RMAN,ADG etc.

2.

Should have the knowledge and Experience of the following features of Oracle 11GR2:

a.

ASM

b.

RMAN(Backup and Recovery)

c.

ADG

d.

Oracle Enterprise Manager

e.

Real Application Cluster

f.

Partitioning

g.

Should be having sound knowledge and experience to optimize SQL queries

h.

Oracle performance tuning

i.

Point-in-time backup and recovery

j.

Roll back

3.

Should have the knowledge and experience of installing and administering MySQL enterprise Edition as well as MySQL community edition

4.

Should have knowledge and experience in the following areas of MySQL

a.

Creating Databases with InnoDB and MyISAM

b.

Setting up and Administration of MySQL NDB Clusters

c.

Configuration and troubleshooting Master Slave Replication

d.

Configuration and troubleshooting Multi Master Replication

e.

Configuration and troubleshooting Mysqldump backup

f.

Configuration and troubleshooting MySQL Enterprise Backup

g.

Installation, Configuration, troubleshooting and managing multiple databases using MySQL Enterprise Manager

h.

Should be having sound knowledge and experience to optimize SQL queries,

i.

MySQL performance tuning

j.

Point-in-time backup and recovery

k.

Roll back

5.

Good knowledge of scripting languages