Oracle Database Administrator

Computer Power Group Inc
  • Bangalore
  • 10-15 lakh
  • 7-10 years
  • 267 Views
  • 17 Nov 2016
dfdf

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

Roles & Responsibilities:
To install and maintain the Internal Database Server as demanded by the business needs
To extend the required technical support for all issues related to internal production Database(s) and also during the product development, testing and release phases
To define, monitor the Database performance, benchmark the performance and document the results
To be able to configure and optimize the DB to manage horizontal (clustering) and vertical (data model) scalability
To configure, tune and optimize the Oracle Database Server installation and be able to configure the Host Operating System (Windows, IBM AIX, Red Hat Linux)
To maintain, document and improve the ESL Scripts (existing and new automatic scripts for installation and database maintenance)
To perform DB Backup and Replication activities, manage Core-Database-Changes
To work closely with Database Architect team to achieve the following
o Database manipulation (create new tables, modify existing tables, create new indexes, create/ modify schema, role, privileges, data files and tablespace and other DB related tasks)
o Define and document the required DB install process as part of the MF product installation and configuration
o Help delivering proof of concepts meeting customer business requirements
o Review and improve the SQL queries as required by the business
o Evaluate and Test the new Oracle releases
o Define the required Oracle patch level (based on Oracle support and our MF requirement)
o Define, monitor and manage the required HW sizing and share the same with the stakeholders
o DB Partitioning and Implementation
Strong Knowledge of Oracle Database (11g), SQL, PL/SQL, RAC, DB Partitioning, Performance, Tuning, High Availability, Mirroring, Replication setup and maintenance with very good understanding of Security Models, Oracle Vault, VPD, OLTP, DWH and Database Management Tools
Preferably an Oracle Certified (OCP) Database Administrator
Minimum Level of Education:
A degree in IT / Computer or equivalent stream


Job Posted By

Naveen Ch
Senior Lead Recruiter

About Organisation

Computer Power Group Inc