Sql Database Administrator
CurrentConduct regular health checks using tools like SSMS and advanced monitoring solutions.Monitor error logs, disk space, and critical performance metrics (CPU, memory, and I/O).Troubleshoot and resolve failed jobs, ensuring smooth operations (Agent jobs).Verify and confirm successful execution of database backup jobs.Perform scheduled full, differential, and transaction log backups.Test and validate restore procedures to ensure compliance with RTO/RPO goals.Execute point-in-time recoveries as needed by business requirements.Diagnose and optimize slow-running queries with tools like SQL Profiler, Extended Events, and Query Store.Rebuild, reorganize, or design new indexes to improve database performance.Resolve performance bottlenecks, including blocking and deadlocks.Create, audit, and manage user roles, permissions, and access control.Apply SQL Server patches and updates to address vulnerabilities.Respond to security alerts from monitoring tools to protect database integrity.Investigate and resolve connectivity and availability issues.Diagnose and address crashes, downtime, or unexpected SQL Server behavior.Fix schema-related problems, such as missing tables or column mismatches.Ensure data integrity through DBCC CHECKDB.Assist application teams with data cleanup to maintain database accuracy.Remove duplicate records and orphaned data to optimize storage.Develop and manage SQL Server Agent jobs to streamline routine tasks.Write PowerShell and T-SQL scripts to automate monitoring and reporting.PROJECT WORKMigrated critical databases with zero data loss, performing full testing to verify application functionality post-migration.Set up and monitored Log Shipping for automated backups and recovery.Designed and implemented SQL Server Replication (Transactional and Merge) for data consistency across systems.Communicate and Contribute to planning for new applications, upgrades, and database scaling
