Sr SQL DBA • November-2022
Description: ● Having 11 + years of experience in SQL Server database administration in Microsoft AZURE SQL Server as MS SQL SERVER 2008 R2, 2012,2016 (Database Administrator) ● Experience on configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation. ● Strong experience on identifying and troubleshooting database health, integrity checks and fixing them. ● Implemented Transparent Data Encryption in Production and non-production environment (TDE) ● Implemented Always On encryption in Production environment. ● Experienced in setting up high availability and DR options like log shipping, mirroring, replication (Transactional or Snapshot) and Always on Availability Groups. ● Experience in Database Migration, Migrated SQL Server 2008R2 to 2012 and to 2016. ● Well experienced in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV's. ● Experience in implementing SQL Server security and managing permission to the Database through Database roles, Creating Users and Logins. ● Hands-on experience in maintaining SQL Server Clustering (Active-Active/Active-Passive). ● Experience in troubleshooting and performance tuning by using activity monitor, performance monitor, DBCC, DMVs. ● Experienced on working with production Servers and 24 x 7 On-Call environments. ● Applied Service Packs and security updates for SQL server instances. ● Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills as well as flexibility to learn advancements in the IT industry.