As the Senior DBA, I am Dedicated SQL Server DBA with nearly 7 years of experience in optimizing database environments for performance and reliability. Skilled in all aspects of SQL Server administration, including installation, configuration, maintenance, and disaster recovery planning. Known for proactive problem-solving and effective communication with technical and non-technical stakeholders.Key Achievements:Successfully led database migration projects, ensuring smooth transitions with minimal disruption to operations.Implemented robust HADR strategies, enhancing system reliability and minimizing downtime during critical events.Provided guidance and mentorship to junior DBAs, contributing to team development and performance improvement.Proactively resolved database issues, ensuring optimal system performance and minimizing business impact.Technical Skills:SQL Server Administration (Installation, Configuration, Maintenance)High Availability Disaster Recovery (AlwaysOn, Replication, Log Shipping)Performance Tuning and OptimizationBackup and Restore ProceduresDisaster Recovery Planning and ExecutionScript Development and Optimization (Stored Procedures, Triggers, Functions)SQL Server Security ImplementationExternal Tools (Redgate, DBA Tools)Task Management Platforms (ServiceNow, Jira)Available for 24/7 on-call support, including monitoring, installs/patches, migrations, etc., in rotation with other team members.

- Proficient in installing, upgrading, and configuring SQL Server Suite, including SSIS and SSRS services.- Developed and executed automated SQL test scripts for software integrity and reliability. Managed over 200 database servers across multiple environments.- Applied patches, service packs, and hotfixes to maintain and update SQL Server versions.- Implemented AlwaysOn High Availability and configured HADR solutions for system resilience.- Designed and participated in database recovery plans and disaster recovery drills.- Created server logins, database users, and custom roles to control data access.- Optimized storage space management through data compression and backup strategies.- Utilized tools like Red Gate, SQL Compare, and Data Compare for schema comparisons.- Conducted database health checks using DBCC Utilities to prevent corruption.- Enhanced system performance through index management based on fragmentation levels.- Developed SSIS packages for data integration across production servers.- Configured DB SMTP mail and alert systems for timely notifications.- Migrated databases to new servers with minimal downtime.- Skilled in SQL Server Reporting Services (SSRS) for report generation.- Managed Change Management requests for system stability and compliance.- Developed stored procedures and PowerShell scripts for database automation.- Monitored real-time database events with Change Data Capture (CDC) tool.- Created and maintained maintenance plans for system optimization.

- Proficient in installation, configuration, administration, and maintenance of SQL Server instances.- Skilled in performance monitoring, tuning, index maintenance, and updating statistics for optimal database performance.- Experienced in SQL Server Reporting Services (SSRS) for report generation and management in - Competent managing user logins, object permissions, and server/database roles to ensure security.- Utilized diagnostic tools like SQL Server Activity Monitor and Extended Events for identifying and resolving performance issues.- Involved in migrating SQL Server 2014 databases to SQL Server 2016.- Created maintenance plans and jobs for maximizing database performance.- Proactively managed patching and upgrading of database systems with minimal disruption.- Proficient in data import/export using tools like Bulk Copy Insert (BCP) utility.- Skilled in troubleshooting day-to-day issues and monitoring error logs.- Conducted routine database maintenance tasks for optimal performance and reliability.- Optimized query performance by modifying T-SQL queries and establishing indexes.- Experienced in data integration using DTS and SQL Server Integration Services (SSIS).- Configured data and table partitioning for improved performance on large tables.