• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 20th Sep 2023

More than 6 years of experience in Database Administration for SQL Server (2008R2/2012/2014/2016/2017/2019) in a multi-site enterprise environment.

· Must have experience on On-premises, AZURE IaaS, PaaS instances.

· Strong experience on analyzing and migrating the infrastructure (including the application and database instances) from On-premises to Azure cloud infrastructure.

· Must have experience on analyzing the infrastructure to set up the environments as per the defined project scope.

· Strong experience in troubleshooting and resolving SQL Server instances and related technologies integrations and database problems.

· Must have experience in installing and configuring ADF (Azure Data Factory)

· Must have experience in writing the data pipelines

· Must have experience in migrating the data from on prem to ADF

· Must have experience in configuring the SQL DB in Azure IaaS and PaaS environments

· Should be strong on analyzing the application and database connectivity issues including the drivers and protocols used.

· Must have experience configuring and managing SQL Server clusters, Availability Groups and Always On.

· Strong experience in Performance Tuning and Optimization (PTO) of SQL Server databases, using native monitoring and troubleshooting tools.

· Must have experience with backups, restores and recovery models for SQL Server.

· Must have experience with SQL Server Replication.

· Must have strong experience on security models (In-transit, data-at-rest, On-fly encryptions) based on data classifications.

· Must have experience in implementing using Azure Key vault and encrypting the DB.

· Strong experience on High Availability (HA) and Disaster Recovery (DR) options for SQL Server, including AlwaysOn Availability groups, SRM cluster etc.

· Must have experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

· Must have experience in implementing operational automation using scripts.

· Must have experience in how indexes are used, missing indexes, index management, type of fragmentations and statistics on SQL Server.

· Must have experience working with Windows server, including Active Directory and proper disk configurations.

· Should be working as an individual contributor, decision maker and take ownership.

· Must have strong experience on T-SQL and PowerShell scripting.

· Must have knowledge on MongoDB installation and configuration on windows operating systems and Linux boxes.

· Basic knowledge on MongoDB security models.

· Basic knowledge on MongoDB On-fly and at-rest configurations and limitations.

· Must have excellent communication and documentation skills.