well how important turning indexes on / off highly depends on your architecture, if you process data in your DWH and Reporting is done somewhere else, you usually don't have many indexes you'd want to keep around anyways. But you should definitely know how to work with indexes because tuning will require knowing them rather well so I'd say junior level tops.