Database Administrator

Role : Database Reliability EngineeringPosition 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. (ref:hirist.tech)