Hiring Database Administrator (Oracle, MongoDB, Redis) - Hyderabad

Database Administrator (Oracle, MongoDB, Redis)
Summary

We are seeking a seasoned Database Administrator possessing practical expertise in managing Oracle, MongoDB, and Redis environments. This pivotal role demands a professional capable of overseeing database monitoring, optimizing performance, ensuring high availability, and executing robust backup and recovery strategies. The ideal candidate will be adept at security management, capacity planning, and resolving complex production issues. Proficiency with OpenShift and Dynatrace is considered a significant asset for this position.

Experience: 4-9 years

Location: Hyderabad

Mode of Interview: F2F

Must-have: Candidates should have practical database administration and troubleshooting experience across Oracle, MongoDB, and Redis. Knowledge of OpenShift and Dynatrace will be an added advantage

Responsibilities

• Oracle Database Management:
  
  • Oversee database health and performance metrics utilizing Oracle Enterprise Manager (OEM).
    
  • Evaluate SQL execution plans to drive query optimization and resolve performance bottlenecks.
    
  • Execute fundamental DBA commands to verify protection modes, open states, and synchronization status.
    
  • Interpret DDL, DML, and DCL statements to assess their operational impact.
    
  • Analyze AWR and ASH reports to diagnose system behavior and trends.
    
  • Distinguish between database and schema structures for effective administration.
    
  • Ensure continuous database availability and manage production incident responses.
    

• MongoDB Administration:
  
  • Oversee MongoDB architecture and perform comprehensive administrative tasks.
    
  • Configure and maintain high availability through replica sets.
    
  • Manage sharding components, including config servers, mongos processes, and shards.
    
  • Execute backup, restoration, and disaster recovery protocols.
    
  • Handle software upgrades, patching, and routine maintenance activities.
    
  • Enforce security policies, authentication mechanisms, authorization rules, and access controls.
    
  • Lead installation, configuration, and troubleshooting efforts.
    
  • Conduct capacity planning and track resource consumption.
    
  • Optimize performance via query and index tuning.
    
  • Utilize diagnostic tools like mongostat, mongotop, and explain() for deep analysis.
    
  • Assess replication status, cluster health, and overall database performance.
    

• Redis Administration:
  
  • Install, configure, monitor, and maintain Redis instances.
    
  • Demonstrate deep knowledge of Redis architecture, data structures, memory management, and eviction strategies.
    
  • Manage replication, Sentinel, and Cluster configurations for high availability.
    
  • Track CPU, memory, latency, connections, and cache efficiency.
    
  • Resolve connectivity issues, timeouts, session expirations, and performance constraints.
    
  • Oversee persistence, backup, recovery, and failover operations.
    
  • Manage upgrades, patching, and configuration tuning.
    
  • Implement security controls, including authentication, ACLs, and access management.
    
  • Investigate logs, slow commands, key eviction, and cache anomalies.
    
  • Partner with application and infrastructure teams to address production incidents.
    

• Secondary Technical Support:
  
  • OpenShift: Apply foundational knowledge of OpenShift and Kubernetes to monitor pods, deployments, and cluster resources; troubleshoot pod failures, connectivity issues, and deployment errors; and understand namespaces, services, routes, and persistent storage.
    
  • Dynatrace: Monitor application and database performance; analyze alerts, response times, and resource usage; identify performance bottlenecks; support root cause analysis; and collaborate with teams to resolve monitoring alerts.
    

• Possess strong analytical and troubleshooting capabilities.
  
• Demonstrate proven experience in database monitoring and production support.
  
• Understand high availability models, disaster recovery, and backup/recovery workflows.
  
• Have working knowledge of Linux/Unix operating systems and basic shell scripting.
  
• Experience with incident management, change management processes, and Root Cause Analysis (RCA) documentation.
  
• Ability to effectively coordinate with application, infrastructure, and operations teams.
  
• Hold practical experience administering Oracle, MongoDB, and Redis in live production settings.
  
• Have a background supporting business-critical applications.
  
• Familiarity with enterprise IT operations and 24 7 production support cycles is preferred.