Database Architect

Neilsoft; Pune District; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Neilsoft is seeking a specialist to own the end-to-end database architecture for migrating legacy OODBMS to MongoDB or equivalent NoSQL solutions. You will analyze schemas, define target object models, and lead strategies for embedding vs referencing, versioning, and high-availability deployments.

You will collaborate with engineering teams to ensure MongoDB access patterns align with persistence layers, optimize CAD-heavy workloads, and document migration playbooks and guidelines.

Qualifications

• Experience with object-oriented databases and data modeling.
• Strong knowledge of object identity, inheritance, and lifecycle.
• Expertise mapping object models to document-based databases (MongoDB).
• Hands-on MongoDB design: schemas, aggregation pipelines, indexing, and transactions.
• Experience with MongoDB Atlas or self-managed clusters.
• Migration/modernization from legacy databases to NoSQL.
• Desirable CAD/engineering data experience.

Responsibilities

• Own end-to-end database architecture for migrating to MongoDB.
• Analyze existing object schemas, relationships, and hierarchies.
• Define target object models optimized for MongoDB, including embedding vs referencing.
• Design data migration strategies ensuring integrity and minimal downtime.
• Plan schema evolution, versioning, indexing, and sharding.
• Collaborate with application teams to align persistence patterns with MongoDB access.
• Architect scalable MongoDB deployments (on-prem or cloud) and validate performance.
• Produce architecture docs, migration playbooks, and guidelines.

Skills

OO Database

Data Modeling

MongoDB Expertise

Aggregation Pipelines

Transactions & Consistency

Indexing & Sharding

MongoDB Atlas

Migration & Modernization

CAD/Engineering Data Knowledge

Job description

Key Responsibilities

• Own the end-to-end database architecture for migrating existing OODBMS to MongoDB or a suitable object-oriented NoSQL database
• Analyze existing object schemas, relationships, inheritance hierarchies, and lifecycle behaviors
• Define target object-oriented data models optimized for MongoDB, including:
  • 1. Embedded vs referenced objects
  • 2. Inheritance and polymorphism strategies
  • 3. Versioned object structures
• Design and implement data migration strategies ensuring:
  • 1. Data integrity and consistency
  • 2. Minimal downtime and risk
  • 3. Backward compatibility where required
• 1. Schema evolution and versioning
• 2. Indexing, sharding, and replication
• 3. Performance optimization for CAD-heavy workloads
• Collaborate with application teams to align object persistence patterns with MongoDB access patterns
• Architect high-availability and scalable MongoDB deployments (on-prem and/or cloud)
• Validate performance, scalability, and correctness of the new database architecture
• Produce architecture documents, migration playbooks, and technical guidelines

Required Skills/Abilities:

• Object-Oriented Database & Data Modeling
• Strong hands-on experience with object-oriented databases or object persistence frameworks
• Deep understanding of:
• Object identity, inheritance, composition, and relationships
• Object lifecycle and transactional behaviour
• Proven experience mapping object models to document-based databases MongoDB Expertise
• Strong solutioning and implementation experience with MongoDB:
• Schema design for complex object graphs
• Aggregation pipelines and indexing strategies
• Transactions and consistency models
• Hands-on experience with MongoDB Atlas or self-managed clusters is a plus Migration & Modernization

Migration & Modernization

• Demonstrated experience migrating from:
• Legacy proprietary databases to MongoDB or NoSQL platforms
• Data extraction, transformation, and loading (ETL) strategies
• Validation, reconciliation, and rollback approaches Application & Technology Stack

Application & Technology Stack

• Strong understanding of application stacks using:
• C++ / Java / .NET–based object models
• Experience integrating MongoDB with complex engineering software
• Understanding of CAD/engineering data structures is highly desirable

Preferred / Good-to-Have Skills

• Experience with CAD, BIM, PLM, or engineering design platforms
• Knowledge of hybrid persistence approaches (polyglot persistence)
• Exposure to event-driven architectures or microservices
• Familiarity with DevOps practices for database operations (CI/CD, monitoring, backups)

Non-Technical Skills

• Strong analytical and problem-solving skills
• Ability to work with legacy systems and complex codebases
• Clear communication with product, engineering, and leadership teams
• Experience mentoring teams and reviewing data designs