Test Analyst

Major Responsibilities:

• Design and develop SQL scripts and procedures for testing database functionality.

• Review database designs and ensure they meet organizational standards for performance, security and maintainability.

• Test database functions, triggers, views and stored procedures to ensure they produce the desired results.

• Analyze, test and validate data for accuracy and integrity.

• Identify, reproduce and report defects in databases and associated applications.

• Work closely with developers and data modelers on database design and improvements.

• Validate database migrations and ETL processes.

• Monitor database performance metrics and recommend enhancements.

• Develop test plans and documentation around SQL testing efforts.

• Collaborate with other QA professionals in designing broader testing strategies that incorporate database testing.

• Stay up to date with the latest SQL developments and best practices to ensure tests are relevant and effective.

Required Qualifications:

• Bachelor's degree in computer science, information systems or a related field.

• 6+ of proven experience as a SQL Tester or similar role.

• In depth understanding of database structures, principles and best practices.

• Familiarity with various SQL-based databases systems like SQL Server, Oracle, Toad, etc.

• Experience with data modeling tools, SQL development tools and performance monitoring tools.

• Excellent analytical and problem-solving skills.

• Strong communication skills both verbal and written.

• Knowledge of ETL processes and associated testing strategies is a plus.