Database Administrator

Role : 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.