Katherine McCoy

817-***-****

SKILL

EXPERIENCE

MS SQL Server DBA

20+ years

EDUCATION

NCU, Doctorate's Degree (1.3 years but not completed) – Information Technology

AIU, Master's Degree – Information Technology

Notre Dame, Masters/Executive Graduate Certification – Business/Negotiations

Villanova, Masters/Executive Graduate Certification – Project Management

AIU, Bachelor's Degree – Information Technology

UTA, Senior status (4 years) – Physics, Mathematics, Computer Science

OTHER EDUCATION/CERTIFICATION

Project Management

Executive Negotiations

MCP-Windows

MCP-Database Administration SQL Server: 70-764 (Experienced through 2019)

MCP- Formal training Certification by Microsoft Provider in 70-765

MCSE

MCTS SQL certified through UTA

A+

Kenexa Prove it Test: Scored above average on both the MSSQL DBA AND Developer’s.

EXPERIENCE

Motion Recruitment 8/2021-8/2023

Senior SQL DBA

Full Stack with focus on MSSQL Sr. DBA. Development included trouble shooting/recoding C#, Powershell (dbaTools), SSIS, SSRS, and WebFocus

Administered roughly 150 MSSQL Servers in extremely fast paced environments. SQL 2012 – 2022.

Independently built, installed, and configured approximately 60 servers for migration from lower versions which included Always On, Clusters, Stand Alone servers running Developer, Standard, and Enterprise editions.

Microsoft DMA

Azure migration

Replication across multiple domains.

Backups, Restores, Ola Hallengren, CommVault, EMC Dell.

Responsible for maintenance, integrity checks, application SQL jobs involving extensive TSQL code, archiving, etc.

Auditing: Automated audit logging from traces.

Idera SQLDM, Idera SQLCM

Performance tuning

Service Now

Documentation for projects, configurations, and overall environmental systems

NPI 08/2020– 6/2021

Senior SQL DBA

Analysis, Design, Development, Unit Testing, Production Deployment and Support of database systems.

Converted Access systems to Syspro and SQL Server. I converted and optimized over 30 Access queries to SQL Server stored procedures.

Gathered business requirements from accounting and manufacturing to design, develop, test, and implement stored procedures for automated annual service maintenance invoices.

Responsible for performance tuning activities.

Responsible for maintenance, backups, integrity checks, etc.

Note: Please view my previous positions to understand more of my talents.

Inspirus 06/2019 – 7/2020

Database Engineer IV

Interpret and gather requirements from Business stakeholders and convert the requirement to various database strategies and implementation across all lower environments as well as Production.

Analysis, Design, Development, Unit Testing, Production Deployment and Support of database systems.

Provide advice and support to development teams, work closely with rest of the development teams.

Responsible for performance tuning activities.

MS SQL Server, PostgreSQL and MySQL: SSMS, SSIS, SSRS Administration and Development

AWS, Aurora, RDS, EC2, S3, AWS Powershell,Subnets,

Performance Optimization and troubleshooting: Indexes, wait types, deadlocks, extended events, system health, profiler, traces.

Policy Base Management Policies

ETL, TSQL, Replication, Clustering.

MS SQL installation and upgrades ranging from SQL 2014– SQL 2019.

Maintained and monitored (SQL Jobs, Security, patches, backups, and restores, SQL Safe Refresh, Post-Scripts, and Developed Scrub scripts)

Migration of on-premise data to AWS.

PowerShell - automated scripts to migrate data to AWS. Shell, DOS, Java, BCP etc.

Jira/Agile/Confluence, Track-it, Windows Administration, VMware, and various office related software.

Independent TSQL Development included application stored procedures, automated scrub development, deletion of client data, report procedures, complex calculated algorithms for triggers, SQL Jobs, etc.

Foglight, SQL Safe, and numerous other 3rd party software, Git Lab (Similar to Git Hub)

Santander Consumer USA 10/2018 – 5/2019

Database Engineer IV

MS SQL Server and Oracle Administration/Development: SSMS, SSIS, SSRS, and some SSAS.

Azure.

Indexes, wait types, deadlocks, extended events, profiler, traces.

ETL, TSQL, Replication, Clustering.

MS SQL installation and upgrades ranging from SQL 2008 – SQL 2016.

Maintained and monitored (SQL Jobs, Security, patches, backups, and restores, Appsync Refresh, Post Scripts).

FTP/SFTP (BCP/Flat file transfer).

PowerShell, Shell, DOS, Visual Basic, BCP etc.

Windows Administration, VMware, and various office related software.

Splunk, DDBoost, Data Domain, Ola Halengren, VS Data and Schema Compare, Beyond Compare, etc.

CITI 5/2015 – 3/2018

Infrastructure MS SQL Management Technical Lead

MS SQL Server/Development: SSMS, SSIS, SSRS, and some SSAS.

SQL as a Service, MyCloud.

Indexes, wait types, deadlocks, extended events, profiler, traces.

ETL, TSQL, Mirroring, Replication, Log Shipping, Always On, Clustering.

MS SQL installation and upgrades ranging from SQL 2008 – SQL 2016.

Expert with Disaster Recovery (able to automate with TSQL and integrate with applications).

Maintained and monitored (Security, patches, backups, and restores, etc).

Policy Base Management Policies

SFTP (BCP/Flat file transfer).

FTP (BCP/Flat file transfer).

PowerShell, Shell, DOS, Visual Basic.

Windows Administration, Linux, Unix, VMware, and various office related software.

Ola Halengren, RedgateSQL Compare, VS Data and Schema Compare, Beyond Compare, etc.

Visio.

RIG DATA/OPS/DAEGIS 3/2012 – 4/2015

MS SQL DBA (Contract)

MS SQL Server and Oracle Administration/Development: SSMS, SSIS, SSRS, and some SSAS.

AWS, Azure.

Indexes, wait types, deadlocks, extended events, profiler, traces.

Fox Pro to SQL 2008 R2 Migration.

SSRS Automation.

ETL, TSQL, Mirroring, Replication, Log Shipping, Always On, Clustering.

MS SQL Installation and upgrades ranging from SQL 6.5 – SQL 2014.

Expert with Disaster Recovery (able to automate with TSQL and integrate with applications).

Maintained and monitored (Security, patches, backups, and restores, etc).

Indexes, wait types, deadlocks.

SFTP (BCP/Flat file transfer).

FTP (BCP/Flat file transfer).

ASP.Net (web services - XML).

.Net, PowerShell, Shell, DOS, Visual Basic, BCP etc.

Windows Administration, VMware, and various office related software.

Native SQL Backups, Lite Speed, Foglight, Redgate, Visual Studio, Visio.

Verizon IT Management 9/1998 – 11/2012

System Architect/DBA/Develop – Technical Lead

Developed, tested, implemented and supported Verizon's Central Office telephone equipment order transactions that traversed between CCP (Creation Capacity Procurement –Telephone Equipment Ordering Application), Msolv

(Logistics/Warehouse), SAP and external vendors using webMethods 6.5–7 on a

Unix/AIX platform.

Responsibilities included data transfer using Microsoft platforms so skills varied.

Used all versions of MS SQL from SQL 6.5 through SQL 2008.

Installed MS SQL 2005 and 2008 versions and initiated BI utilization of SSIS/BIDS.

Administered, developed and supported billing servers and applications in Massapequa, NY.

This included both advanced SQL programming and administration for large business billing data including accounts such as the federal government.

Administration included regularly managing, testing and implementing SQL patch updates, user and group security enforcement, maintenance and backup jobs, email notifications upon errors, etc.

Successfully upgraded MS SQL 6.5 servers (objects, data, scripts, etc) to MS SQL 2000.

Began Verizon career as a lead in web development and SQL administration for the Verizon Pava PMO technical team.

During this time, built the SQL server from scratch.

Was a team lead for AAIS implementation team's technical support, administrator and software/hardware support.

Technical advisor and lead web developer.

Reported to managers and directors when evaluating and planning critical issues.

Facilitated Conference Calls regarding issue management with Directors.

Linked to Oracle 11g and fundamental SQL Plus.

Analyzed and organized daily schedules involving routine activities, PC and Server deployment/inventory, work oriented travel itineraries and cost evaluation for staff.

Nominated employee of the month for independently upgrading webMethods 6.5 to webMethods 7.

Upgrade included TN, IS and Developer installations, all database and application configurations.

Successfully completed many Unix, Windows and SQL Server builds and upgrades.

Designed, wrote, tested and implemented various small and large applications.

Technologies: Cold Fusion, Visual Basic, Java, Java Script, NetApps, Connect Direct, Sun Solaris, Legato, NDM, Linux, PC Anywhere, Lotus Notes, Exchange/Outlook, MS Power Point, MS Project 2000, Visio, Microsoft Suite

Warrantech 5/1998 – 9/1998

OS and PC Hardware Support

Windows 95 OS Troubleshooting and Support.

Windows NT OS Troubleshooting and Support.

Mac OS Troubleshooting and Support.

Hardware Troubleshooting and Support.

Responsible for troubleshooting and repairing operating system and hardware for any PC or laptop that was under warranty with Warrantech.

This work included both Windows and Mac OS environments.

Pier 1 Imports 3/1997 – 4/1998

Point of Sale Deployment and Support

Systems configuration and installation of all hardware and software involving 900 retail networks.

Technical support to 2000+ end users.

Assisted Unisys, Comdisco, Sac, IBM and GE technicians with troubleshooting and installing the 4690 Operating System.

Successfully assisted in the deployment and support of the new Y2K Point of Sale System.

Technologies: Telxon, Cisco Router, CSU/DSU WIC, Harmonics Retail Integrated Module, APC, Oneac, Panasonic Phone System, AT&T Phone Boards, 4694/4693 IBM Computer, 6885/6887 IBM PC, Ethernet Links, Lexmark Printer, HP Printer, IBM Monitors, Windows NT, Bunyar, MS Exchange, MS Outlook, Rumba 95, WinRop, MS Word, EA

TECHNICAL SUMMARY

Planning and Gathering System Requirements

SQL Server 6.5 – SQL 2019

SQL SSMS

SQL SSIS/BIDS /DTS/Data Tools

SSAS and SSRS

SSMS Links (Stored procedures/TSQL scripts/SQL Jobs/MS SQL and Oracle)

Workbench

MySQL

PuTTy

PostgreSQL

AWS RDS, EC2, S3, Routing Tables, Public and Private Subnets, Internet and NAT Gateways

SQL Azure (MSSQL)

Replication (Mirroring, Clustering, Publish/Subscribe)

MS SQL Installation and upgrades ranging from SQL 6.5 – SQL 2017

Maintaining and monitoring (Security, patches, backups and restores)

Linking to Oracle 11g and fundamental SQL Plus

Database Architecture and Design

OleDB, ODBC, ADODB

Powershell

Visual Studio

Can read and write in numerous programming languages but master of none except structured query languages. (C#, C, VB, Perl, Java, Powershell, etc)

SFTP (BCP/Flat file transfer)

FTP (BCP/Flat file transfer)

ASP .NET and C# (web services – XML)

webMethods administration and development (XML/EDI/Java – TN, IS and Administrator)

Windows NT thru Windows 8 Administration

Visual Source Safe

Unix/AIX

Shell/Dos script

IIS

VPN

SharePoint

SQL6.5-2019, SQL, Web Methods, ASP, ASP.NET, A+, MCP: NT 4.0Enterprise, NT 4.0 Server, and NT 4.0 Workstation Certified. All Windows OS (NT-2008), Unix/AIX, DOS, VAX, Lotus, Access, Excel, Programming in Pascal, C, C++, C# Java, Oracle 8i, MS Power Point, MS Project 2000, etc.

SUMMARY

Worked in IT management for over 20 years. Masters in Information Technology and more than a year towards a Doctorate Degree in IT. A+, MCP, MCSE certified, and MCTS SQL trained. Most recent responsibilities included:

MS SQL Server and Oracle Administration/Development: SSMS, SSIS, SSRS, and some SSAS.

Provisioning SQL to the Cloud: Azure and AWS

ETL, TSQL, Mirroring, Replication, Log Shipping, Always On, Clustering

MS SQL Installation and upgrades ranging from SQL 6.5 – SQL 2017

Expert with Disaster Recovery (able to automate with TSQL and integrate with applications)

Maintaining and monitoring (Security, patches, backups, and restores, etc)

SFTP (BCP/Flat file transfer)

FTP (BCP/Flat file transfer)

ASP .NET (web services – XML)

webMethods administration and development (XML/EDI)

Java, Cold Fusion, .NET, PowerShell, Shell, DOS, Visual Basic, BCP etc

Windows Administration, Linux, Unix, VMware, and various office related software

Appsync, DDBoost, Data Domain, Lite Speed, Ola Halengren, RedgateSQL Compare, VS Data and Schema Compare, Beyond Compare, etc.

More in depth responsibilities included developing, testing, implementing, and supporting Santander’s and Citi’s MS SQL Servers internationally and previously Verizon's Billing and Central Office telephone equipment orders that traversed from external businesses to various ERP systems including CCP (Creation Capacity Procurement –Telephone Equipment Ordering Application), Msolv (Logistics/Warehouse), SAP, and external vendors using webMethods 6.5–7 on a Unix/AIX platform. Prior to this, administered, developed20nd supported billing servers and applications in Massapequa, NY. This included both advanced SQL programming and administration for large business billing data including accounts such as the federal government.

HONORS, AWARDS and LICENSES

Magna Cum Laude with both a BS and MS in Information Technology

Cash awards for good performance during crisis situations within Verizon

Award and dinner at the Mansion in Dallas for independent work on webMethods upgrade (data and app)

High School Scholastic Letter and National Honor Society

LEADERSHIP ACTIVITIES

Special Olympics Basketball Coach, previously a Supervisor for Six Flags

Previously a Manager of Tan America

Some Technical Lead positions for Verizon

Helped assist coaches and participate in the Teams in Training for the Leukemia & Lymphoma Society, North Texas Chapter (2006 – present)

Originator of River Legacy Park Fitness and Fun: http://www.meetup.com/River–Legacy–Park–Fitness–and–Adventure

HISTORY ACCOMPLISHMENTS

While with Citi negotiated with 76 different groups from 26 different Latin American countries to help the US gain access to Latin American servers as well as successfully developing, building, and supporting both North and South American MS SQL Servers. The biggest Verizon accomplishment was developing an Issues Manager for the merging of former GTE and former Bell Atlantic to form Verizon. All of the above required extensive technical and communication skills in multiple languages.

Contact this candidate