Azure SQL & Dataverse Specialist — Data Integration & BI

McMillan Pazdan Smith Architecture; Charlotte (NC); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading architecture firm in Charlotte, NC is seeking a highly skilled Database Administrator to manage and optimize data infrastructure. The ideal candidate will have at least 5 years of experience with Azure SQL Database and Microsoft Dataverse, and will be proficient in scripting and data integration technologies. This role involves database administration, performance optimization, and supporting analytics solutions with tools like Power BI, contributing significantly to data-driven decision making.

Qualifications

• Minimum of 5 years of experience as a Database Administrator.
• Extensive experience managing Azure SQL Databases, including performance tuning and security.
• Strong experience with Microsoft Dataverse and data integration technologies.

Responsibilities

• Administer and maintain Azure SQL Databases ensuring high availability and performance.
• Design and implement data integration solutions using APIs and Azure Data Factory.
• Support development of Power BI dashboards ensuring data accuracy.

Skills

Azure SQL Database

Microsoft Dataverse

APIs (REST, SOAP)

Power BI

Database optimization

Scripting (T-SQL, PowerShell, Python)

Education

Bachelor's degree in Computer Science or IT

Tools

Azure Data Factory

Logic Apps

Job description

A leading architecture firm in Charlotte, NC is seeking a highly skilled Database Administrator to manage and optimize data infrastructure. The ideal candidate will have at least 5 years of experience with Azure SQL Database and Microsoft Dataverse, and will be proficient in scripting and data integration technologies. This role involves database administration, performance optimization, and supporting analytics solutions with tools like Power BI, contributing significantly to data-driven decision making.