Oracle DBA (Oracle database admin))

Senior Oracle Database Admin (Oracle DBA)

experience:: 7+ years

location: Chennai

immediate joiners preferred

JD:

Responsible for Pre-installation tasks, installing Oracle DB and Patch Mgmt.

Should have strong knowledge on Database Upgrade, Migration, Patch Installation and Implementation.

Responsible for installations and configuration Oracle Database 12c/19c on Unix platform in standalone and RAC environment.

Specialized in Oracle RAC, good understanding of complexity of RAC Architecture across Servers, OS, network, storage layer.

Troubleshooting node eviction.

Strong knowledge on ASM and disk management.

User / Schema Creation, User Management, granting Roles and Privileges and creating profile.

Strong Knowledge on database architecture and transaction management.

Strong knowledge on schema and tables refresh by using data pump, and different methods in data pump.

Cloning of Production Instance to UAT/Dev.

Strong Knowledge on RMAN Backup & recovery management and troubleshooting the backup issues.

Finding of ORA-Error in the alert log file, Archive all alert logs to history.

Review contention for CPU, memory, network, and disk resources, generating statistics.

Strong Knowledge on AWR,ADDM reports, explain plan monitoring, analysis and troubleshooting.

Should have SQL tuning skill and experience at refactoring SQL queries to improve performance.

Should have knowledge on Database Connectivity issues, slow response, operations timed out, Database incident and error resolution.

Ability to diagnose the performance issues from SQL to Application to Database to System to Storage

Excellent problem-solving skills, should be able to transverse across infrastructure layer to diagnosis issues.

Write and troubleshoot shell scripting, SQL and PL/SQL Scripts.

Automation through GITHUB.

Redis,PostgreSQl & MongoDB Administration.