FEi Systems
Quality Assurance Tester (Database) - (Remote)
FEi Systems, Columbia, Maryland, United States, 21046
At FEI Systems, we create innovative technology solutions to improve the delivery of health and human services because we know when cumbersome administrative processes stand in the way, those who need it most are often left without access to proper care and support. From comprehensive case management software to disaster recovery services and content management information systems used in delivering foreign aid, our solutions are improving the lives of millions of people. We're looking for a quality assurance tester (database) who shares our commitment to leveraging technology to make a real impact in the world - a professional who knows, beyond all else, that the quality of our products and services is only as good as the company we keep.
Job Summary
: A Database Tester plays a crucial role in ensuring the quality and reliability of databases. Their responsibilities encompass a wide range of tasks aimed at verifying the integrity, consistency, and performance of database systems.
Responsibilities
:
Database Testing:
The primary responsibility of a Database Tester is to verify the database's ability to store, retrieve, and manipulate data correctly. This involves rigorous testing of various aspects of the database system, including:
Data Integrity:
Ensuring that the data stored in the database is accurate, complete, and consistent. This includes verifying that data types are correct, constraints are enforced, and relationships between tables are maintained. Data Consistency:
Validating that data remains consistent across different tables and databases. This involves testing transactions, triggers, and stored procedures to ensure that data is updated correctly in all relevant locations. Performance of Database Operations:
Evaluating the performance of database operations, such as queries, inserts, updates, and deletes. This includes measuring response times, identifying bottlenecks, and optimizing queries for better performance. SQL Queries:
A significant part of a Database Tester's job involves writing and executing SQL queries to validate data accuracy and consistency. This requires a strong understanding of SQL and the ability to write complex queries to retrieve and manipulate data. The types of SQL queries that a Database Tester may need to write include:
SELECT Queries:
Retrieving data from one or more tables based on specific criteria. This involves using various clauses such as WHERE, ORDER BY, GROUP BY, and HAVING to filter and sort the data. UPDATE Queries:
Modifying existing data in the database. This involves using the UPDATE statement to change the values of one or more columns in a table. DELETE Queries:
Removing data from the database. This involves using the DELETE statement to remove rows from a table based on specific criteria. Database Objects:
Database Testers are also responsible for testing the functionality of various database objects, such as:
Tables:
Verifying the structure and data types of tables, as well as the constraints and relationships between tables. Triggers:
Testing the functionality of triggers, which are special stored procedures that automatically execute in response to certain events, such as inserting, updating, or deleting data. Stored Procedures:
Testing the functionality of stored procedures, which are precompiled SQL code that can be executed as a single unit. Functions:
Testing the functionality of functions, which are similar to stored procedures but can return a value. Test Case Creation:
Developing comprehensive test cases is a critical aspect of database testing. Test cases should cover various scenarios, including:
Positive Scenarios:
Testing the system with valid data to ensure that it functions as expected. Negative Scenarios:
Testing the system with invalid data to ensure that it handles errors gracefully. Boundary Conditions:
Testing the system with data at the limits of its acceptable range to ensure that it handles edge cases correctly. Defect Management:
Identifying, reporting, and tracking defects found during testing is an essential part of the Database Tester's role. This involves:
Identifying Defects:
Recognizing and documenting any issues or discrepancies found during testing. Reporting Defects:
Clearly and concisely communicating defect information to the development team, including steps to reproduce the issue, expected results, and actual results. Tracking Defects:
Monitoring the status of defects and ensuring that they are resolved correctly. Verifying Defect Resolution:
Retesting the system after defects have been fixed to ensure that the issues have been resolved and that no new issues have been introduced. Data Validation:
Checking the accuracy and completeness of data within the database is a crucial responsibility. This involves:
Data Profiling:
Analyzing the data to identify patterns, anomalies, and inconsistencies. Data Cleansing:
Correcting or removing inaccurate or incomplete data. Data Transformation:
Converting data from one format to another to ensure consistency and compatibility. Required Skills
:
To effectively perform the responsibilities of a Database Tester, certain skills are essential. These skills encompass technical knowledge, analytical abilities, and communication proficiency.
SQL Proficiency A strong knowledge of SQL (Structured Query Language) is fundamental for querying and manipulating data. This includes the ability to write complex queries, understand database schemas, and optimize queries for performance.
Database Knowledge A thorough understanding of database concepts, including schemas, tables, relationships, and data types, is crucial. This knowledge enables the Database Tester to effectively design test cases, analyze test results, and identify potential issues.
Testing Methodologies Familiarity with various testing methodologies, including black-box, white-box, and gray-box testing, is important. This allows the Database Tester to apply the most appropriate testing techniques for different scenarios.
Analytical Skills The ability to analyze test results, identify root causes of issues, and propose solutions is essential. This requires strong analytical and problem-solving skills.
Communication Skills Effectively communicating test results and defect information to development teams and stakeholders is crucial. This involves clear and concise written and verbal communication skills.
Problem-Solving Skills
Identifying and resolving complex database-related issues requires strong problem-solving skills. This includes the ability to think critically, analyze data, and develop creative solutions.
Location:
Remote
Status : Full time position with full company benefits
NOTICE: EO/AA/VEVRAA/Disabled Employer - Federal Contractor. FEI Systems participates in E-Verify, a federal program that enables employers to verify the identity and employment eligibility of all persons hired to work in the United States by providing the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization. For more information on E-Verify, please contact DHS at (888) 464-4218.
Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, marital status, political affiliation, disability, or genetic information, except where it relates to a bona fide occupational qualification or requirement. FEI Systems creates an Affirmative Action Plan on an annual basis. Pursuant to federal law, the portions of FEI Systems' Affirmative Action Program that relate to Section 503 (Persons with Disabilities) and/or Section 4212 (Protected Veterans), are available for inspection upon request by applicants and employees during FEI Systems' normal business hours.
Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Job Summary
: A Database Tester plays a crucial role in ensuring the quality and reliability of databases. Their responsibilities encompass a wide range of tasks aimed at verifying the integrity, consistency, and performance of database systems.
Responsibilities
:
Database Testing:
The primary responsibility of a Database Tester is to verify the database's ability to store, retrieve, and manipulate data correctly. This involves rigorous testing of various aspects of the database system, including:
Data Integrity:
Ensuring that the data stored in the database is accurate, complete, and consistent. This includes verifying that data types are correct, constraints are enforced, and relationships between tables are maintained. Data Consistency:
Validating that data remains consistent across different tables and databases. This involves testing transactions, triggers, and stored procedures to ensure that data is updated correctly in all relevant locations. Performance of Database Operations:
Evaluating the performance of database operations, such as queries, inserts, updates, and deletes. This includes measuring response times, identifying bottlenecks, and optimizing queries for better performance. SQL Queries:
A significant part of a Database Tester's job involves writing and executing SQL queries to validate data accuracy and consistency. This requires a strong understanding of SQL and the ability to write complex queries to retrieve and manipulate data. The types of SQL queries that a Database Tester may need to write include:
SELECT Queries:
Retrieving data from one or more tables based on specific criteria. This involves using various clauses such as WHERE, ORDER BY, GROUP BY, and HAVING to filter and sort the data. UPDATE Queries:
Modifying existing data in the database. This involves using the UPDATE statement to change the values of one or more columns in a table. DELETE Queries:
Removing data from the database. This involves using the DELETE statement to remove rows from a table based on specific criteria. Database Objects:
Database Testers are also responsible for testing the functionality of various database objects, such as:
Tables:
Verifying the structure and data types of tables, as well as the constraints and relationships between tables. Triggers:
Testing the functionality of triggers, which are special stored procedures that automatically execute in response to certain events, such as inserting, updating, or deleting data. Stored Procedures:
Testing the functionality of stored procedures, which are precompiled SQL code that can be executed as a single unit. Functions:
Testing the functionality of functions, which are similar to stored procedures but can return a value. Test Case Creation:
Developing comprehensive test cases is a critical aspect of database testing. Test cases should cover various scenarios, including:
Positive Scenarios:
Testing the system with valid data to ensure that it functions as expected. Negative Scenarios:
Testing the system with invalid data to ensure that it handles errors gracefully. Boundary Conditions:
Testing the system with data at the limits of its acceptable range to ensure that it handles edge cases correctly. Defect Management:
Identifying, reporting, and tracking defects found during testing is an essential part of the Database Tester's role. This involves:
Identifying Defects:
Recognizing and documenting any issues or discrepancies found during testing. Reporting Defects:
Clearly and concisely communicating defect information to the development team, including steps to reproduce the issue, expected results, and actual results. Tracking Defects:
Monitoring the status of defects and ensuring that they are resolved correctly. Verifying Defect Resolution:
Retesting the system after defects have been fixed to ensure that the issues have been resolved and that no new issues have been introduced. Data Validation:
Checking the accuracy and completeness of data within the database is a crucial responsibility. This involves:
Data Profiling:
Analyzing the data to identify patterns, anomalies, and inconsistencies. Data Cleansing:
Correcting or removing inaccurate or incomplete data. Data Transformation:
Converting data from one format to another to ensure consistency and compatibility. Required Skills
:
To effectively perform the responsibilities of a Database Tester, certain skills are essential. These skills encompass technical knowledge, analytical abilities, and communication proficiency.
SQL Proficiency A strong knowledge of SQL (Structured Query Language) is fundamental for querying and manipulating data. This includes the ability to write complex queries, understand database schemas, and optimize queries for performance.
Database Knowledge A thorough understanding of database concepts, including schemas, tables, relationships, and data types, is crucial. This knowledge enables the Database Tester to effectively design test cases, analyze test results, and identify potential issues.
Testing Methodologies Familiarity with various testing methodologies, including black-box, white-box, and gray-box testing, is important. This allows the Database Tester to apply the most appropriate testing techniques for different scenarios.
Analytical Skills The ability to analyze test results, identify root causes of issues, and propose solutions is essential. This requires strong analytical and problem-solving skills.
Communication Skills Effectively communicating test results and defect information to development teams and stakeholders is crucial. This involves clear and concise written and verbal communication skills.
Problem-Solving Skills
Identifying and resolving complex database-related issues requires strong problem-solving skills. This includes the ability to think critically, analyze data, and develop creative solutions.
Location:
Remote
Status : Full time position with full company benefits
NOTICE: EO/AA/VEVRAA/Disabled Employer - Federal Contractor. FEI Systems participates in E-Verify, a federal program that enables employers to verify the identity and employment eligibility of all persons hired to work in the United States by providing the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization. For more information on E-Verify, please contact DHS at (888) 464-4218.
Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, marital status, political affiliation, disability, or genetic information, except where it relates to a bona fide occupational qualification or requirement. FEI Systems creates an Affirmative Action Plan on an annual basis. Pursuant to federal law, the portions of FEI Systems' Affirmative Action Program that relate to Section 503 (Persons with Disabilities) and/or Section 4212 (Protected Veterans), are available for inspection upon request by applicants and employees during FEI Systems' normal business hours.
Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.