Location
Hartford, Connecticut
Job Type
Full-time
Posted
May 16, 2026
Job Description
Role: Database Engineer-Mongo
Location: Remote
Duration: 6+ Months
Only W2
Summary: Build and run a data migration and streaming architecture moving on prem DB2 to AWS PostgreSQL (raw landing) and then to AWS MongoDB (transaction cache), applying transformation rules so downstream apps can consume “friendly” data. Own MongoDB modeling and performance architecture.
Responsibilities:
Location: Remote
Duration: 6+ Months
Only W2
Summary: Build and run a data migration and streaming architecture moving on prem DB2 to AWS PostgreSQL (raw landing) and then to AWS MongoDB (transaction cache), applying transformation rules so downstream apps can consume “friendly” data. Own MongoDB modeling and performance architecture.
Responsibilities:
- Design DB2→Postgres→Mongo target architecture and cutover approach.
- Build/operate Precisely + Kafka pipelines (CDC, topics, replay, error handling).
- Define/implement transformation rules from raw relational data to MongoDB documents.
- Model MongoDB collections, indexes, sharding/partitioning, TTL/retention for cache use cases.
- Ensure data quality/reconciliation, security controls, monitoring, and runbooks...