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 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 / MCAExperience: 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