Manage and administer SQL Server databases for CSI Group supporting over 500 servers and 10,000 databases.• Perform SQL Server installation, configuration, and upgrades across multiple environments, ensuring optimal performance and high availability using Always on Availability Groups and database mirroring.• Collaborate closely with software development teams to optimize database schema designs for new applications and features, ensuring scalability and performance.• Perform regular database health checks and performance tuning activities to maintain optimal database performance and stability.• Implement and maintain database security best practices, including access controls, data encryption, and regular security audits.• Troubleshoot and resolve database-related issues, ensuring minimal impact on business operations and customer facing services.• Participate in cross-functional teams to plan and execute disaster recovery drills, ensuring data availability and business continuity in case of emergencies.• Implement proactive monitoring strategies using SQL Profiler and Performance Monitor, reducing downtime by 20% through early detection and resolution of performance bottlenecks.• Evaluate and recommend database technologies and tools to enhance operational efficiency and meet evolving business requirements.• Stay updated with industry trends and best practices in database administration, implementing new methodologies and technologies where applicable.

Managed SQL Server databases totaling 50+ instances across production, development, and testing environments, ensuring optimal performance and availability.• Implemented high availability solutions such as SQL Server Always on Availability Groups, reducing downtime by 30%.• Conducted performance tuning and optimization tasks resulting in a 25% improvement in database query response times.• Collaborated with development teams to optimize database schemas and queries, improving application performance and reducing resource consumption.• Implemented database maintenance plans and scheduled jobs to ensure data integrity and system reliability.• Participated in quarterly security audits and implemented recommendations to enhance database security posture.• Provided on-call support and responded promptly to database-related incidents, ensuring minimal disruption to business operations.• Conducted regular capacity planning exercises to forecast database growth and resource requirements, supporting scalability initiatives.• Developed and maintained PowerShell scripts for automation of routine database administration tasks, increasing operational efficiency by 40%.• Oversaw database security including user access management and encryption protocols, ensuring compliance with company policies and industry standards.

Designed, developed, and administered MS SQL Server environments spanning versions 2008 to 2014.• Monitored SQL health, identified issues, and implemented fixes to ensure optimal performance.• Utilized SQL Indexes to enhance query performance, reduce storage needs, and lower maintenance costs.• Installed, configured, and upgraded SQL Server installations.• Planned and executed database backup, restore, and disaster recovery procedures.• Implemented Log Shipping for data redundancy between Primary and Standby servers.• Created and maintained SQL objects such as Tables, Views, Stored Procedures, Constraints, and User Defined Functions.• Configured Windows Server Failover Cluster (WSFC) for high availability setups.• Established and maintained High Availability (HA) and Disaster Recovery (DR) solutions, including large-scale migrations across SQL Server versions from 2012 to 2019.• Managed SQL Server and operating system patching across 50+ environments.• Provided 24/7 DBA support for SQL Server environments, handling 100+ change management tasks, 50+ code releases, and 200+ break fixes annually.• Automated administrative tasks using SQL Server Agent, overseeing 80+ jobs, 30+ schedules, and 1000+ alerts annually, and resolving 95% of troubleshooting incidents promptly.• Installed and maintained SSIS, SSRS, and Power BI for data integration, reporting, and analytics.• Managed server security by assigning logins, roles, permissions, and auditing access.• Implemented disaster prevention and recovery strategies, leveraging features like Clustering, Always On, Log Shipping, Database Mirroring, and Replication.• Proactively monitored and maintained database response times in a 24/7 production environment, generating performance reports as needed.