Database Tester – Job Description

Role Summary:

A Database Tester is responsible for testing database structures, validating data accuracy, and ensuring that backend systems function correctly. The role involves writing SQL queries, performing data validation, and identifying issues related to database performance, integrity, and security.

Key Responsibilities

• Perform database testing including schema testing, data validation, and data integrity testing.
• Write and execute complex SQL queries to validate data according to business rules.
• Test stored procedures, triggers, functions, indexes, and database constraints.
• Validate ETL processes, data migration, and data transformation flows (if required).
• Identify defects, analyze root causes, and report issues in the defect tracking tool.
• Work closely with developers, QA, and business teams to understand requirements.
• Ensure database performance, reliability, and data quality.

Required Skills

• Strong knowledge of SQL (joins, subqueries, views, functions).
• Experience with relational databases: MySQL, PostgreSQL, Oracle, SQL Server, etc.
• Understanding of ETL workflows, data warehousing (optional but preferred).
• Knowledge of database design concepts: tables, keys, indexes, relationships.
• Familiar with QA processes, test planning, and defect reporting tools (Jira, Azure DevOps).

Qualifications

• Bachelor’s degree in Computer Science, IT, or related field.
• 1–3 years of experience in database or backend testing (entry-level roles may consider freshers with SQL skills).