Oracle database administrator @ Magna Infotech

Experience in 24/7 environment.
Good knowledge on Oracle Architecture
Conduct complex ORACLE database systems technical reviews to improve performance
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
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
Good understanding of Oracle administration on 12C/19C environment on
Creation of Database/Schema
Granting required privileges
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)
a.Pre-checks for adding Disk group
b.Creation of Disk group.
c.Mount and Dismount of Disk group.
Worked on Data Gaurd (Physical Standby Database) and Data guard configuration.
Achieve log management
Knowledge of troubleshooting and performance related issues.
2.Taking AWR report
3.Analyzing the AWR
4.Partitioning of tables
5.Database Compression
6.TKPROF
knowledge on patching / Migration (OPATCH,EXPDP,IMPDP)
AIX / UNIX Operating System and its facilities & Knowledge on Shell scripting
Must have Oracle DBA Certification on 11g/12C/19C