Experience - 6 - 15 years
Job Description -
Core-Skillset : Mandatory-
- Oracle RAC experience in Production Environment : Install, Configure, Patch, [Upgrade], Backup, Support, & Tune Databases in Production.
- Oracle Dataguard / Standby in Production Environment : Configure, Role-Transition, Troubleshoot, Support in Production.
- Oracle Patching : Quarterly RU Patching for GI and DB Homes, One-Off patching, Patch conflict resolution.
- Oracle RAC Performance Tuning and troubleshooting in Production environment.
- Oracle DataPump and RMAN : Backup and Recovery.
Soft-Skillset : Mandatory-
- Triaging and managing Production Incidents : Should have good experience.
- Team player, willing to support and pitch-in when needed to offer support for late-night / emergencies.
- Should be able to support On-Call rotation every 3rd week, and what this means in a Prod Env (availability & restrictions when on-call).
Additional Skillset: Exposure and Familiarity-
- Background and experience with SQL Tuning.
Shell Scripting.
- Oracle TDE Encryption : HSM & Local, Implement, & Support in Production Environment.
- Oracle Network Encryption : Native and SSL/TLS.
- Managing Oracle Databases in SELinux environments.
- Experience remediating CVE / Security Vulnerabilities in Oracle Clusters.
- Willingness to learn & adapt to new technologies such as NOSQL DB Administration
Skillset [Optional], Beneficial-
Ability to participate and provide guidance during application design using Oracle Database : Table
Design, Concurrency, Indexing, Views, MViews.
Oracle GoldenGate Replication : Install, Configure, Upgrade, Support, & Troubleshoot
Oracle Auditing Experience.
Oracle Enterprise Manager : Use and Support
Oracle Centrally Managed User / OUD / OID.
Willingness to learn & adapt to new technologies such as NOSQL DB Administration
Unix / Linux OS Performance tuning.
Additional focus areas/questions
Hands on exp in RAC
Database encryption, in-transit encryption
How is database upgrade and migration performed and what were the steps taken
Major difference in older version of databases v/s 19 version
Process for Patching
Data guard patching
Primary & Secondary in Oracle RA
How to create services ONLY for Primary
How to create services ONLY for Secondary
How to move services from one node to other
Diff b/n failover & switch over
Different types of logs and explain those
Golden gate experience and how to administer golden gate using commands
Concept of Threads in RAC
Diff b/n Thread & Member
Skills : oracle patching,oracle dataguard,oracle rac,oracle datapump,oracle dba