Oracle DBA

Chennai
Posted 10 months ago

Job Description

Oracle DBA:
Strong Oracle DBA experience utilising versions 11g and 12c. Installation of Oracle 11g and 12c Configuring the RAC and Data guard Database Patch Installation and Upgrade. Database Space Management. Experience in Creating database, schemas and tables based on the application needs. Experience in Creating Triggers, sequence, synonym and functions based on the application needs. Periodic Checking the Health of the Database, recommending changes and makes the changes accordingly. Monitor the Alert log file for errors and fixing the issues, if any.

 

Backup and recovery strategies:
EXPDP/IMPDP
RMAN backup and restore.
RMAN for Cloning, Stage database refreshes, DR creations.
Exposure to High Availability Concepts (RAC, Data Guard)
Monitoring DB lock contention, long running queries. Resource usage monitoring.
Stats Gathering of Tables and Indexes.
Analysing AWR, ADDM and ASH reports.
Proactive monitoring, identifying areas that need to be improved in the application and database using EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, OEM Grid Monitoring.
Monitoring the database, Load on server & the log file for errors.

 

SQL DBA:
Installation SQL server 2012 and 2014.
Backup and recovery strategies.
Good exposure in Creating database and tables in SQL database.
Database Space management.
Exposure in Production support, High Availability Concept (Clustering, Mirroring, log shipping and always on)
Monitoring DB lock contention, long running queries. Resource usage monitoring.
Stats Gathering of Tables and Indexes.
Proactive monitoring, identifying areas that need to be improved in the application and database.
Monitoring the database, Load on server & the log file for errors.
Experience in DW: Nil
Experience in Performance tuning: 8 Years
Experience as Oracle DBA: 10.6″

 

Skills

Performance tuning, Oracle DBA and Datawarehousing

 

Education

B.E / B.Tech / MCA

 

Experience

8 to 15 Years

 

No. of position

1

 

Apply Online

A valid email address is required.
A valid phone number is required.