Matthew Velic

Background

About

Matt has been working with SQL Server for seven years, and has experience in database administration, development, and business intelligence. In addition, for the past four years, Matt has been working in an agile, continuous integration environment on the Amazon Web Services (AWS) Cloud. He knows both Windows and *nix server administration, and leads application release and deployments. But it’s not all about him. Matt is a group leader for PASSDC, a SQL Server User Group, which holds monthly meetings for our members to grow their skills and networks.

Work Experience

Database Developer, Sanametrix, Inc.
Dec, 2012 - Present4 years 6 months
- Cloud SQL Server Database Administrator (Amazon Web Services / AWS).
- Responsible for design, creation, and management of new data management system (EDFacts DMS) for the U.S. Department of Education, NCES. The system integrates with the EDEN Submission System via replication, which decreases processing time and enables centralized communications among users.
- Lead ETL developer for new Case Investigation Management System (CMISS) for the U.S. Department of Housing and Urban Development, Office of Inspector General (HUD OIG).
- Consultant on storage and performance administration on over 1.5TB of data for the 2013-14 and 2015-16 Civil Rights Data Collections (CRDC) for the U.S. Department of Education, Office for Civil Rights.
- Custom ETL development in SSIS.
- Release/Deployment Manager for clients’ IT teams.
- Establish and enforce database best practices for development, performance, and maintenance.
- Leads development team towards automation in unit testing and deployment practices.
Finance DBA (Consultant), Democratic National Committee (DNC)
Jun, 2012 - Nov, 20125 months
- Translated business requirements into data exports and reports for fundraising efforts.
- Integrated DNC and Obama for America (OFA) donor data using stored procedures and views.
- 65% increase in performance of SQL Server jobs via tuning and scheduling changes.
- Developed, implemented, and maintained disaster recovery strategies for SQL Server data.
Production Specialist, Navigant Consulting
Feb, 2012 - Jun, 20124 months
- Processed electronic documentation to produce deliverables for litigation.
- Quality Control and delivery management all SEC e-Discovery matters.
- Lead internal SEC team to eliminated four-month backlog of SEC matters.
- Developed disaster recovery and performance tuning strategies for SQL Server data.
Web Developer, Independent Consultant
Apr, 2011 - Feb, 201210 months
- Web developer at Washington Graphic Services, Pearl Knowledge Solutions, and Linchpin People.
Data Administrator, Elizabeth Glaser Pediatric AIDS Foundtion
Jul, 2008 - Feb, 20112 years 7 months
- SQL Server administration included implementing disaster recovery strategies, managing security, monitoring with automated alerts.
- Developed custom ETL and other automated processes.
- Database conversion from SalesForce.com to SQL Server based application.

Education

Fine Art, B.A., George Washington University
Sep, 2002 - Jun, 2006

Volunteer Work

Group Leader, PASSDC SQL Server User Group
Apr, 2013 - Present
Monthly training sessions hosted by PASSDC.
Organizer, SQL Saturday Washington DC
Dec, 2010 - Present
Yearly training event hosted by PASSDC.
Presentation, SQL Server 2016 Launch Event
May, 2016 - Present
Lightning talks about new features in the SQL Server 2016 product. Hosted by PASSDC.
Presentation, Git Cracking on Version Control
Aug, 2014 - Present
Heard you should be using version control but don't know how to get started? Not sure if it's helpful or just an added complication? Jump in and learn Git, one of the most popular open source, distributed version control systems. Not only will you gain code security, you'll be adding a valuable skill to your repertoire. Additionally, learn about some tricks for working with Git in a team environment, as well as how it can help with an automated deployment pipeline.
Presentation, Automating in the Cloud
Jun, 2013 - Present
Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common DBA problems by utilizing Cloud services in combination with PowerShell automation. In this session, we'll review the basic Cloud architecture, as well as some specifics as to the components of the solution.
Presentation, Build your own Virtual Lab
Jan, 2013 - Present
If you don’t have the chance to work on different kinds of projects, it may be tough to grow all the necessary skills to further your career. By building a virtual lab at home, you can take control of the situation. This session will focus on setting up a basic network environment using VirtualBox, free (downloadable) software, and your home computer. It’s aimed towards individuals that aren’t afraid to modify server settings or use the command line. This session is focused mainly on virtualization, networking, and server topics. However, you’ll be in a great position to tackle SQL Server projects, such as clustering or Availability Groups, once complete.
Presentation, Communicate for Great Good
Aug, 2012 - Present
“No one knows what I do.” That’s a chief complaint of data professionals everywhere, and it’s a dangerous position to be in as well. Reviews may not be favorable, promotions more uncommon, and training dollars more rare. But by practicing written and verbal communication, new opportunities may present themselves. This session is for data professionals that are looking for fun activities to grow their written and verbal communication skills.
Presentation, Intro to T-SQL
Jul, 2011 - Present
So you’re ready to dump that Excel “database” and join the SQL Server crowd? Take a whirlwind tour of Transact-SQL. You’ll learn a little about its history, what Data Definition Language (DDL) and Data Manipulation Language (DML) are, and how to write basic statements of your own. Finally, go home with some resources that will take your T-SQL skills to the next level.

Publications

Tribal SQL , Red Gate
Published on: Sep 23, 2013
What makes you passionate about working with SQL Server? What lessons have you learned, perhaps the hard way, on how to get the best performance and scalability out of your SQL Server databases? We challenged a group of talented, up-and-coming ‘new voices’ in SQL Server to share their passion and knowledge with the Community. The resulting book, Tribal SQL, is a reflection of how a DBA’s core and long-standing responsibilities sit alongside new thinking and fresh ideas about where the DBA role is going, and what it means to be a DBA in today’s businesses.