102591 - SSRS Admin

Summary

We are seeking an experienced SSRS Administrator to own, operate, and modernize a large-scale SQL Server Reporting Services (SSRS) environment. This administration

and operations-focused role will ensure platform stability, high availability, secure deployments, and automated release pipelines as the environment transitions fully to Azure IaaS/VM-based hosting.

This position is the primary owner of the SSRS platform post-transition, responsible for troubleshooting production issues, implementing DR processes, and enabling low-touch deployments so report writers can push changes without manual portal work.

Responsibilities

• Administer, maintain, and support SSRS environments hosted in Azure (IaaS/VM-based)
• Manage scale-out SSRS cluster configurations and load balancing for traffic distribution
• Plan and execute version upgrades, patching, and server/environment migrations
• Manage SSRS encryption keys, including backup, restore, and synchronization across clustered nodes
• Implement and maintain SSRS security, including RBAC, Active Directory integration, and secure credential management
• Design, build, and maintain automated deployment pipelines for SSRS artifacts to support Dev/Test/Prod
• Enable repeatable, version-controlled, rollback-capable deployments and push-button deployments for report writers
• Troubleshoot report performance and failures by isolating issues across SSRS rendering/execution, SQL Server performance, and infrastructure/network latency
• Monitor system health, analyze logs, and implement alerting for execution performance, subscriptions, and resource utilization
• Develop and maintain backup and disaster recovery procedures for ReportServer databases and encryption keys
• Validate deployments with automated smoke tests and report execution checks
• Act as primary escalation point for SSRS production incidents and drive root cause analysis and long-term remediation

Requirements

• Hands-on experience administering SQL Server Reporting Services (SSRS) in enterprise environments
• Experience with SSRS installation, configuration, and scale-out (clustered) architectures
• Experience designing and operating load balancing and high availability for SSRS
• Experience with version upgrades, patching strategies, and environment migrations for SSRS
• Experience managing SSRS encryption keys across environments, including backup and restore
• Deep understanding of SSRS internal architecture (ReportServer and ReportServerTempDB, execution lifecycle, logging, caching)
• Strong troubleshooting skills to isolate problems across SSRS, SQL Server, and infrastructure layers
• Experience operating and supporting production systems with an ownership mindset
• Experience designing or supporting automated deployment pipelines (CI/CD) for report deployments
• Experience working in cloud-hosted environments, Azure VM-based deployments, including monitoring, logging, networking, and load balancing
• Strong experience with monitoring, logging, and proactive alerting in production environments
• Strong communication and collaboration skills to support report writers and act as escalation lead

Nice to Have

• Familiarity with Power BI and how it complements SSRS in an enterprise reporting strategy
• SQL Server administration or performance tuning experience
• Experience building CI/CD pipelines using GitHub, Azure DevOps, or Octopus Deploy
• Experience with backup, disaster recovery, and high availability strategies in enterprise systems
• Exposure to scripting or automation (PowerShell, Python)
• Experience modernizing or migrating SSRS environments to cloud platforms