SQL Server Engineer

SQL Server EngineerSQL Server Engineer with SDLC (software life-cycle development) experience (5+ years of experience):Candidate must have worked 3+ years in SQL Server Data Warehouse projects with supporting and maintenance including creating and implementing relational or dimensional databases, monitoring, and debugging/enhancement/deploymentsCandidate must be well efficient with SQL query – script development, performance tuning, and query optimizationCandidate must have worked with parameter driven data warehousing solutions and proficient with Stored Procs/functions, integrate/map parameters to data control-flowCandidate must have 3+ years of experience with any data analytic software or visualization tool, i.e. Power BI, Tableau, or, QlikView/Qliksense (Power BI preferred)Candidate must have experience supporting SSRS (3+ years) – develop and enhance reports, deploy reports to SSRS portal, create subscriptions, and administer reports including interacting with SSRS subscription logsCandidate must have worked in SSIS and data integration life-cycle projects (develop/deploy/maintain) – not currently required, but if needed should be able to interact with ‘dtsx’ packages, debug and transition or updateCandidate must be well communicated – clear, precise, and analyticalSQL Server administration experience:Assist with database updatesManage database security (permission grant/revoke/access mapping etc.)SQL Server jobs and subscriptionsSSRS ServiceSSIS ServiceIt will be plus if both candidates have exposure to Azure environment including:ADF (Azure Data Factory)Azure Synapse (Pipeline/Triggers/Monitoring tool)