INSenior AssociateDatabase Reliability EngineeringGCCAdvisoryNoida

Line of Service

Industry/Sector

Specialism

Management Level

Job Description & Summary

Job Description:

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:

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

o Configuration: Ansible Chef Puppet

o CI/CD: Jenkins GitLab CI GitHub Actions

o Containerization: Docker Kubernetes

o 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

Mandatory skill sets:

Expertise in Selenium with any programming language (Cypress Java Python C# Java script) - Logical programming and debugging skills. - Automation framework development/enhancement experience is a must. - Experience in robot framework is a plus. - Experience in a fast-paced agile environment. - Good interpersonal and communication skills - Good debugging skills and an ability to identify issues quickly and effectively - Experience in developing automation framework for testing Restful web services - Experience in Jenkins configuring jobs executing TestNG test cases from Jenkins - Good Understanding about Data structure and algorithms - Good knowledge on Relational Database/SQL Queries - Worked on Manual functional/regression/integration testing - Strong understanding of APIs and experience of automating APIs Logs/monitoring: browser dev tools Kibana/CloudWatch (nice-to-have).

Preferred skill sets:

Cypress Java Python C# Java script

Years of experience required:

Overall 5 - 10 Years

Education qualification:

B-Tech / MCA

Education (if blank degree and/or field of study not specified)

Certifications (if blank certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship

Government Clearance Required

Job Posting End Date