Need at least 5 years of experience in:
MSSQL - Microsoft SQL server 2012 and newer. Advanced DBA, SQL scripting, tuning, procedure / function writing, profiling
SSRS - SQL server reporting services 2012 and newer. Setup, upgrading, moving existing ssrs server to another servers.
Report writing and maintenance, RDL deployment, jobs.
2 years experience with:
AWS RDS - amazon relational database service: setup / maintenance
.NET framework 4.x - 4.5, 4.6, 4.7
Nice to have:
Any front end work ( typescript, angular, react, etc)
The position is be heavy in SQLvand SSRS. The position will be inside of a squad which is where the optional items come in to help out the team when there isn’t db or SSRS work in the sprint. We manage a system with over 2000 databases, so keeping the developers in line when it comes to scripting and best practices is very important. Older application uses entity framework which needs constant checking to make sure the ORM is not introducing poor performing SQLinto the environment. SSRS is needed to maintain our current library of ~250 reports and to develop new reports as needed. Migration and Upgrade of the SSRS to newer version is coming soon and candidate will be performing this migration.
It’s a complicated position, they need to be a great DBAand SSRS person, and have knowledge of .NET (which most SSRS candidates will). The items with 2 years experience are areas we are starting to use, so it will really help out the team if we get someone with experience in those areas as well.