| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Software Engineer SQL, Database management, Tableau, Data Analys Cincinnati, OH Sql Server C# Stamping Ground, KY Tibco Developer Sql Server Mason, OH Support Specialist Financial Services Loveland, OH Customer Service Information Technology Hamilton, OH Customer Service Data Storage Cincinnati, OH Data Engineer/ ( Azure, AWS, Python, SQL, ETL, Tableau, Snowflak Fairborn, OH |
|
Click here or scroll down to respond to this candidateCandidate's Name
Sauk Rapids, MNStreet Address PHONE NUMBER AVAILABLE EMAIL AVAILABLEProfessional SummarySQL Database Administrator with 6 years of experience excelling in database administration and optimization. Proficient in Microsoft SQL Server, disaster recovery, and high availability solutions, achieving a 99.9% uptime. Experience in ETL and data technologies including SSRS, SSIS, DataFactory and PowerBI.Technical skills and toolsDatabase Management Systems: SQL Server 2014/2017/2019/2022High Availability (HA) and Disaster Recovery solutions, always on availability Groups, Replication, and Log ShippingKnowledgeable in T-SQL programming, PowerShell Scripting, and automationInstallation, configuration, Capacity and Security ManagementExperience in Database Backup and Recovery, Upgradation, Patching, Monitoring and MaintenanceKnowledge of SQL Server, Windows Server, Active Directory, and networking fundamentalsOptimization and Performance TuningRedgate, SolarWinds, IderaDevOps and CI/CD with Azure DevOpsWorking knowledge and experience with Microsoft Azure database servicesWork HistorySQL Server Database Administrator, 06/2021 - CurrentInfosys Providence, RIAdministered all daily MS SQL database functions, including installation/configuration, upgrade, patching, security, user provisioning, performance/systems troubleshooting and tuning, and backup and recovery management.Implemented a comprehensive backup and recovery strategy, achieving a 99.9% data availability rate and meeting the company's SLA requirements by incorporating Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) into the plan.Designed and implemented high availability solutions including AlwaysOn and log shipping, enhancing system uptime to 99.9% and minimizing potential downtime of critical applications.Streamlined database maintenance procedures through automated scripts, reducing manual check times by 15 hours monthly; allowed for greater focus on strategic database enhancements and optimization efforts.Conceived a regular schedule for database index tuning, optimizing 50 key queries each quarter; directly contributed to a 20% reduction in processing times for critical business operations.Established a monitoring system for database performance metrics, allowing for real-time adjustments; this initiative led to a 30% improvement in resource allocation efficiency and reduced system bottlenecks.Optimized SQL Server performance through strategic database tuning initiatives, resulting in a 30% reduction in service outages, while ensuring on-call support availability during weekends to maintain uninterrupted service for over 500 users.Executed comprehensive troubleshooting procedures during SQL Server outages, achieving a 25% decrease in downtime duration, which directly contributed to maintaining service levels for over 200 daily transactions.Conducted detailed evaluations with Database Migration Assistant, facilitating the migration of 10+ databases; minimized disruptions and achieved a 99.9% success rate in maintaining data accuracy during the process.Developed and executed a data security strategy that integrated role-based access controls and encryption techniques; resulted in securing sensitive client data, reducing unauthorized access attempts by 70%.Analyzed stakeholder interactions and refined database requirements gathering processes; decreased ambiguity in project scopes and improved accuracy in project estimates, leading to a 20% increase in on-time project delivery.Database Administrator, 03/2018 - 04/2020Equinity IT Minneapolis, MNSpearheaded the comprehensive installation and configuration of Microsoft SQL Server versions 2014 to 2019 across 15 databases, enhancing data retrieval times by 40% and improving overall system performance.Leveraged tools like Dynamic Management Views (DMV), SQL Profiler, Tuning Advisor, and Performance Monitor for analysis and resource evaluation.Defined comprehensive data security protocols that included user creation, permission assignment based on least privilege principles, and encryption technologies; enhanced protection of sensitive client data, achieving a 40% reduction in security incidents.Configured and monitored AlwaysOn and Failover clustering for a critical database system, achieving a 99.9% uptime, which enhanced overall system reliability and reduced downtime incidents by 40%.Proposed a comprehensive database backup schedule that resulted in nightly backups for over 20 databases which improved disaster recovery capabilities and reduced downtime by 40%, safeguarding critical business operations.Revamped index optimization processes by adopting Microsoft best practices, resulting in a 40% reduction in query response times and increasing overall database performance for 500+ users across the organization.Designed a robust data warehousing architecture that supported real-time analytics, leading to a 40% decrease in data retrieval time and enabling faster decision-making for upper management.Refined and modernized ETL pipelines utilizing Azure Data Factory, leading to a 30% increase in workflow efficiency.EducationBachelor of Science in Engineering: 05/2021University of North Dakota - Grand Forks, ND |
