Database Test Engineer

About Le'fant

Le'fant is a rapidly growing CVE Certified, Service Disabled Veteran Owned Small Business specializing in management consulting for the federal government. Our compensation and benefits plans are designed to attract and retain the industry's best talent to provide the highest quality services to the Federal Government. We offer 40lK matching, customized health plans, dental and vision insurance, life insurance, short and long term disability coverage, an incentives program to recognize exceptional behavior and competitive base salaries. We hire the best to provide the best service.

EEO Statement:

It has been and will continue to be a fundamental philosophy and policy of Le'fant not to discriminate on the basis of race, color, religion, sex, gender, sexual orientation, sexual gender, gender identity or expression, pregnancy, parental status, marital status, citizenship, national origin, age, disability, genetic information, military status, veteran status or any other protected category with respect to recruitment, hiring, training, promotion, and other terms and conditions of employment.

What you'll get to do:

As our Database Test Engineer, you will be a valuable Agile team member responsible for designing and executing comprehensive test strategies, including SQL-driven validation of data integrity, ETL processes, and database functionality, to ensure accurate, reliable, and high-quality software delivery. Please be aware, candidates local to the Ashburn, VA area who can report onsite at least one day per week are preferred; remote arrangements may be considered for exceptional candidates on a case-by-case basis.

• 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

Requirements:

• Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria include but are not limited to:
• 1 year check for misconduct such as theft or fraud
• 1 year check for illegal drug use
• 3-year check for felony convictions
• 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

These Qualifications Would Be Nice to Have:

• 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.