David van Mersbergen
Atlanta, GA *****
SQL Server Database Administrator
Ensure Data is Secure, Reliable and Available
Tenacious and consistent professional with knowledge in managing and maintaining production and development databases. Demonstrated key problem-solving skills by breaking down complex problems into manageable units, troubleshooting, delivering solutions and documenting processes. Known for isolating problems, tackling issues, investigating resolutions and delivering results in a dynamic environment. Direct experience in developing queries and reports, utilizing SQL Server to monitor database capacity and SQL Agent maintenance jobs. Recognized for translating complex issues into clear, actionable explanations.
Data Migration Backup & Restore Strategy Log Shipping & Disaster Recovery SQL Agent
Index & Performance Tuning Database Security T-SQL Query Scripts Database Maintenance
SQL System Configuration Redgate Monitoring
GREENWAY HEALTH, Atlanta, GA 2015 – 2018
Monitored, troubleshot and maintained databases, data warehouses and daily SQL Agent jobs in support of BI reporting tool. Configured SQL server logins and database user IDs, operators, database mail, alerts and jobs in accordance with best practices. Planned, organized and implemented database migration in support of capacity planning. Monitored, tested and maintained High Availability and Disaster Recovery. Identified and recommended process improvements. SQL Server 2008/2008R2/2012/2014
Decreased number of nightly job failures from average of 40 to less than 5 across 5 servers by troubleshooting connections, job load capacity planning and code review.
Conserved average of 3 hours on 900 nightly job runs on data warehouse / business intelligence tool through index reorganization and job load balancing.
Ensured standardization on new SQL servers through configuration documentation of scripts queries and standard procedures.
Saved 500GB of disc space by migrating 500+ databases to expanded server.
Saved 1TB of space across 10 servers through capacity monitoring.
Increased database security through audit of server and database roles and system administrator (sa) account usage.
CONTRACTOR, Marietta, GA 2012 - 2014
Completed backup and restore from different recovery models. Developed SSIS packages to migrate databases between server instances. Developed databases, tables and queries and problems in support of SQL training. Facilitated server migration from 3rd party offsite hosting to internal data center. Broke down tasks into manageable units to be implemented. Worked with individual shelter residents and guests to prepare for GED test and set up computer / email accounts to facilitate job search and permanent residence.
David van Mersbergen firstname.lastname@example.org Page Two
Created maintenance plan that ran daily for jobs running in SQL Server Agent, streamlining backup operations, index reorganization, updating statistics and database integrity check set up maintenance plan for backup and index reorganization.
Designed and delivered GED training plans for learners to facilitate test preparation, completing testing within 6 months.
FOOT SOLUTIONS, Atlanta, GA 2012 – 2013
Education and Training Coordinator
Performed data analysis to assist management to assess current sales figures using web-based retail POS database and ETL tools. Compiled data to report retail statistics on top performing franchises for VP review. Coordinated with merchandising team to gather top selling shoes by region and vendor. Developed reports and materials to display key metrics for high performing franchises. Designed and developed training and educational materials in support of franchise operations highlighting AARA, HITEC, HIPAA and Meaningful Use. Conducted and participated in training sessions.
Developed Extract Transform Load process from scratch for reporting tool that took 45 minutes to complete, saving 8 hours.
Used (ETL) and web-based POS database tools to perform data analysis, assisting key players and management to assess current sales figures.
Refined product forecasting by using Excel spreadsheet formulas, allowing franchises to forecast purchasing decisions.
Prepared in-depth certification documentation for school accreditation in 1 month, allowing Foot Solutions to train franchisees and employees internally.
Increased sales promotion awareness and salesperson effectiveness by analyzing key statistics and designing reports to determine marketing success.
SANDCASTLE REALTY, Atlanta, GA 2012
Assisted real estate agent in developing database of clients for marketing and customer development.
Developed queries for Multiple Listing Service (MLS), generating reports per requested data and performing market analysis, facilitating listing presentations.
Streamlined 800-customer contact database for monthly email and marketing promotions, producing 25% increase in new listings for agent.
Master of Business Administration (MBA), University of South Dakota, Rapid City, SD
Bachelor of Arts (BA), Psychology, minor: Business Administration, Calvin College, Grand Rapids, MI
United States Air Force Leadership School, RAF Wethersfield, United Kingdom
Professional Training and Certifications
MCSA SQL Server 2012
Microsoft SQL Server 2012 Database Administration Certificate, Pacific Institute of Technology, Morrow, GA, 2014
Accelerated Training in Healthcare Information Technology, Southern Polytechnic State University, Marietta, GA, 2012