Database Administrator - Azure SQL & Microsoft Dataverse

Job description

Description McMillan Pazdan Smith is seeking a highly skilled and experienced Database Administrator to manage and optimize our critical data infrastructure, with a strong focus on Azure SQL Database and Microsoft Dataverse. The ideal candidate will possess deep expertise in leveraging APIs and modern integration technologies to connect disparate data sources, coupled with a proven ability to utilize Power BI and other analytical tools for data-driven insights. This role requires a proactive individual with a strong understanding of database optimization, scripting, and automation techniques to ensure the performance, security, and reliability of our data assets. Experience working in the Architecture, Engineering, or Construction industry is a significant plus. Responsibilities: Database Management & Administration: - Administer and maintain Azure SQL Databases, ensuring high availability, performance, security, and integrity. - Manage and maintain Microsoft Dataverse environments, including entity creation, relationship management, security configuration, and solution deployment. - Perform database backups, restores, and recovery procedures. - Implement and maintain database secu...