Sr Database QA Engineer

job summary:
New Onshore database developer to work on MCL Upgrade.

5+ years of experience in Oracle SQL and PL/SQL development, including writing complex queries, stored procedures, packages, functions, triggers, and performance tuning.

Strong experience troubleshooting and resolving database performance issues, including SQL tuning, query optimization, execution plan analysis, and indexing strategies.

Experience creating and maintaining database objects such as tables, views, indexes, sequences, synonyms, materialized views, procedures, functions, packages, and triggers.

Strong understanding of relational database concepts, data modeling, database design, and Oracle database architecture.

3+ years of experience in automation testing using industry-standard tools and frameworks.

 
location: Addison, Texas
job type: Contract
salary: $54.62 - 64.62 per hour
work hours: 8am to 5pm
education: Bachelors

responsibilities:

• 5+ years of experience in Oracle SQL and PL/SQL development, including writing complex queries, stored procedures, packages, functions, triggers, and performance tuning.
• Strong experience troubleshooting and resolving database performance issues, including SQL tuning, query optimization, execution plan analysis, and indexing strategies.
• Experience creating and maintaining database objects such as tables, views, indexes, sequences, synonyms, materialized views, procedures, functions, packages, and triggers.
• Strong understanding of relational database concepts, data modeling, database design, and Oracle database architecture.
• 3+ years of experience in automation testing using industry-standard tools and frameworks.
• Hands-on experience developing and maintaining automated test scripts for functional, regression, integration, and end-to-end testing.
• Experience with test planning, test case design, defect tracking, and test execution processes.

qualifications:
Required Qualifications

5+ years of experience in Oracle SQL and PL/SQL development, including writing complex queries, stored procedures, packages, functions, triggers, and performance tuning.

Strong experience troubleshooting and resolving database performance issues, including SQL tuning, query optimization, execution plan analysis, and indexing strategies.

Experience creating and maintaining database objects such as tables, views, indexes, sequences, synonyms, materialized views, procedures, functions, packages, and triggers.

Strong understanding of relational database concepts, data modeling, database design, and Oracle database architecture.

3+ years of experience in automation testing using industry-standard tools and frameworks.

Hands-on experience developing and maintaining automated test scripts for functional, regression, integration, and end-to-end testing.

Experience with test planning, test case design, defect tracking, and test execution processes.

3+ years of experience in ETL and database testing, including data validation, data reconciliation, and source-to-target mapping verification.

Experience validating ETL processes, data transformations, data quality, and data integrity across multiple systems.

Proficiency in analyzing large datasets and performing backend testing using SQL queries.

Experience working with Oracle databases and data warehousing concepts.

Familiarity with ETL tools such as Informatica, DataStage, SSIS, or similar technologies.

Experience working in Agile/Scrum environments and participating in all phases of the software development lifecycle (SDLC).

Strong analytical, troubleshooting, and problem-solving skills.

Excellent communication and collaboration skills with the ability to work effectively across business, development, and QA teams.

Experience with API testing tools such as Postman, ReadyAPI, or REST Assured is preferred.

Familiarity with CI/CD tools such as Jenkins, GitHub, or Azure DevOps is a plus.

Knowledge of data migration, data governance, and data quality frameworks is desirable.

Desired Qualifications

Experience with API testing tools such as Postman, ReadyAPI, REST Assured, or similar frameworks.

Familiarity with CI/CD tools and DevOps practices,