Automatically create and purge indexes in MongoDB

| Q                    | A
| -------------------- | ---
| Bug fix?             | No
| New feature?         | No
| BC breaks?           | No
| CI currently passes? | Yes
| Tests pass?          | Yes
| Scenarios pass?      | Yes
| Checkstyle issues?   | No
| Changelog updated?   | Yes
| Fixed tickets        | N.A.
| Doc PR               | N.A.
I would have delegated to specialized classes (and register them into this class through a compiler pass) in order to easily handle future backend types (BUT that may be an early optimization BUT that would make the class thiner).