Database Administrator

Job Description

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