Job Summary
Oracle RAC, ASM, Dataguard and Goldengate Administration:
- 8+ Years of experience in database architecture design, administration, migration, Integration Design, managing Oracle Dataguard, RAC, ASM, Goldengate.
- Experience working in Oracle databases on AWS/Azure/OCI will be added advantage.
- Should have Project Implementation, transition, transformation experience in Oracle Single instance, Oracle RAC with ASM and DR.
- Excellent written and verbal communication skills.
- Ability to prioritize, multitask and work with onshore and offshore team’s skills desired.
- Positive attitude, problem solving skills and self-initiative are must qualities.
- Oracle installation, configuration, administration of ASM, Cluster control.
- Experience with VLDB (Very Large Database) environments.
- Strong SQL skills including the ability to rewrite complex queries to improve performance.
- Should have Shell scripting skills.
- Extensive experience in Database Backup, restore and recovery.
- Extensive experience in Oracle DR build, configuration, and administration.
- Extensive experience in installation, configuration, agent deployment, and creating database monitoring alerts baseline in Oracle OEM 12c/13c.
- Experience creating installation scripts and procedures.
- Experience in Table partitioning, materialized views, and replication.
- Extensive experience in analyzing and applying Oracle patches.
- Extensive experience in database upgrade from 12c to 18c/19c including ASM, RAC.
- Database monitoring setup and integration of database alerts with ticketing tools.
- Database security enhancement.
Key Responsibilities
Oracle Exadata Administration
- Administration of Exadata Storage cells
- Exadata process like cellsrv, MS, RS
- Good knowledge of cellci, dcli and other Exadata specific utilities
- Startup and shutdown of Storage and compute nodes
- Exadata component monitoring and alert handling
- Database node/Cell node/Infiniband image upgrade.
- Follow up with Exadata hardware Product support on any disk replacement, upgrades and patching.
- Installing OEM agents on Exadata db nodes and enable monitoring for the same.
- Provide and implement performance tuning recommendations of all components in Exadata database machine.
- Generating exacheck, sundiag, and OS Wathcer report for performance issue in exadata.
- Resource management by using Exadata database feature.
- Experience in / mountpoint expansion in Exadata.
- Proactive health checkup of cell storage servers, switches on Exa machine.