Senior Database Engineer

Job Description

Senior Database Engineer

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 (e.g., 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.

Required Qualifications:

• MCA or Bachelors in Engineering, Computer Science or equivalent.