Database Test Engineer
Job Category: Engineering
Time Type: Full time
Minimum Clearance Required to Start: None
Employee Type: Regular
Percentage of Travel Required: Up to 10%
Type of Travel: Local
The Opportunity:
CACI is seeking a Database Test Engineer to join our team and support the Border Enforcement Applications for Government Leading-Edge Information Technology (IT) (BEAGLE) contract. You will have the opportunity to apply your knowledge, skills and experience to building a truly modern application that is new development and cloud native. If you thrive in a culture of innovation and bring creative ideas to solve complex technical and procedural problems at the at the team and portfolio levels, then this opportunity is for you!
Join this passionate team of industry-leading individuals supporting best practices in agile software development for the Department of Homeland Security (DHS). You will support the men and women charged with safeguarding the American people and enhancing the nation's safety and security.
Responsibilities:
As a Database Test Engineer, the responsibilities include, but are not limited to:
Participate in Agile Scrum development methodology ceremonies (e.g., sprint planning, scrum, backlog refinement, defining tasks/tests, estimating LOE, testing, tracking work done, retrospective, demonstration, etc.)
Develop, maintain, and perform sprint-level testing activities (e.g., define scenarios, develop detailed scripts/procedures) in Jira with Xray
Design, develop, and execute comprehensive test strategies to validate data quality, ETL processes, database migrations, and overall database functionality
Validate end to end data flows between separate database systems that use a variety of methods to synchronize data
Develop and maintain testing plans and execute after a new build is promoted or ahead of a production deployment
In collaboration with the Product Architect and/or Business Analyst, assess impacts of candidate changes to the smoke and/or regression test suite(s) and plan accordingly
Develop and execute complex SQL queries (DML, DDL, DCL) to validate data accuracy, consistency, integrity, and adherence to business rules across multiple database environments
Perform full-scope static and dynamic testing of a system under test utilizing functional and non-functional testing techniques. These techniques can include the following test @types: Integration/API, End-To-End, Smoke, Regression/Functional, and Usability
Document and track testing activity progress during a sprint. This includes capturing execution artifacts to support that all backlog acceptance criteria have been successfully verified/validated
Champion quality of software
Qualifications:
Required:
Must be a:
U.S. Citizen with the ability to pass CBP background investigation, criteria include, but are not limited to:
3-year check for felony convictions
1-year check for illegal drug use
1-year check for misconduct such as theft or fraud
Team player and able to work in a collaborative team environment
Must have:
Minimum of 5 years of professional experience in database testing, data quality assurance, or a related role.
Advanced proficiency in writing complex SQL queries, including joins, subqueries, aggregations, stored procedures, functions, and triggers, across various relational database management systems.
Strong understanding of relational database concepts (ACID properties, normalization, indexing, referential integrity) and experience with at least one major RDBMS (e.g., SQL Server, Oracle, MySQL, PostgreSQL).
Strong understanding of message streaming solutions such as Kafka, Amazon MSK, RabbitMQ, Google Pub/Sub, or Confluent Kafka from a testing perspective.
Testing Methodologies: Solid understanding of software development life cycle (SDLC) and software testing life cycle (STLC) principles, including various testing @types (functional, regression, performance, integration).
Test Tools: Experience with test management tools (e.g., Jira, Azure DevOps, ALM) and version control systems (e.g., Git).
Analytical Skills: Excellent analytical, problem-solving, and debugging skills with a keen attention to detail.
Communication: Strong verbal and written communication skills with the ability to articulate technical issues to both technical and non-technical stakeholders.
Applying estimation techniques to manual test script efforts and test script development/maintenance efforts
Interacting with Product Owners, Business Analysts, Scrum Masters, Product Architects, Developers, and Technical Writers, and providing guidance on testing methods to meet project specific needs
Familiar working within a continuous integration environment and supporting tools such as Jenkins, Git, GitLab, AWS, Postman
Participating in a high performing, highly engaged and motivated Scrum team
Applying the Agile development approach to incremental software development projects
Being a highly responsible, team-oriented individual with very strong communication skills and work ethic; self-starter
Understanding the elements of the software development life cycle
Desired:
Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB).
Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL).
Hands-on experience with ETL tools (e.g., SSIS, Informatica, Talend, Apache Nifi, or similar tools).
Experience with data warehousing, data lakes, and Business Intelligence (BI) concepts.
Proficiency in a scripting language (e.g., Python, PowerShell, Bash, Java) for test automation.
Experience with performance testing tools specifically for databases (e.g., JMeter, LoadRunner, SQL Profiler).
Knowledge of CI/CD pipelines and DevOps practices for database deployments.
-
What You Can Expect:
A culture of integrity.
At CACI, we place character and innovation at the center of everything we do. As a valued team member, you'll be part of a high-performing group dedicated to our customer's missions and driven by a higher purpose - to ensure the safety of our nation.
An environment of trust.
CACI values the unique contributions that every employee brings to our company and our customers - every day. You'll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
A focus on continuous growth.
Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground - in your career and in our legacy.
Your potential is limitless. So is ours.
Learn more about CACI here. (https://careers.caci.com/global/en/life-at-caci)
Pay Range : There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more here (https://careers.caci.com/global/en/employee-benefits) .
The proposed salary range for this position is:
$86,600 - $181,800
CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.
