Sql Server Database Administrator

KOKOU KPEDZROKU

Sauk Rapids, MN***** 240-***-**** *****.*********@*****.***

Professional Summary

SQL 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 tools

Database Management Systems: SQL Server 2014/2017/2019/2022

High Availability (HA) and Disaster Recovery solutions, always on availability Groups, Replication, and Log Shipping

Knowledgeable in T-SQL programming, PowerShell Scripting, and automation

Installation, configuration, Capacity and Security Management

Experience in Database Backup and Recovery, Upgradation, Patching, Monitoring and Maintenance

Knowledge of SQL Server, Windows Server, Active Directory, and networking fundamentals

Optimization and Performance Tuning

Redgate, SolarWinds, Idera

DevOps and CI/CD with Azure DevOps

Working knowledge and experience with Microsoft Azure database services

Work History

SQL Server Database Administrator, 06/2021 - Current

Infosys – Providence, RI

Administered 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/2020

Equinity IT – Minneapolis, MN

Spearheaded 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.

Education

Bachelor of Science in Engineering: 05/2021

University of North Dakota - Grand Forks, ND

Contact this candidate