
Eric Dawson
Database Tester
Making sure the data behind the app is right
Database tester with seven years validating data and database logic for a software company in Columbus. Tests the layer most testing misses — verifying data integrity, ETL and migrations, stored procedures and the queries that feed the application, so the numbers users see are actually correct. Built a data-validation test suite that caught migration errors before a major release went live. Writes and runs SQL-based test cases, validates ETL and data transformations, tests stored procedures and performance, and manages defects with developers and data engineers. Strong on both deep SQL skill and the testing discipline the role demands, where a data bug is silent and dangerous. Methodical and protective of data accuracy. Looking for a database-tester, QA-engineer or data-quality role on systems where the data has to be right.
Columbus Software Group - Columbus, OH
Database Tester April 2017 to Present 9 years & 3 months
Built a data-validation test suite that caught the migration errors well before a major release.
Write and run the SQL-based test cases to verify the data is accurate and complete.
Validate all the ETL and the data transformations and test the stored procedures and performance.
Manage all the defects with the developers and the data engineers right through to resolution.
Protect all the data accuracy, knowing that a single silent data bug can be dangerous downstream.
Midwest Data Systems - Columbus, OH
QA / Data Analyst Tester August 2015 to March 2017 1 year & 8 months
Wrote the SQL queries to validate the data and logged defects.
Learned the data validation, ETL testing and test design on the job.
Gained the SQL and testing certification and then a database-tester role.
Midwest Data Systems - Columbus, OH
Data Analyst June 2013 to July 2015 2 years & 2 months
Validated the data, the queries and the reporting for business teams.
Learned the databases, the SQL and where the data goes wrong.
Then moved into a full QA and data-tester role from there.
Ohio State University
BSc in Information Systems (August 2011 to May 2015)
ISTQB / Microsoft
SQL & Software Testing Certification (January 2017 to May 2017)
Caught migration errors
Guards the data layer
Data-Validation Test Suite
Database Tester (January 2019 to August 2019)
Stored-Procedure Test Automation
Database Tester (January 2020 to September 2020)
SQL & Software Testing
ISTQB / Microsoft (May 2017 to Present)
ETL Testing & Data Quality
ISTQB (April 2019 to Present)
- Database Testing
- SQL
- Data Validation
- ETL Testing
- Migration Testing
- Stored Procedure Testing
- Data Integrity
- Performance Testing
- Defect Management
- Test Case Design