Yes, you would fit greatly as a VFX Artist. Creating your own textures, at least basic shapes is a must. And you have a background as a Texture Artist so it’s a huge plus in that regard. Material-wise though, depending on the company you end up, you won’t have access directly to shaders. To make them i mean. Because of proprietary game engines in AAA companies where node based shaders are non-existant for some, or because they are handled by 3D Programmers. You could make some requests for shaders with feastures that would benefit the project.
With companies that uses UE4 or Unity, that’s another story tho.
Software-wise, besides those you mentionned, i recommand After Effects. Hands down. Great for creating shapes, apply filters, adding functions to automatize your workflow and making your own spritesheets by animating any properties you want.
Besides that, if you wanna go down the VFX path, you have to, at least, know your way through particle systems. Once you know them, like Shuriken (Unity) or Cacade/Niagara (UE4), you’ll be okay with any other engines because the core remains the same (Size over Lifetime, Gradients, Pojtn attractor, Velocity over Lifetime, etc). At the end of the day, you make particles.
Good luck out there!