Logo
SysMind Tech

Senior SQL DBA

SysMind Tech, Tampa, FL, United States

  • 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.