Ryan Walker Email & Phone Number

5+ years of experience working as a SQL Server Database Administrator for databases in SQL Server 2012 and 2008R2. As well experienced in SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, 2008 and SQL Server 2005 .Experience in installing SQL Server Service Packs, Hot Fixes, and Cumulative Updates, Slipstream installation, Silent installation, Standalone and Cluster SQL Server.Created and managed Databases, Data File and Transaction Log, Multiple Files and File groups using SSMS and TSQL.Proficiency and expert in Backups, Backup Strategy, Recovery, Recovery Model, Restore, Disaster Recovery and Planning.Hands on experience in Log Shipping, Mirroring and Replication.Ability to create and maintain SQL Failover Clusters utilizing Windows Clustering and Always ON.Configured Database Mail, Operators, SQL Server Agent, Alerts, WMI Event Alerts, Credential and Proxy Accounts and Archiving Database Mail history.Work experience in SQL Logins, Windows Logins and Windows Group Logins.Manual and automated Indexes Maintenance, Index Defragmentation using online/offline Index Rebuild or Reorganize, set Fill Factor.Work experience in Performance Monitoring Tools, Database Engine Tuning Advisor, DMVs (Dynamic Management Views) and DMFs (Dynamic Management Functions), Locking and Blocking, Isolation Levels, SQL Server Profiler and Extended EventsExperience in T-SQL writing store procedures, triggers and functions. Experience on SQL Server 2012 upgrade from SQL Server 2008 and migrate oracle to SQL Server.Configured Service Accounts and Service Management, Memory Usage, CPU Usage, Security Settings, and Auditing.Experience in data transformation services like SSIS, DTS, BCP, and Bulk insert. Effective team player, self-motivated, capable of adapting new technology, strong problem solving and analytical skills.

Listed skills include Leadership, Management, Firewalls, Blogging, and 9 others.