Senior Database Engineer

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.