JC061026-Sr Database Engineer

Experience - 4 to 8 Years

Location - Bangalore

Work Mode - Hybrid

Mandatory: MongoDB/CouchDB, Database Designing, Performance Tuning, Optimization, Complex Query Writing, Advance Indexing, Strong understanding database issues. This role is completely individual contributor.

Job Description

Required Experience and Skills

Experience:

• 5-8 years in database engineering, architecture, or backend data systems.
• 3+ years of hands-on experience managing Azure Cosmos DB and MongoDB in production.
• Deep understanding of:
  • Cosmos DB: Partition key design, RU/s provisioning, indexing, consistency models, TTL, and multi-region replication.
  • MongoDB: Replica sets, sharding, indexing strategies, aggregation pipelines, schema optimization, and tuning.
• Proven ability to design for high concurrency, low latency, and multi-tenant SaaS systems.
• Experience with query profiling, performance benchmarking, and monitoring dashboards.

Specific skills required

• Design & Architecture:
  • Architect and implement distributed data models using Cosmos DB (Core SQL or Mongo API) and MongoDB to support large-scale, high-throughput applications.
  • Define partitioning, indexing, and data distribution strategies for optimal scalability and performance.
• Performance Engineering:
  • Conduct deep query analysis, index optimization, and RU/cost optimization in Cosmos DB.
  • Implement profiling, query tuning, and aggregation optimization in MongoDB.
• Automation & Operations:
  • Build automation scripts (Python, PowerShell, Bash) for deployment, monitoring, and scaling.
  • Integrate database monitoring and alerting using Azure Monitor, MongoDB Ops Manager, or similar tools.
• Data Lifecycle Management:
  • Implement and optimize backup/restore, TTL policies, and Change Feed or CDC pipelines.
  • Design and validate disaster recovery, replication, and geo-distribution strategies.
• Collaboration:
  • Partner with development and DevOps teams to design data access layers, API integrations, and IaC templates (Terraform, Bicep, ARM).
  • Contribute to performance reviews, code walkthroughs, and system design discussions.

Desirable Experience

• Experience with data migrations (eg, Oracle/SQL MongoDB or Cosmos DB).
• Knowledge of event-driven architectures, microservices, and API-based integrations.
• Familiarity with data security and compliance (encryption, GDPR, HIPAA).
• Exposure to Azure infrastructure, Terraform, or CI/CD data pipelines.
• Awareness of frontend and application integration points (understanding how data models serve APIs/UI layers, Angular).

Additional Skills (Preferred)

• Strong SQL foundation; ability to work with RDBMS systems (SQL Server, PostgreSQL, MySQL) and evaluate relational vs. document model trade-offs.
• Familiarity with backend stacks (.NET, Java, Node.js) for integration and troubleshooting.
• Experience with Infrastructure as Code (Terraform, Bicep, ARM templates).
• Scripting proficiency in Python, PowerShell, or Bash for automation.
• Certifications (preferred):
  • Microsoft Certified: Azure Cosmos DB Developer Associate
  • MongoDB Certified Developer/DBA
• Exposure to data lakes, analytical processing, or data warehousing concepts is a plus.

Required Qualifications:

• Bachelors in Engineering, Computer Science or equivalent.
• Demonstrated experience with Cosmos DB and/or MongoDB at scale
• Strong foundation in distributed systems, NoSQL principles, and data architecture

Additional Information

Personal Skills:

• Excellent analytical and problem solving skills
• Excellent verbal and written communication skills
• Ability to articulate and present different points-of-views on various topics related to project and otherwise.
• Eager to learn and continuously develop personal and technical capabilities.