Matthew McNallan

Qualifications and Technical Skill Sets

● Professional Database Administrator/Developer with 22 years of experience developing and architecting relational databases.

● Database administration, development & support of MS SQL Server in production & development environments including Sox compliant servers with a focus on automation and redesign of database architecture and stored procedures to streamline processes and data integration for business needs.

● Extensive experience with SQL Server 2019/2016/2014/2012/2008/2005/2000 database server installation, backup/restore, troubleshooting and performance tuning on 24/ 7 systems.

● Used DMVs, triggers and system procedures for troubleshooting.

● Experience writing & optimizing T-SQL scripts, especially complex stored procedures and functions used in ETL and business processes for backend, reporting and end user systems.

● Adept at using T-SQL: Stored procedures, functions, triggers, views, foreign keys, indexes & constraints.

● Very familiar with complex SSIS packages.

● Solid theoretical understanding of relational database concepts including normalization and integrity.

● Experience with High Availability failover solutions such as clustering and log shipping. High Availability

(HA) groups.

● Migrating data from Oracle to SQL Server.

● Use of IBM Cloud and Windows Azure as a platform for hosting SQL (DaaS - Data as a Service)

● Database architecture, modeling, design, administration, management, and programming.

● Strong communitor and team player.

● Project management knowledge and skills.

● MCSD, MCAD.net.

● Industry experience includes- insurance, government (federal and state), retail and health care.

● Working with Redhat Openshift, Kubernetes, Terraform, Go, and Rust to further develop DevOps for the Cloud landscape

Databases

MS SQL Server 2000/2005/2008/2012/2014/2016, T-SQL, SQL, Replication, Clustering, Log shipping, Database Mirroring SSIS/DTS, SQL mail/DBMAIL, Analysis services, XML in SQL2000/2005/2008, Enterprise Manager, MS ODBC 32 for Win NT/95, SQL Server driver.

Database Tools

SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio, SQL Server Enterprise Manager, SQL Server Query Analyzer, Index Tuning Wizard, DTS Import/Export, SSIS, SSAS, SSRS, OLTP, OLAP, Business Objects, Oracle 10g, SQLBACKUP, IDERA, VMware

Development skills Transact SQL (T-SQL), SQL, Visual Studio 6.0, Visual Basic, C#, Python Data Modeling Microsoft Visio.

Reporting Tools SQL Server Reporting Services, MS Excel, MS Access Operating System Windows 95/98/XP/NT/2000/2003, MS DOS Scripting Language Power shell

Professional Experience

2019 - 2020 TEKsystems/Microsoft (contract)

CXP FastTrack Sustainment Engineer

Roles and responsibilities include:

● Analyzing stored procedures, agent jobs, cpu cycles, memory consumption, disk i/o and volume

● Developing and implementing index strategies for all in-scope SQL Server RDBMS. Cube systems

● Assist DBA with anything required during outages and other critical times.

● Working with architects and developers on code practices and environment maintenance.

● SSAS, SSIS, Azure Data Factory, Machine Learning, Python, Azure DevOps 2015 - 2019 TEKsystems/DaVita Kidney Care (contract) Database Specialist

Roles and responsibilities include:

● Prod-Ops, Dev-Ops, & SAN management.

● Strategically moving databases to different LUNS.

● Table partitioning/administering security in accordance with SOX and DaVita Village policies.

● Performance evaluation including index evaluation, execution plans, object definitions and T-SQL best practices.

● Point of communication for the SQL DBA team on the Team Foundation Services project.

● SME for two large, mission critical systems named Snappy and Falcon Dialysis.

● Upgrades from 2000/2005/2008/2008R2 to 2012/2014.

● Currently the lead DBA on multiple large scale upgrade projects to SQL 2016.

● Production support for SSAS cubes.

● Windows OS Administrator on the clinical blade server.

● Developed proof of concept for role-based provisioning using a two-tiered solution with Active Directory. This model is now implemented for a specific scope of production servers with a full production rollout in progress.

● Mentored the CCS team DBA lead, together we stabilized a once unreliable enterprise performance environment for the organization’s largest systems.

● Developing a prototype for doing automated SQL Server object deployments.

● Stakeholder for multiple upgrade projects, versions 9.0/10.0/10.5 to versions 11/12/13. DevOps participation for multiple application team efforts.

● Microsoft Data Migration and Database Advisor for upgrading older versions (8.0 - 10.5) to later editions

(11.0 - 13.0)

● SQL Profiler and server side tracing

● SQL Server Analysis services supporting Cubes for the Megalab data warehouse

● Support for a relational data warehouse hosting close to 30TB of msf and ldf files 2014 TEKsystems/USDA NRCS (contract)

Development DBA

Roles and responsibilities included:

● Administered pre-production databases primarily for watershed applications.

● Wrote complex T- SQL ETLs to import data from Microsoft Excel documents into the RDBMS.

● Supported database needs for multiple environments within development, test, QA and UAT.

● Prepared T-SQL scripts for modifying and maintaining production schemas and data.

● Was responsible for SSIS, SQL code and T-SQL routines.

● Monitored database events and proactively optimized system performance as needed.

● Set up automated backups of development databases.

● Using Redgate SQL Compare, verified schemas among database environments as well as deployed appropriate changes.

● Using Redgate SQL Data Compare, verified metadata and data among database environments as well as deployed appropriate changes.

● Wrote complex TSQL scripts for data migration, including matching, pivoting and CTE’s ● Used SSIS for ETL processes with MS Excel.

2005 - 2013 Mayo Clinic

Senior Analyst Programmer

Roles and responsibilities included:

● Developed and maintained in house written .NET applications for the Electronic Commerce - EDI Unit.

(VB, ASP, and XML language for the middle tier and user interface applications). Both Windows and Web applications were supported by MS SQL 2008 R2.

● Provided administration on the DB end within the server/instance level.

● Created SSIS packages, user privileges, promoted objects such as indexes, stored procedures, user defined functions, tables, and keys.

● Provided Citrix server support and user administration.

● X12/ANSI support for the 837,835, 997 and 999 transaction sets.

● FTP administration.

● Team representative for the Sarbanes-Oxley External Controls initiative. Education

● 1994 - 1998 University of Wisconsin – La Crosse

B.S., Business Administration - MIS.

● Currently taking Azure courses online through Udemy and Edx. I’m also currently enrolled in my third online class for developing with Ethereum. I just began a Quantum Computing course; a partnership between Microsoft, Google and Brilliant.org.

Contact this candidate