Database Administrator

Database Reliability EngineeringPosition OverviewWe 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 ResponsibilitiesManage 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 / MCAExperience : Overall 5 - 10 Years5+ 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, CloudFormationConfiguration: Ansible, Chef, PuppetCI/CD: Jenkins, GitLab CI, GitHub ActionsContainerization: Docker, KubernetesMonitoring: Prometheus, Grafana, ELK StackFamiliarity 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-HaveExperience 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 administrationAutomate regular administrative tasks and ensure correctnessDocument data standards, procedures, and dictionary definitionsCollaborate with SREs and developers on DB design, performance tuning, and production supportHelp evolve application/database architecture and support environment creationRespond to on-call incidents, and support technical queries from staff, management, and vendors