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