

Seeking Sr SQL Server Database Administrator role with 11 years of experience in managing and optimizing SQL Server database systems. Proven track record in reducing downtime incidents by 30% and improving data synchronization time by 15% through proactive monitoring and performance enhancements. Expertise in high-availability configurations, query optimization, database architecture, and automation of database performance monitoring. Experienced in procurement processes and project planning for successful software implementations.
Manage 35+ SQL Server database servers across various environments, implementing cost-saving measures that reduce licensing expenses by 20%. Optimize replication processes and resolve over 100 issues, achieving a 15% improvement in data synchronization time. Configure and monitor business continuity and disaster recovery plans for database instances with SolarWinds, leading to a 30% reduction in downtime incidents through proactive alerting and performance enhancements. Conduct requirements gathering and analysis to ensure quality assurance in database operations, producing consistent results amidst emergency situations.
V Provided comprehensive production support for MSSQL database management systems. Designed and implemented Distributed Availability Groups across Azure SQL VMs, enabling over five read-only nodes for ETL, reporting, and application functions. Optimized ETL pipelines in Data Migration processes using Azure Data Factory, enhancing data load efficiency by 25%. V Automated database performance monitoring and data processing issue resolution with custom T-SQL scripts, reducing manual intervention by 35%. Configured resource governance policies to allocate resources based on user priorities, resulting in a 20% improvement in system performance. Engaged in software evaluation for new software solutions to enhance existing database systems.
Developed over 20 SSIS packages for seamless data integration and data modeling from various sources, ensuring error-free ETL processes. Automated incremental data loads with T-SQL MERGE statements, achieving a 30% reduction in daily load times. V Implemented self-service reporting for business users, enhancing data access and usage.
/ Monitored and maintained over 50 SQL Server instances, achieving 99.8% uptime in production environments with robust data management protocols. Improved database reliability by reducing backup failures by 15% through troubleshooting and script optimizations that adhered to coding standards and conventions. V Enhanced efficiency by designing SQL Server Agent jobs, saving 25 hours monthly in manual maintenance tasks And Utilized programming best practices adhering to naming conventions and organization standards.
Developed SSIS packages with enhanced data transformations, achieving a 40% increase in data integration efficiency. Designed SSRS dashboard reports that delivered actionable insights to support business decision-making processes. Y Evaluated new software tools for information processing and reporting enhancement.
Improved database performance by 20% through execution plan analysis and database optimization. Designed over 30 SSRS reports, facilitating the delivery of essential business metrics to stakeholders.