Senior Oracle Database Administration Oracle DBA

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/1+c 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