Development DBA, Golden Gate - Bengaluru, India - BIZEXPRESS ADVISORS PRIVATED LTD
Description
If interested please share your resume on
Job Title : Development DBA with Golden Gate and Exadata experience.
Location : Bangalore / Gurgaon/Hyderabad
Experience : 8+ Years.
Shift: Flexible Support rotational shift
Budget: 28-34LPA.
Job Description:
Monitoring Exadata components like Database Server, Storage cells Server,
IB Switches, PDU, and ZFS Storage through OEM13c and using ILOM.
Proactive monitoring of production DBs and provided Minimal Time
Resolution.
Experience with Implemented Exadata new features like Smart scan, Flash
cache and flash log, IORM and Storage indexes
Experience using cellcli or dcli to manage Exadata storage server objects.
Provide and implement performance and tuning recommendations for all
components of the Exadata machine.
Perform Exadata storage servers upgrades and patching.
Monitoring Exadata storage servers with cell metrics alerts and active
requests.
Plans for backup and recovery of database information and maintaining hot
backups, cold backups, and also include RMAN backup.
Experience in Configuring & Monitoring an Exadata Database on OCI
console
Experience in Creating an Exadata Cloud at Customer Instance
Mandatory Skills:
8+ years of experience
Experience in Oracle 9i, 10g, 11gR2, 11gR2 RAC,
Oracle Grid Infrastructure, ASM & RAC
Database design and modelling
Oracle Exadata
Oracle RAC
Oracle GoldenGate
Oracle Cloud
Oracle Autonomous Database
Oracle Data Management (Partitioning, Compression)
Experience in Database design is important for this role
Develop and maintain logical and physical data models to support application requirements.
Strong expertise in creating and managing the schema for applications,
including table design, index optimization, and data partitioning.
Knowledge of Query plans, different types of index scan, hash/nested loop etc.
Experience with Implemented Exadata new features like Smart scan, Bloom filter, Flash cache and flash log, IORM and Storage indexes
Strong expertise in Oracle Golden Gate for real-time data replication.
Good Knowledge of Oracle Architecture GoldenGate
Utilize Oracle Golden Gate to manage Bi-Directional databases effectively.
Knowledge of uni direction, bi-directional, conflict resolution, and out of sync issues
Hands-on Experience in troubleshooting Oracle RAC issues
Hands-on experience in setting up Oracle RAC configuration and tuning
Knowledge of
Background processes
Ocr , olr and voting disks internals.
Scan listner internals
Services configuration TAC/AC drain timeout etc
Cache fusion , node eviction , split brain syndrome.
Oracle wait events , real experience use cases
Hands-on experience and good knowledge of Performance Tuning and query optimization.
Education & Certifications:-
B.Tech / M. C.A (or) any other graduation.
Additional notes for candidates to have hands on and well versed on below pointers.
This position is for Development DBA with Golden Gate and Exadata experience.
1. Database design (IMP)
2. Table/Index Partitioning (IMP)
3. Query plan , different types of index scan, hash/nested loop etc.
4. Exadata concepts: Smart scan Bloom filter Flash cache configuration
5. Golden gate Uni and Bideretional Conflict resolution Out of sync issue
6. RAC and Tuning Background processes Ocr , olr and voting disks internals. Scan listner internals Services configuration TAC/AC drain timeout etc Cache fusion , node eviction , split brain syndrome. Oracle wait events , real experience use cases Query / operation is slow ? how u handle.