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, including Jenkins, GitHub, GitHub Actions, Azure DevOps, or equivalent platforms.

Knowledge of Oracle database administration concepts, database migration, backup/recovery processes, and release deployment activities.

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

Experience creating and supporting database objects such as tables, views, indexes, sequences, stored procedures, packages, functions, and triggers.

Knowledge of data warehousing concepts, data governance, and data quality frameworks.

Exposure to cloud-based database platforms and modern data integration architectures.

Experience working with large-scale data migration, data conversion, and reconciliation projects.

Familiarity with version control and source code management tools such as Git, Bitbucket, or SVN.

Experience collaborating with cross-functional teams, including business analysts, developers, DBAs, and QA teams, to deliver high-quality solutions.

Ability to analyze complex data issues and provide innovative solutions to improve data quality, performance, and reliability.

Strong documentation skills, including the creation of test plans, test cases, data validation reports, and technical specifications.

Experience working in highly regulated environments with strong focus on accuracy, compliance, and auditability.

Exposure to automation frameworks and scripting languages to support test automation and process efficiency.

Ability to work independently, manage multiple priorities, and effectively support project delivery timelines.

skills:

automation testing,automated test scripts,test automation,large-scale data,Bitbucket,cloud-based database,CI/CD,analyzing large datasets,data conversion,data governance,data quality frameworks,data integration,data integrity,data migration,data transformations,data validation,data warehousing concepts,database design,database migration,indexing strategies,database performance,writing complex queries,database objects,database testing,databases,DevOps practices,end-to-end testing,ETL,ETL processes,ETL tools,Git,GitHub,GitHub Actions,DataStage,Informatica,Jenkins,Azure DevOps,Oracle database,Oracle database administration,Oracle SQL,PLSQL,performance tuning,API testing tools,Postman,query optimization,query tuning,ReadyAPI,relational database concepts,REST,SQL queries,SSIS,stored procedures,scripting languages,software development lifecycle,version control,source code management,SQL optimization,SQL tuning,SVN,SDLC,test case,test execution,analytical,Ability to analyze,communication,work effectively,troubleshooting,problem-solving skills,reliability,Ability to work independently,architecture,automation,data reconciliation,process efficiency,data modeling,data quality,maintaining database,DBAs,defect tracking,project delivery,technical specifications,backend testing,innovative solutions,collaboration skills,QA,Strong documentation skills,test planning,test plans

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.