KAY MILNER

Highly analytical and results-driven IT professional with over 5 years of progressive experience in MSSQL SQL server database administration. Proven success in deployment of effective IT roadmaps, processes, and procedures involving setting up high availability and disaster recovery solutions in SQL such as Always On availability groups, log shipping, mirroring, replication, and traditional failover clustering. Expertise in SQL server upgrade and database migration along with Azure Databases, elastic pools, and new instances installation. 

Directed various day-to-day operations such as SQL Server daily checks, installation, configuration, upgrades, and structure modifications. Oversaw Always On, traditional failover cluster, database mirroring, and log shipping with utmost accuracy. Checked server lease replacement and server decommissioning across the entire data center.

Acted as a subject matter expert while facilitating programmers and engineers to efficiently use database systems, providing application support.

Created and integrated DB backup/restore and disaster recovery strategies on company’s SLA leveraging proven methodologies, ensuring data management and disaster recovery.

Utilized PowerShell scripting to remove local admin rights from all users and performed several monitoring tasks via PowerShell.

Mitigated databases with minimum downtime, fixed overall database access and performance issues, and uncovered anomalies while patching and upgrading database Servers and Windows Servers.

Generated prompt response to tickets, resolved user requests based on priority, and ensured database configuration maintenance in the configuration repository.

EDUCATION 
Kiawitech IT Academy
4807 Sugar Grove Blvd Suite 501
7747 Stafford Texas,USA

Practical Nurse Diploma
Red Deer College

TECHNICAL PROFICIENCIES

SQL Server 2005-2019 | PowerShell | Microsoft Azure | Transparent Data Encryption | Always Encrypted | VmWare | Hyper-V | T-SQL | IaaS | SaaS | PaaS | PostgreSQL | ClickHouse | Bash Scripting | Python | Terraform | Kubernetes | Database Design | Database Replication | Database Management | Performance Tuning | Disaster Recovery | Security | Devops