MongoDB Architect (SQL to MongoDB Migration Specialist)

Role Summary

We are seeking an experienced MongoDB Architect to lead the design, migration, and optimization of enterprise-scale data platforms, with a strong focus on SQL-to-MongoDB transformation initiatives. The ideal candidate will have successfully architected and delivered large-scale migrations from relational database environments (SQL Server, Oracle, PostgreSQL, MySQL, etc.) to MongoDB and will be responsible for establishing the target-state architecture, migration strategy, performance optimization, governance, and operational excellence.

The architect will work closely with business stakeholders, application development teams, data engineers, cloud architects, and infrastructure teams to modernize legacy data platforms while ensuring scalability, resilience, security, and cost efficiency.

Key Responsibilities

Database Architecture & Design

• Design enterprise-wide MongoDB architectures supporting mission-critical applications.
• Define data modeling standards, schema design strategies, indexing frameworks, and document structures.
• Architect highly available and fault-tolerant MongoDB environments including:
• Replica Sets
• Sharding
• Multi-region deployments
• Disaster Recovery solutions
• Design cloud-native MongoDB deployments on AWS, Azure, or GCP.

SQL to MongoDB Migration Leadership

• Assess existing SQL Server, Oracle, PostgreSQL, and MySQL environments.
• Develop migration roadmaps and modernization strategies.
• Analyze and transform relational schemas into optimized MongoDB document models.
• Lead proof-of-concepts and migration assessments.
• Define and execute:
• Data migration patterns
• ETL/ELT frameworks
• Validation and reconciliation processes
• Cutover and rollback strategies
• Mitigate migration risks and ensure data integrity throughout the migration lifecycle.

Performance & Optimization

• Perform workload analysis and capacity planning.
• Optimize:
• Query performance
• Aggregation pipelines
• Index strategies
• Cluster sizing
• Storage and compute utilization
• Establish monitoring, alerting, and observability standards.

Governance & Security

• Define database governance frameworks.
• Implement:
• Role-Based Access Control (RBAC)
• Encryption at rest and in transit
• Auditing and compliance controls
• Ensure alignment with enterprise security standards and regulatory requirements.

Technical Leadership

• Serve as the MongoDB subject matter expert.
• Mentor development and database teams on MongoDB best practices.
• Conduct architecture reviews and provide technical direction.
• Establish standards, design patterns, and operational runbooks.

Required Qualifications

Experience

• 10+ years of database architecture and engineering experience.
• 5+ years of hands-on MongoDB architecture experience.
• Proven experience leading SQL-to-MongoDB migration projects in complex enterprise environments.
• Demonstrated experience designing MongoDB solutions supporting high-volume transactional and analytical workloads.
• Experience with cloud platforms (AWS, Azure, or GCP).

Technical Skills

MongoDB

• MongoDB Enterprise or MongoDB Atlas
• Replica Sets
• Sharding
• Aggregation Framework
• Change Streams
• Atlas Search
• Performance tuning
• Backup and recovery
• Cluster management

Relational Databases

• Microsoft SQL Server
• Oracle
• PostgreSQL
• MySQL

Migration Expertise

• Schema conversion and data modeling
• Migration tooling and frameworks
• Data quality and reconciliation
• ETL/ELT design
• Data validation strategies

Cloud & DevOps

• Terraform or Infrastructure as Code
• Kubernetes/OpenShift
• CI/CD pipelines
• Monitoring tools
• Logging and observability platforms

Programming/Scripting

• Python
• Java
• JavaScript/Node.js
• Shell scripting

Preferred Qualifications

• MongoDB Certified Developer or DBA certification.
• Experience with MongoDB Atlas.
• Experience migrating environments exceeding:
• 5 TB+ data volume
• Billions of records
• 24x7 mission-critical systems
• Experience in financial services, healthcare, retail, insurance, or large-scale SaaS environments.
• Familiarity with event-driven and microservices architectures.

Desired Leadership Competencies

• Strong stakeholder management skills.
• Ability to lead technical discovery sessions and architecture workshops.
• Excellent communication and executive presentation abilities.
• Proven ability to influence technology strategy and roadmap decisions.
• Strong problem-solving and analytical skills.

CONTACT KHURRAM @ 201 677 1257 X 109 OR khurram"at"khoj-inc.com

Work Location: Remote