Description
Job Brief Summary
JD - Min 3+ years of experience in Oracle database administration in production environments on Unix, Windows and Linux OS.
Capable of performing Database Administration tasks independently in Oracle 10g, 11g, 12c and 19c.
Db Upgrade experience.
Installation and troubleshooting in RAC and Grid.
Replication via Goldengate and Data Guard
Installation of Oracle software on Unix platform.
Database Lifecycle Management - Database creation, setup & decommissioning.
Database event/alert monitoring, space management, user management
Database upgrades, migrations and cloning
Database backup, restore & recovery using Datapump or RMAN
Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
All above applicable to infrastructure which has standalone and RAC databases using file-system based or ASM based storage.
This requires the ability to analyze, optimize and tune complex SQL queries.
Deploy and maintain high availability and failover technologies such as Active Data Guard, RAC.
Create, clone and upgrade database environments to support implementation activities