Database Administrator

Database Reliability Engineering

Position Overview

We are seeking a highly skilled Database Administrator (DBA) with extensive hands-on experience in managing AWS OpenSearch or Elasticsearch clusters, as well as expertise in in-memory databases (e.g., Redis, Memcached) or graph databases (e.g., Neo4j). The ideal candidate will have a deep understanding of data and index shard management, schema planning, and data modelling for distributed search, in-memory, and graph-based systems. Additionally, the candidate must be proficient in DevOps tools and have experience managing critical production systems that directly impact revenue. The role requires a proactive learner capable of adapting quickly to new technologies in a fast-paced environment.

Key Responsibilities

• Manage and optimize AWS OpenSearch/Elasticsearch, in-memory (e.g., Redis, Memcached), and graph database (e.g., Neo4j) clusters for high availability and performance.
• Optimize data distribution, sharding, caching, and graph traversals for efficient query performance.
• Design schemas and data models for search, caching, and graph-based use cases.
• Tune query performance and indexing strategies to meet SLAs for critical production systems.
• Automate deployment, scaling, and monitoring using DevOps tools (e.g., Terraform, Ansible, Docker, Kubernetes).
• Troubleshoot and resolve issues in real-time for revenue-impacting systems.
• Implement monitoring and alerting (e.g., CloudWatch, Prometheus) to detect performance issues.
• Ensure security and compliance with encryption and access controls (IAM, VPC).
• Collaborate with development and DevOps teams for application integration.
• Stay updated on advancements in relevant database technologies.

Requirements and Skills:

Education: B-Tech / MCA

Experience: Overall 5 - 10 Years

• 5+ years managing AWS OpenSearch or Elasticsearch in production.
• 2+ years managing in-memory databases (e.g., Redis, Memcached) or graph databases (e.g., Neo4j).
• Proven track record with critical production systems impacting revenue.
• Expertise in data and index shard management, caching strategies, and node-relationship modelling.
• Strong experience in schema design and data modelling for search, caching, and graph use cases.

Technical Skills:

• Proficient in AWS services (e.g., OpenSearch Service, EC2, ElastiCache, CloudWatch).
• Advanced knowledge of Elasticsearch/OpenSearch APIs, query DSL, and optimization.
• Experience with in-memory databases (e.g., Redis, Memcached) or graph databases (e.g., Neo4j Cypher).
• Skilled in DevOps tools:
• IaC: Terraform, CloudFormation
• Configuration: Ansible, Chef, Puppet
• CI/CD: Jenkins, GitLab CI, GitHub Actions
• Containerization: Docker, Kubernetes
• Monitoring: Prometheus, Grafana, ELK Stack
• Familiarity with scripting (e.g., Python, Bash) for automation.

Soft Skills:

• Strong problem-solving and analytical skills for distributed systems.
• Quick learner, adaptable to new tools and processes.
• Excellent communication and collaboration skills.

Certifications (Preferred):

• AWS Certified Solutions Architect, AWS Certified Database – Specialty, or Elastic Certified Engineer.
• Neo4j Certified Professional or Redis-related certifications.
• DevOps certifications (e.g., Docker, Kubernetes).

Good-to-Have

• Experience with other AWS databases (e.g., RDS, DynamoDB, Neptune).
• Knowledge of big data tools (e.g., Hadoop, Spark, Kafka).
• Familiarity with log analytics platforms (e.g., ELK Stack, Splunk).

Responsibilities of the Job Include (But Not Limited To):

• Serve as primary POC for advanced-level troubleshooting and perform hands-on DB/system administration
• Automate regular administrative tasks and ensure correctness
• Document data standards, procedures, and dictionary definitions
• Collaborate with SREs and developers on DB design, performance tuning, and production support
• Help evolve application/database architecture and support environment creation
• Respond to on-call incidents, and support technical queries from staff, management, and vendors