Hmm, I think over the last few years the answer has become - "just use AI to do it". However, I do recommend that you are indeed an average sys admin or at least a below average one so that you can spot check, and guide your AI to do things safely.
Furthermore, a paid solution IDE will do a much better job at it than a regular free chat version. I tried a few, and Cursor is currently the best. Windsurf is lagging behind. Trae not even worth mentioning. You could also use Gemini CLI or Antropic CLI for this task.