Database Administrator - Azure SQL & Microsoft Dataverse

Responsibilities

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.

• 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 security measures, including user access control, encryption, and auditing.
• Monitor database performance, identify bottlenecks, and implement optimization strategies.
• Troubleshoot and resolve database-related issues in a timely and efficient manner.
• Data Integration & Connectivity:
• Design, develop, and implement data integration solutions using APIs (e.g., REST, SOAP), Azure Data Factory, Logic Apps, or other relevant technologies to connect various data sources.
• Develop and maintain data pipelines to ensure seamless data flow between Azure SQL, Microsoft Dataverse, and other systems.
• Collaborate with application development teams to design and implement efficient data access patterns.
• Analytics & Reporting Support:
• Support the development and maintenance of Power BI dashboards and reports, ensuring data accuracy and performance.
• Collaborate with business users and analysts to understand reporting requirements and provide data solutions.
• Familiarity with other analytical tools and techniques for data exploration and visualization.
• Database Optimization & Performance Tuning:
• Analyze query performance and implement indexing strategies, query optimization techniques, and database configuration changes to improve efficiency.
• Conduct performance testing and identify areas for improvement.
• Implement and maintain database partitioning and archiving strategies as needed.
• Scripting & Automation:
• Develop and maintain scripts (e.g., T-SQL, Power Shell, Python) to automate routine database tasks, deployments, and monitoring processes.
• Implement infrastructure-as-code (IaC) principles for database provisioning and management.
• Participate in the design and implementation of database solutions that meet business requirements and align with best practices.
• Contribute to the development of data models and database schemas.
• Stay current with emerging database technologies and trends, particularly within the Microsoft Azure ecosystem.
• Documentation & Standards:
• Create and maintain comprehensive documentation for database configurations, processes, and procedures.
• Adhere to established data governance policies and standards.
• Collaborate effectively with cross-functional teams, including developers, analysts, and business stakeholders.
• Communicate technical information clearly and concisely to both technical and non-technical audiences.

Responsibilities

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 security measures, including user access control, encryption, and auditing.
• Monitor database performance, identify bottlenecks, and implement optimization strategies.
• Troubleshoot and resolve database-related issues in a timely and efficient manner.
• Data Integration & Connectivity:
• Design, develop, and implement…