Scott Hanesworth

Kenmore, New York *****

Phone: 716-***-****

adxxbe@r.postjobfree.com

Objective

To find a rewarding career in the Information Technology field that will enhance my professional knowledge and experience.

Qualifications

17 Years Microsoft SQL Server Administration SQL 6.5- SQL 2019

6 Years Citrix Administration 4.5 – Xenapp 6.5

14 Years Server Hardware Maintenance (Dell/HP)

5 Years PeopleSoft ERP Administration

15 Years Microsoft Systems Administration.

2 Years SAN Storage

2 Years SolarWinds Administration

7 Years VmWare Administration/Infrastructure 3.x5.x6.x Work Experience

Delaware North Corporation Buffalo, New York Aug 2019 – Present Senior Database Administrator

Responsible for the support and maintenance of 150+ SQL instances across 5 Subsidiaries

Responsible for designed and Implementation of SQL Server Clusters and AlwaysON solutions on SQL 2014/2016/2019.

Responsible for SQL Server Audits including, Database Locations, License footprint, SQL versions, Resource consumption and security.

Responsible for SQL Maintenance including, security plans, database backups and standard maintenance plans.

Responsible for corporate Amazon RDS instances.

Responsible for SQL 2008 Upgrades and application migrations.

Responsible for SQL server performance tuning and performance. Erie County Medical Center, Buffalo, New York Sept 2017 – 2019 Senior Database Administrator

Oversees and participates in the design and coordination of the implementation of databases suitable for individual applications using all data structures in a multi-activity environment;

Oversees and participates in the monitoring of databases for usage, response, breach of privacy, and potential restructuring;

Manages mass information storage resources by determining the physical placement for all data records incorporated into the database;

Audits database usage for compliance with established standards and participates in compliance monitoring activities, compliance reviews and investigations;

Assists with the establishment of a mechanism to monitor access to protected health information consistent with applicable policies, procedures, laws, regulations and accreditation standards;

Develops, manages and coordinates activities with computer operations for providing back-up and recovery;

Collaborates with other administrative personnel to establish standards for data quality and ethical practice;

Communicates regularly with technical, applications and operational staff to ensure database integrity and security;

Oversees the reorganization and/or restructuring of the database and related components to accommodate physical or logical changes;

Setup and Administer Clustered production SQL 2014 instances.

Reviews both new systems and proposed or requested changes to existing applications which may affect the established database and makes recommendations for change or modification.

Vmware 6.5 administration

Utilant LLC, Buffalo, New York Sept 2014 – 2017

IT Infrastructure Manager/Database Administrator

Design and implement VMWare environments for Corporate, state-side and international production datacenters.

Setup, Manage and ensure effectiveness of physical servers, Dell switches, Fortinet firewalls, Nimble Storage, cloud Infrastructure utilizing vMWare ESXi and associated operating systems and software.

Setup and Administer Clustered production SQL 2014 instances.

Setup and administer customer web servers and sites via IIS 7.

Implement and manage site-to-site disaster recovery solutions with VmWare SRM and SAN replication.Implement and manage enterprise back-up procedures with Veeam.

Implement and Manage Kaspersky Anti-Virus.

Implement and manage information security protocols and change control.

Plan IT projects and project budgets, and resource needs.

Negotiate with vendors and contractors to secure enterprise products and services.

Maintain staff by recruiting, selecting, orienting, and training IT employees; Assist with developing personal growth opportunities.

Assess, approve and administer all IT equipment, hardware, and enterprise software. Practice network asset management, including maintenance of network component inventory, life cycle management and related documentation.

Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.

EarthLink Business, Buffalo, New York Apr 2009 – Sept 2014 Sr. SQL Systems Engineer/ Platform Lead

Technical lead for line of business serving cloud hosted applications, via Citrix, to 400+ companies across the United States and Canada. Core Responsibilities included SQL administration, Change Control, major incident response and management, engineering task assignments, technical documentation, staff training, partner support for process improvement and upgrades, project assessment, and API/WEB/Citrix server technical guidance and support.

Lead DBA for Production environment including; capacity planning, performance analysis, and regular maintenance for 16 SQL 2008 SQL instances, leveled across 8 SQL Clusters, in a heterogeneous VMware ESXi 5 environment.

Responsible for Multi-Regional SQL 2012 Always-On design and implementation, to support national customer portal.

Setup, maintain, and monitor custom ETL processes and daily reporting using SQL SSRS and SSIS packages.

Worked closely with Partner development staff to improve enterprise processes and maintain updates to custom application suite.

Provided SQL Assessment and Remediation plans for EarthLink customers in need of professional SQL services. Assessments included performance analysis, backup strategies, security review, and best practices review. Executed post-remediation services per customer request.

Designed Windows Active Directory structure and conventions in preparation for customer domain migrations.

Responsible for all aspects for publishing partner applications via Citrix in preparation for MetaFrame 4.5 to Xenapp migration.

Setup, maintain, and monitor SQL 2008 replication for customer franchise reporting and financial consolidation.

US Air Force Reserves Feb 1990 – Feb 1996

Desert Shield/Storm Veteran / Honorable Discharge

Education

State University of New York at Buffalo 1992 - 1995

Major – Bachelor of Science

Technical Training

ISC CISSP (Certified Information Systems Security Professional) Training VmWare 5.5 Virtual Services Infrastructure

SQL Server 2012 Administration

2017

2015

2013

Contact this candidate