Opiniion Inc. is a resident satisfaction software company that partners with property management firms to enhance living experiences. They are looking for a Senior Backend Software Engineer to lead the migration from MongoDB to PostgreSQL, design database schemas, and ensure the development of secure and efficient APIs.
Responsibilities:
- Write and maintain Node.js API services
- Architect the relational schema from our existing document-based data model
- Design and execute a zero-downtime migration strategy (dual-write, expand-contract, etc.)
- Own DB performance — indexing, query analysis, connection pooling
- Work with Node.js to read, process, and optimize MongoDB and SQL
- Work inside Docker locally and on AWS
Requirements:
- Have shipped a production NoSQL → relational migration, and can walk us through it
- Have a strong background in backend software engineering, and understand relevant computer science fundamentals
- Know PostgreSQL deeply (JSONB, CTEs, window functions, transactions, EXPLAIN ANALYZE)
- Are competent and autonomous at writing Node.js code
- Have used schema migration tooling
- Are comfortable in AWS (RDS, ECS, IAM, VPC basics)
- Think about data integrity first, speed second
- Are willing to use AI in your daily development work