SQL Server Engineer

SQL Server Engineer SQL 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/deployments Candidate must be well efficient with SQL query – script development, performance tuning, and query optimization Candidate must have worked with parameter driven data warehousing solutions and proficient with Stored Procs/functions, integrate/map parameters to data control-flow Candidate 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 logs Candidate 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 update Candidate must be well communicated – clear, precise, and analytical SQL Server administration experience: Assist with database updates Manage database security (permission grant/revoke/access mapping etc.) SQL Server jobs and subscriptions SSRS Service SSIS Service It will be plus if both candidates have exposure to Azure environment including: ADF (Azure Data Factory) Azure Synapse (Pipeline/Triggers/Monitoring tool) My3Tech Inc