S'INSCRIRE

Offres d'emploi

Trouvez des postes près de chez vous, sur site, hybrides ou à distance.
  • Emplois similaires à : Database Administrator - Azure SQL & Microsoft Dataverse
XX
Database Administrator - Azure SQL & Microsoft DataverseMcMillan Pazdan Smith Architecture • Charlotte, North Carolina, United States
Postuler Maintenant
XX

Database Administrator - Azure SQL & Microsoft Dataverse

McMillan Pazdan Smith Architecture
  • US
    Charlotte, North Carolina, United States
  • US
    Charlotte, North Carolina, United States
Postuler Maintenant

À propos

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 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, PowerShell, Python) to automate routine database tasks, deployments, and monitoring processes.
Implement infrastructure‑as‑code (IaC) principles for database provisioning and management.
Architecture & Design
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.
Collaboration & Communication
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.
Requirements
Bachelor's degree in Computer Science, Information Technology, or a related field.
Minimum of 5 years of experience as a Database Administrator.
Extensive experience managing and administering Azure SQL Databases, including performance tuning, security, and high availability configurations.
Strong experience with Microsoft Dataverse, including entity modeling, security roles, business rules, and solution management.
Proven experience in utilizing APIs (REST, SOAP) and other modern data integration technologies (e.g., Azure Data Factory, Logic Apps) to connect and integrate data from various sources.
Solid understanding and practical experience with Power
#J-18808-Ljbffr
  • Charlotte, North Carolina, United States

Compétences linguistiques

  • English
Avis aux utilisateurs

Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.