<p><strong>Overview:</strong></p><p>We are seeking a highly skilled SQL Database Administrator (DBA) to manage and optimize our Azure-hosted SQL environment supporting the Jenzabar ERP system. This position plays a key role in ensuring data integrity, performance, and seamless integration between the ERP and multiple third-party applications used across various departments, including Admissions, Financial Assistance, Business, and IT. The ideal candidate will possess deep expertise in SQL, SSRS reporting, and user permission management, with the ability to automate administrative tasks and support occasional server-related issues.</p><p><strong>Key Responsibilities:</strong></p><ul><li>Administer and maintain SQL databases hosted in Azure, ensuring availability, performance, and security.</li><li>Develop, troubleshoot, and optimize SQL queries, stored procedures, and functions to support ERP integrations and reporting needs.</li><li>Manage and troubleshoot user permissions, access controls, and data security within SQL and related applications.</li><li>Build and maintain PowerShell automation scripts to streamline database management, data transfers, and system monitoring processes.</li><li>Design, develop, and maintain SSRS (SQL Server Reporting Services) reports for multiple departments across the organization.</li><li>Collaborate with Jenzabar and internal stakeholders to support data exchange processes between the ERP and third-party systems.</li><li>Support and troubleshoot data integration workflows, manual data transfers, and automated data synchronization tasks.</li></ul>
