Previous Job
Sharepoint admin/SSRS developer/
Ref No.: 18-17250
Location: Charlotte, North Carolina
Required Skills :

Basic Qualifications :

Job Description :
Apex Systems seeking an experienced IT professional, highly proficient in the administration of SQL Server Reporting Services (SSRS), Sharepoint, and report development. This resource will work under the guidance of the Senior SQL Server DBA for the duration of the project, and act as the dedicated expert focusing on migrating SSRS reports from a legacy Sharepoint instance to a new SSRS instance.
70% Infrastructure (administration and thorough understanding of Sharepoint and SSRS components)
20% Development (T-SQL queries and general knowledge of relational databases hosted on SQL Server)
10% Analytics (Basic analytic skills for data validation)
Assess the current-state of the environment and project scope and refine a strategic migration plan of SSRS reports
Provide recommendations to team leadership regarding existing SSRS target infrastructure
Perform testing and development of necessary changes in lesser environments to bring about standard practices to SSRS reports, according to best-practices and guidelines, including and not limited to:
Upgrading reports from SSRS / Sharepoint 2007 to SSRS 2016 versions
Remove imbedded data sources from reports and leverage the use shared data sources
Utilize Active Directory accounts instead of SQL Server logins for data source authentication
Implement data-sets if necessary
Fundamental knowledge of:
Microsoft Active Directory authentication components
Windows Server administration
SQL Server databases and services
5++ years of experience in:
SQL Server database development (T-SQL, DML, DDL, and basic schema design)
SSRS report development (Data Tools / Visual Studio, and BIDS)
Administration of SSRS (2012+), building / scaling front-end servers for load-balancing and high-availability (server farms) is highly favorable
Managing and Administration of Sharepoint and / or SSRS environments (non-integrated Sharepoint experience is acceptable)
Migration of SSRS reports, report parts, and their dependencies
The candidate must be self-motivated and able to communicate with other team members to provide concise technical details to experts and non-experts alike