Database Administrator - #10512286

As a Database Administrator, you will play a critical role in managing and optimizing our organization’s data infrastructure. Your responsibilities will span across various technologies, including Dataverse, SQL databases, and potentially NoSQL databases. Additionally, you’ll be involved in creating and maintaining dashboards in Power BI, facilitating data workflows, and leveraging Power Automate. Proficiency in Azure DevOps and programming skills in C# are essential for success in this role.

Duties & Responsibilities:

1. Dataverse Administration

• Querying Dataverse Data: Utilize SQL to query data from Dataverse tables. The Dataverse business layer provides a Tabular Data Stream (TDS) endpoint that emulates a SQL data connection, allowing read-only access to table data.
• Security and Access Control: Implement and manage security models within Dataverse to control data access for users.
• Integration with Azure DevOps: Explore ways to integrate Azure DevOps work items with Dataverse tables.

2. SQL Database Management

• Database Design and Optimization: Design, create, and maintain SQL databases. Optimize database schema, indexes, and queries for performance.
• Backup and Recovery: Implement backup and recovery strategies to ensure data integrity.
• Monitoring and Troubleshooting: Monitor database performance, identify bottlenecks, and troubleshoot issues.

3. Power BI Dashboard Creation & Maintenance

• Data Visualization: Collaborate with business stakeholders to understand reporting requirements. Create interactive dashboards using Power BI to visualize data trends, KPIs, and insights.
• Data Modeling: Transform raw data into meaningful visualizations by designing data models and relationships.
• Scheduled Data Refresh: Configure scheduled data refresh for Power BI reports.

4. Power Automate

• Workflow Automation: Develop and manage workflows using Power Automate. Automate data-related processes, approvals, and notifications.
• Integration with Dataverse and Other Systems: Connect Power Automate flows to Dataverse, SQL databases, and other systems.

5. Azure DevOps Integration

• Work Item Tracking: Collaborate with development teams by integrating Azure DevOps work items (such as user stories, tasks, and bugs) with Dataverse tables.
• Continuous Integration and Deployment (CI/CD): Leverage Azure DevOps pipelines for deploying database changes and managing releases.
• Version Control: Ensure database scripts and schema changes are version-controlled within Azure DevOps repositories.

6. Programming in C# and Java Script

• Scripting and Automation: Write custom scripts and automation tasks using C# and Java Script to enhance database management processes and adjust model driven app frontend.
• API Integration: Integrate Dataverse and other systems using C# APIs.