Location : Bangalore/Mumbai

Individual should be Graduate in IT or Science background with a minimum of 4-5 years of relevant experience working in a 24/7 environment.

The Oracle DBA is responsible for installation and technical configuration of the Oracle databases in multiple environments. The Oracle DBA provides systems and database administration for the Oracle Technical environments, and applies necessary patches and upgrades, managing backups for the environment.

Skills needed:
-Must have good knowledge on Oracle Architecture, conduct complex ORACLE database systems technical reviews to improve performance, resource utilization and integrity.
-Provide Oracle Technical support for the Project 
Investigate and resolve problems arising in all aspects of the ORACLE environment.
-Investigate, and provide solutions to, technical issues concerning the management and utilization of ORACLE software products.
-Liase and manage client’s satisfaction on technical issues related to Oracle Database.
-Good understanding of Oracle administration 12C/19C in single instance / RAC environment
-Managing & Trouble shooting issues in RAC/Single instance environment.
-Oracle Patching (PSU& CPU) in RAC/Single instance environment
-Strong knowledge and experience on Database Cloning /Data refresh from one environment to other


Mandatory Technical Skills 
-Good understanding of Oracle administration on  12C/19C environment on
1)Creation of Database/Schema
2)Granting required privileges
3)Checking various logs like alert log / listener.log.
 RMAN backup and recovery concepts - Duplicate, Clone, hot, cold and archive log 	backup concepts
Good in ASM (Automatic Storage Management)
4)Pre-checks for adding Diskgroup
5)Creation of Diskgroup.
6)Mount and Dismount of Diskgroup.
7)Worked on DataGaurd (Physical Standby Database) and Data guard configuration.
8)Achieve log management 
9)Knowledge of troubleshooting and performance related issues.
10)Taking AWR report
11)Analyzing the AWR
12)Partitioning of tables
13)Database Compression
14) TKPROF 
15) Knowledge on patching / Migration (OPATCH,EXPDP,IMPDP)
AIX / UNIX Operating System and its facilities & Knowledge on Shell scripting


Experience & Educational Qualification
-Minimum of 4 to 5  Years of  Large Oracle Database Administration on  11g/12C/19C
-Must be a Graduate Must have Oracle DBA Certification on 11g/12C/19C