Database Developer, Sanametrix, Inc.
Dec, 2012 - Present
Cloud SQL Server Database Administrator (Amazon Web Services / AWS).
Responsible for design, creation, and management of a 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. It is automated to find errors in the data, and promotes quicker turnaround for common fixes.
Storage and performance administration on over 1.5TB of data for the Civil Rights Data Collections (CRDC) for the U.S. Department of Education, Office for Civil Rights.
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).
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.
Custom ETL development in SSIS.