Hi ram,
Hope you are doing good.
Role: Data Engineer with SQL Server
Location: Remote
Duration: Long term
Contract: C2C / W2
Required Years of Experience: 10+ years
Experience in: Banking / Financial domain must.
Description:
Strong skills with physical SQL Server databases
· Database backups
· Database logs
· Database file structures
· Database Indexes
· Moving databases to new locations
· Database single user mode
· Database emergency mode
Strong Skills with SQL Server Development
• Deep understanding of TSQL
• Stored procedures
• Views
• Functions
• CTE
• Partition Over
Strong Skills with SQL Server Performance Tuning
· SQL Server dynamic views
· SQL Server profiler
· SQL Server explain plan
· Monitoring physical performance counters
· Monitoring database performance counters
Strong Skills with Azure SQL Server
• SQL Server PAS Databases
• SQL Server IAS
Strong Skills with on Premise SQL Server
• SQL Server Windows services
• Disk striping
• Windows Security
Strong Skills with Azure Data Factory
· Pipelines
· Data sets
· Triggers
· Dynamic pipeline configuration
· For Each and variable passing
· Fixed files, blob storage, SFTP
Nice to have
· Snowflake
· Strong skills with SSIS
· Strong skills with Azure Logic Apps.
