Senior SQL DBA

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. Must have the ability to work well in a team environment and follow standard operating procedures.