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

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...