Dynamic Sitemap Creation for WordPress Site

I'm looking for a professional who can create a dynamic sitemap for my WordPress website. The sitemap needs to be automated and synchronised with our daily database updates. Key Requirements: - Experience with WordPress - Proficient in creating automated systems - Familiar with MySQL databases - Ideally, an SEO manager The sitemap should update daily with new product pages and deleting the deleted pages. It is crucial that the freelancer understands the importance of SEO in this task, as the sitemap plays a significant role in search engine visibility.