Responsibilities
SQL Server DBA () in Production Development and Staging Environments
24/7 on Call Support for Production Database.
Experience in Upgrades Patches Configuration and Administration for SQL Server.
Experience in Setting up (HA) High Availability solutions like Availability group.
Experience in Troubleshooting Backup and Restore of Databases.
Refreshing the DB from Prod to staging/Development environment.
Experience in upgrading SQL Server software to new versions applying Service packs & hotfixes.
* Experience in scheduling Backups and Restore Maintenance plans using SSMS.
* Expertise in Scheduling Database tasks Jobs Alerts Emails Notification.
* Extensive experience in controlling the User Privileges Monitoring the Security and Audit issues as per Standards.
* Strong Communication & Management skills and Excellent Team player.
Experience in solving Database issues with Index fragmentation DBCC checks Optimization of Query Index tuning Update Statistics.
* Experience in Migrating the SQL server from lower versions (2008R) to the higher version (2016).
Experience in fetching the Bak files of RDS by Creating IMA role and option groups.
* Experience in troubleshooting the high CPU usage.
* Having little knowledge of Azure SQL managed Instances.
* Experience in migrating onprem data from to Azure cloud & azure data factory.
Requirements
Experience: 48ys of exp
Qualification required: B.tech/M.tech/BCA/MCA qualified having minimum 3 years of experience up to 5 years as an SQL Database Administrator
SQL Database Administrator (SQL DBA), SQL Server, Database Administration, Performance Tuning, Query Optimization, Index Management, Backup and Recovery, High Availability (HA), Disaster Recovery (DR), Database Security, SQL Server Management Studio (SSMS), T-SQL (Transact-SQL), Stored Procedures Technical Keywords: SQL Server Installation, SQL Server Configuration, SQL Server Clustering, SQL Server Always On, Replication, Mirroring, Log Shipping, Data Integrity, Database Design, Partitioning, Database Monitoring, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)