Senior IMS DB Developer • July-2021 to June-2024
Description: Involving in a team & daily checking the tickets assigned and resolve the tickets depends on the Priority levels within the SLA. Experience in Installing, Configuring, Monitoring and troubleshooting SQL Server 2008,2012 ,2014,2016,2017. Take cares in troubleshooting and resolving database Integrity Issues, Performance Issues, Blocking and Deadlocking Issues, Log Shipping Issues, Connectivity Issues, Security Issues Take cares Performance Tuning and Optimization (PTO), using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools detect and troubleshoot SQL Server related CPU, Memory, I/O, Disk Space and other resource contention Responsible fore on backups, restores, recovery models, database shrink operation, DBCC commands, Database Mirroring Responsible for High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server such Replication, Failover Clustering, Always on High availability Take care how indexes, index management, integrity checks, statistics work, how indexes are stored, how they can be created and managed effectively Knowledge of SQL Server tools (Profiler, SSMS, Configuration Manager, Perfmon, DMV’s, system procs) Working Knowledge of third-party tools like LightSpeed, Commvault Installation & configuration of SQL Server 2008/2008 R2/2012/2014/2016 standalone and Cluster environment (Active-Active \Active -Passive)