Description
SQL server database support for microsoft customers
Roles and Responsibilities
Working as a Azure support Engineer and providing the solutions on Azure Iaas SQL platform to MS customers 24/7 over cases, emails and chat support. Experience in troubleshooting various database related issues in multiple customer environments as part of day-to-day activities. Good Experience in deploying SQL vm on Azure, adding Iaas Extension to an existing vm, Experience in configuring single subnet and Multi subnet Always on High availability in SQL vm. Configuring automated backup and managed backups in SQL VM and resolving various backup related Issues. Importing and exporting Databases using .BACPAC methods from Paas servers and managed instances. Experience in SQL server version, edition upgrades and Downgrade. Knowledge on Distributed Availability group and recovering the databases from Disasters and rebuilding of master database. Experience in Log shipping, Database mirroring, transactional Replication and Always on availability groups. Handson experience in configuring and troubleshooting Database mail related Issues. Handling critical sql server performance issues involving slow Running queries, high CPU, Memory utilization and other resource contention, Application slowness due to sql server, disk performance. Troubleshooting various connectivity issues involving applications to sql server, remote sql server connections, between high availability nodes. Assisting customers when facing issues in installing and configuring sql server, Applying latest hotfixes and patches, Edition and version upgrades and downgrades. Troubleshooting configuration issues while building high availability environments involving creating Always on high availability groups, failover clustering, mirroring, replication. Handon experience in configuring and fixing load balancer and failover clustering issues. Having good knowledge on Azure sql server licenses (PayG, HA/DR, AHUB, MPN, software Assurance, CAL, BYOL) and assisting users in clarifying licensing queries in reducing the sql server license costs effectively. Good Experience in Analyzing different types of logs including sql server error, Agent, cluster logs, Event viewer - system, Application, security logs to provide RCA on various issues involving unexpected sql server shutdown, Failover, server slowness. Customer management and teaming skills, supporting customers on phone and written correspondence regarding technical questions and issues, having logical and critical thinking skills
Technologies: Azure sql dba
Industry: Communications and Media