Database administrator

Database Reliability Engineering Position Overview We are seeking a highly skilled Database Administrator (DBA) with extensive hands-on experience in managing AWS Open Search 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 Dev Ops 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 Open Search/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 Dev Ops tools (e.g., Terraform, Ansible, Docker, Kubernetes). Troubleshoot and resolve issues in real-time for revenue-impacting systems. Implement monitoring and alerting (e.g., Cloud Watch, Prometheus) to detect performance issues. Ensure security and compliance with encryption and access controls (IAM, VPC). Collaborate with development and Dev Ops 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 Open Search 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., Open Search Service, EC2, Elasti Cache, Cloud Watch). Advanced knowledge of Elasticsearch/Open Search APIs, query DSL, and optimization. Experience with in-memory databases (e.g., Redis, Memcached) or graph databases (e.g., Neo4j Cypher). Skilled in Dev Ops tools: Ia C: Terraform, Cloud Formation Configuration: Ansible, Chef, Puppet CI/CD: Jenkins, Git Lab CI, Git Hub 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. Dev Ops certifications (e.g., Docker, Kubernetes). Good-to-Have Experience with other AWS databases (e.g., RDS, Dynamo DB, 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