ERP Test Engineer
Bering Straits Native Corporation (BSNC)
Turn this role into an interview — a resume and cover letter built around what this employer wants.
Job summary
Arcticom LLC is seeking an ERP Test Engineer for a remote role. You will serve as a database testing authority, shaping a TDD-driven path for MilPDS Oracle code, packaging, and schema updates. The role emphasizes automated test suites, test data generation, and ensuring transactional isolation.
The candidate will architect database APIs, integrate tests into CI/CD, and help gate releases with quality metrics. US citizenship and SECRET clearance are required.
Qualifications
- Bachelor’s degree in computer science, computer engineering, information technology, or a related field.
- 5–10 years of experience in database engineering, software quality engineering, or test automation, including Oracle PL/SQL development.
- Demonstrated experience designing and implementing Test-Driven Development (TDD) practices at the database or application layer.
- Must be a US Citizen and able to attain SECRET security clearance.
- Preference for experience with automated database testing frameworks.
Responsibilities
- Evaluate contractor-delivered MilPDS Oracle database code and PL/SQL packages.
- Design a roadmap to transition to Test-Driven Development at the database layer.
- Architect strategies to extract business rules into modular database APIs.
- Develop automated database test routines and unit/integration tests.
Skills
Education
Tools
Job description
Arcticom LLC provides network and systems administration, enterprise architecture and resource planning, certification and accreditation, software design, programming, maintenance of telecommunications and land mobile radio equipment and systems, help desk support and IT transformation services among other services.
Arcticom LLC provides network and systems administration, enterprise architecture and resource planning, certification and accreditation, software design, programming, maintenance of telecommunications and land mobile radio equipment and systems, help desk support and IT transformation services among other services.
The Essential Duties and Responsibilities are intended to present a descriptive list of the range of duties performed for this position and are not intended to reflect all duties performed within the job. Other duties may be assigned. To perform this job successfully, an individual must be able to satisfactorily perform each essential duty. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the position.
- Serve as the primary technical authority for evaluating contractor-delivered MilPDS Oracle database code, PL/SQL packages, stored procedures, triggers, views, and schema updates.
- Analyze legacy, non-TDD contractor code deliverables and design a technical roadmap to transition the program to a Test-Driven Development model at the database layer (covering both outer-loop acceptance and inner-loop unit test strategies).
- Architect strategies to extract embedded business rules out of legacy user interface layers and triggers into modular, independently testable database APIs.
- Write production-grade database test routines and automated unit/integration test suites (e.g., using utPLSQL or database-native frameworks) to independently validate contractor deliverables and maintain transactional isolation.
- Architect patterns to isolate component-divergent business rules (e.g., Active, Reserve, Guard variants) and prevent cross-component rule regression.
- Develop automated scripts and data factory utilities for synthetic test data generation, database state resets, and environment staging to ensure repeatable, isolated, and fully unattended test execution.
- Architect, build, and integrate automated database test suites and database version control (Schema-as-Code) directly into the program's emerging CI/CD pipeline.
- Establish automated Cross-System Traceability Daemons within the pipeline to programmatically scan for and reconcile developer-found defects (siloed as JIRA Spikes) with the authoritative system of record (ALM Octane) before code promotion, securing CPAR data hygiene metrics.
- Integrate background execution recorders to capture API transaction traffic, clickstreams, and database queries during unscripted/exploratory testing runs, programmatically converting them into structured, repeatable test assets and code templates.
- Establish automated Test Readiness Review (TRR) technical gates within the pipeline, preventing code migration unless automated database checks, least-privilege security validation, and compliance evidence requirements are met.
- Design and implement data schemas, metadata catalogs (Collibra), and Python-based Retrieval-Augmented Generation (RAG) databases on WDP Databricks to sustain a persistent, multi-session context model.
- Engineer a secure conversational interface using GenAI.mil hooks, enabling senior leadership to query live release readiness (e.g., 'Is Release 7.1 ready?') and receive real-time, mathematically proven quality validations.
- Research, architect, and deploy autonomous or semi-autonomous agentic workflows to automate test case generation, failure log analysis, continuous database test monitoring, and test asset generation.
- Design and implement an automated feedback loop that ingests production anomaly logs, executes rapid root-cause analysis, and programmatically feeds findings back to the database test-suite generation engine to continuously harden pre-release gates.
- Education Requirements: Bachelor’s degree in computer science, Computer Engineering, Information Technology, or a relevant field.
- 5–10 years of experience in database engineering, software quality engineering, or test automation, including Oracle PL/SQL development.
- Demonstrated experience designing and implementing Test-Driven Development (TDD) practices at the database or application layer.
- Must be a US Citizen.
- Must have or be able to attain a SECRET security clearance.
- Deep knowledge of Oracle database architecture, PL/SQL, and Test-Driven Development (TDD) methodologies.
- Strong understanding of CI/CD pipelines, schema-as-code practices, and automated release/compliance gating.
- Working knowledge of Databricks, metadata cataloging tools (e.g., Collibra), and Retrieval-Augmented Generation (RAG) architectures.
- Familiarity with agentic and generative AI workflow design, including secure conversational query interfaces.
- Positive attitude and a strong commitment to delivering quality work.
- Strong communication skills (written and verbal) to properly articulate complex technical concepts to management and other IT development partners.
- Experience with utPLSQL or other database-native automated testing frameworks.
- Experience with Databricks, RAG-based architectures, or agentic AI workflow development.
- Agile development experience.
- Active SECRET security clearance.
- This position will not have supervisory responsibilities.
- This position is not subject to federal requirements regarding Department of Transportation “safety-sensitive” functions.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this role. Employees must always maintain a constant state of mental alertness. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
Essential and marginal functions may require maintaining physical condition necessary for bending, stooping, sitting, walking or standing for prolonged periods of time; most of time is spent sitting in a comfortable position with frequent opportunity to move about.
The work environmental characteristics described here are representative of those that must be borne by an employee to successfully perform the essential functions of the role. Employees must always maintain a constant state of situational awareness. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. This job is performed in an office setting with exposure to computer screens and requires extensive use of a computer, keyboard, mouse, and multi-line telephone system. Typical work hours are 7:30 a.m. to 4:15 p.m. (Central Time). This job may require additional hours. Work hours may change at Management's discretion with or without prior notice.
As a condition of employment, you will be required to pass a pre-employment drug screening and have acceptable background check results. If applicable to the contract, you must also obtain and maintain the appropriate clearance levels required and must also be able to obtain access to military installations.
BSNC gives hiring, promotion, training, and retention preference to BSNC shareholders, shareholder descendants and shareholder spouses who meet the minimum qualifications for the job.
Bering Straits Native Corporation is an equal opportunity employer. All applicants will receive consideration for employment without regard to any status protected by state or federal law, or any other basis prohibited by law.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
