Development DBA, Golden Gate - Bengaluru, India - BIZEXPRESS ADVISORS PRIVATED LTD

    BIZEXPRESS ADVISORS PRIVATED LTD
    BIZEXPRESS ADVISORS PRIVATED LTD Bengaluru, India

    1 week ago

    Default job background
    Full time
    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.