Required Skills

SSRS Power Bi RS

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 14th Feb 2024

JOB DETAIL

  • Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, Power Bi RS, SSIS, Azure Synapse and other related products as applicable and necessary.
  • Install/Configure/Setup/Administer and Maintain production and non-production environments.
  • Setup High-Availability and Disaster Recovery
  • Plan and test high availability and disaster recovery
  • Create Users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets.
  • Resolve database integrity, performance, blocking, connectivity, and replication issues.
  • Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.
  • Perform and manage Database backup/recovery/restore and capacity monitoring.
  • Synapse workload management and optimization
  • Setup SQL agent jobs, elastic jobs, and runbook automation
  • Identify and setup alerts and logging in Azure.
  • Maintain databases – Statistics, Indexes, fragmentation.
  • Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)
  • Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.
  • Deploy and configure SSIS packages and SSRS and Power Bi RS Reports. Troubleshoot issues with SSRS, Power Bi RS, and SSIS.
  • Support release/code deployment activities
  • Provide 24x7 support as necessary.
  • Implement operational automation using scripts.
  • Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database) - In-depth SQL database advanced performance tuning experience – Stored Procedures, Views, Functions; skilled in analyzing and assessing query execution plans and DMVs; expertise in assessing and implementing indexes and partitioning; Tuning ETL Jobs - SSIS & Azure Data Factory
  • Design and create databases to support development initiatives.

Company Information