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.
Requirements
- 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.
- 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.
- Support the development and maintenance of Power BI dashboards and reports, ensuring data accuracy and performance.
- Collaborate with application development teams to design and implement efficient data access patterns.
- 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.
- 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.
- 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.
- 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.
Benefits
- 401k Matching
- Generous Paid Time Off
- Relocation Assistance
- Retirement Plan
