Oracle DBA - Technical Specialist
Mindtree
Bangalore
3d ago

Description : Responsibilities :

Responsibilities :

  • Planning for Production Storage and Capacity Management.
  • Creation & managing PostgreSQL schema, tables, tablespaces and users, roles & groups.
  • Performance tuning, Query tuning by generating and explaining plan for SQL queries.
  • Expert in DBA functions like managing databases, backup & restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability.
  • Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.
  • Analyze, recommend, and implement configuration for Optimized Performance.
  • Ability to plan hardware capacity requirements for storage, memory and CPU Cycles.
  • Ability to configure and troubleshoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.
  • Understanding of UNIX environment with shell scripting.
  • Trouble shooting and resolving database issues.
  • This role may entail shift & after-hours support on an on-call basis.
  • 6 + years of experience working on Oracle 11g and 12c database environments
  • Provide technical expertise in database administration to a multi-site operations / support team, while liaising with SVB SMEs
  • Experience with database installations, upgrades and DB refresh
  • Experience in applying PSU patches on stand-alone and RAC databases
  • Should be knowledgeable with shell scripting
  • Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Should have working knowledge of Oracle RMAN Backup / Recovery, RMAN DB cloning, RAC maintenance, GRID and Dataguard management
  • Experience in implementing operational automation using scripts
  • Must have strong analytical skills and effective interpersonal communication
  • ITSM - ticketing tool and ITIL process knowledge
  • Skills Required :

    Oracle DBA, RAC, NO SQL

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form