Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Description: Database Administrator Azure SQL & Microsoft Dataverse
Location: Greenville South Carolina United States
Job Summary:
McMillan Pazdan Smith Architecture 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 datadriven 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 with architectural space data or health system data is a significant plus.
Responsibilities:
- Database Management & Administration:
o Administer and maintain Azure SQL Databases ensuring high availability performance security and integrity.
o Manage and maintain Microsoft Dataverse environments including entity creation relationship management security configuration and solution deployment.
o Perform database backups restores and recovery procedures.
o Implement and maintain database security measures including user access control encryption and auditing.
o Monitor database performance identify bottlenecks and implement optimization strategies.
o Troubleshoot and resolve databaserelated issues in a timely and efficient manner.
- Data Integration & Connectivity:
o 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.
o Develop and maintain data pipelines to ensure seamless data flow between Azure SQL Microsoft Dataverse and other systems.
o Collaborate with application development teams to design and implement efficient data access patterns.
- Analytics & Reporting Support:
o Support the development and maintenance of Power BI dashboards and reports ensuring data accuracy and performance.
o Collaborate with business users and analysts to understand reporting requirements and provide data solutions.
o Familiarity with other analytical tools and techniques for data exploration and visualization.
- Database Optimization & Performance Tuning:
o Analyze query performance and implement indexing strategies query optimization techniques and database configuration changes to improve efficiency.
o Conduct performance testing and identify areas for improvement.
o Implement and maintain database partitioning and archiving strategies as needed.
- Scripting & Automation:
o Develop and maintain scripts (e.g. TSQL PowerShell Python) to automate routine database tasks deployments and monitoring processes.
o Implement infrastructureascode (IaC) principles for database provisioning and management.
- Architecture & Design:
o Participate in the design and implementation of database solutions that meet business requirements and align with best practices.
o Contribute to the development of data models and database schemas.
o Stay current with emerging database technologies and trends particularly within the Microsoft Azure ecosystem.
- Documentation & Standards:
o Create and maintain comprehensive documentation for database configurations processes and procedures.
o Adhere to established data governance policies and standards.
- Collaboration & Communication:
o Collaborate effectively with crossfunctional teams including developers analysts and business stakeholders.
o Communicate technical information clearly and concisely to both technical and nontechnical audiences.
- Bachelors 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 BI or other data visualization and analytical tools.
- Proficiency in database optimization techniques including indexing query tuning and performance monitoring.
- Strong scripting skills in TSQL PowerShell and/or Python for automation and database management tasks.
- Experience with database design principles and data modeling.
- Excellent problemsolving analytical and troubleshooting skills.
- Strong communication and collaboration skills.
Preferred Qualifications (Plus):
- Experience working with architectural space data (e.g. BIM CAD data spatial databases).
- Experience working with health system data (e.g. EHR/EMR systems HL7 FHIR).
- Experience with other Azure data services (e.g. Azure Synapse Analytics Azure Data Lake Storage).
- Familiarity with DevOps practices and CI/CD pipelines for database deployments.
- Relevant Microsoft certifications (e.g. Azure Database Administrator Associate).
McMillan Pazdan Smith is an equalopportunity employer. All qualified applicants will receive consideration for employment without regard to sex race religion color national origin age disability veterans status or any classification protected by state or local law.
If you need a reasonable accommodation to access the information provided on this web site please contact Human Resources at: for further assistance.
Required Experience:
Unclear Seniority
Employment Type
Full Time
