Senior Sql Database Administrator

Sr SQL DBA:

8+ Years

Hyderabad

• Create/Delete/Update/Monitor/Manage databases
• Full control over SSIS packages, execution and administration
• Expertise in managing SSAS cubes, data sources, dimensions, measures and hierarchies
• knowledge of SQL Server Reporting Services (SSRS)
• Check for software updates (Patches)/vulnerabilities reported by Security team and apply Patches as necessary
• Backup and restore
• Monitoring SQL server resources with help of perfmon, task manager and DMVs
• Performance tuning and resolving system performance issues
• Code Deployments
• DB refresh /Disk Cloning activites
• SQL jobs Scheduling
• Understand Scope of Work for MySQL Database Environment
• Configure/manage MySQL instances
• Support and manage MySQL logins
• Experience with Performance Tuning and Optimization (PTO)
• Experience with backups, restores and recovery models
• Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Should be able to support Azure PAAS databases like Azure SQL, Managed instance, Postgre SQL, Oracle cloud.
• Migration of SQL data from MS SQL server to Azure SQL using Data migration tool
• Should be able to troubleshoot database connection issues regarding Server firewall, proxy and other networking issues
• Experience in Scripting using SQL cmd and PowerShell
• Automation of sql server activities and alerts configuration.
• Good experience in always on (Fail over) and cluster failover.
• Good understanding of azure networking
• Configure and maintaining of SQL DB pools
• Check for software updates (Patches)/vulnerabilities reported by Security team and apply Patches as necessary
• Backup and restore
• Monitoring SQL server resources with help of perfmon,task manager and DMVs
• Performance tuning and resolving system performance issues
• Code Deployments
• DB refresh /Disk Cloning activities