We are seeking an experienced SQL Server & Reporting Services Developer/Administrator to provide advanced data management, reporting, and technical support for a mission-critical Records Management System (RMS) within a large public sector environment. Summary: This role will focus on SQL Server permissions administration, query development and optimization, and the design and deployment of SQL Server Reporting Services (SSRS) reports. The ideal candidate will collaborate with third-party vendors, internal IT teams, and operational stakeholders to deliver accurate, secure, and timely reporting solutions that support business operations and decision-making.

Key Responsibilities:

• Administer and manage SQL Server database permissions and security access related to SSRS folders and reports
• Develop, optimize, and maintain T-SQL queries, stored procedures, views, and other database objects to support operational and analytical reporting needs
• Design, build, test, and deploy SSRS reports while ensuring data accuracy, security, scalability, and performance
• Partner with business and technical stakeholders to gather reporting requirements, validate outputs, and refine reporting solutions
• Troubleshoot and resolve issues involving SQL queries, report execution, data integrity, and report performance
• Ensure compliance with organizational security standards, data governance policies, and regulatory requirements
• Create and maintain documentation for database changes, reporting processes, permissions structures, and system workflows
• Support ongoing initiatives to improve reporting efficiency, data quality, and system integrations
• Work closely with internal teams and external vendors to support enhancements and operational needs