Node and MongoDB developer Needed

Require Node/Mongodb developer to do the following: 1. JOB1: Data clean up and purging script in mongodb 2. JOB2: Adjust time window parameter Further details below. Background We are a startup called Alert Centric that has a built platform to manage large volumes of servers backup notifications. IT Departments manage backups for their customers. During the backup process the software that are used for doing the backups send an email notifications to the IT Department. The issue is there can be 100s of emails a day which must be manually checked for no errors. The purpose of alert centric platform is to automatically verify these email notifications into a simple daily report and forward any failures onto the user for action. It does this by the user directing each backup job into a designated email address supplied by Alert Centric. This is done in combination with an email service called Sendgrid. Alert Centric then consolidates the notifications, verifies and sends email notification or a scheduled PDF report to the user of any problems. Basic Workflow 1. Sign up process 2. User settings including timezone and email to send notifications 3. Client Page where users adds backup jobs 4. Reporting Page JOB1: Data clean up and purging script in mongodb As above, Alert Centric monitors a clients backups and checks whether these backups have been performed correctly. It does this by the user diverting all notifications emails in their backup system to alert centric. All these emails received are stored in the mongodb collection called ‘email’. See attached ‘email collection record example’ Due to the number emails notifications being received this collection is becoming very large. To maintain the DB size, what we need is: 1. Clean up script to: - check each document in ‘email collections’ - If document is older than 31 days (by checking ‘time’ field) delete all fields EXCEPT FOR the following fields _id $oid userId deviceId time status _v - Comment code time period condition (31 days) to run clean up so that we can change if needed 2. Purge script to: - check each document in ‘email collections’ - If document is older than 186 days ie 6 months (by checking ‘time’ field) delete the document - Comment code time period condition (31 days) to run purge so that we can change if needed NOTE: Because we currently don’t have a staging system, please do a back up of the mongodb production before implementing JOB2: Adjust time window parameter All backup jobs run the backup and send the email notification to alert centric. For example: • 7 days a week ( everyday) • Monthly ( once a week) • Mon-firday ( Monday to Friday) When creating a backup job in alert centric this frequency is set as parameter. Once a day the system checks when an email was last received for each “device” and sees if that’s within the window. In the example of 7 days a week it should have received an email with the last 24 hours period. The issue is sometimes there might be a delay due to a larger back up and we may receive the email notification at 26hrs instead of 24 hours. However because the email was not received within the 24 hrs and error notification that backup failed/missing is reported to the user. We require the check to be adjusted so that we have a window of 28hrs before the system classifies the backup email as missing/failed. We suspect below code in app/business/[login to view URL] is where this check is done. //This handels the script time when it will check if an email is recived within an expected time. Note below the 23 is 11:00pm function findAllUsersIsMidnight() { return new Promise(function (resolve) { var currentDate = getDate(); [login to view URL]().then(function (users) { var arrayUser = []; [login to view URL](users, function (user) { if ([login to view URL] && 0 === parseInt(moment(currentDate).tz([login to view URL]).format('HH'), 10)) { [login to view URL](user); } }); resolve(arrayUser); }); }); }