ROLE AND POSITION OBJECTIVES:
As the NWS Lead Database Engineer for General Dynamics Mission Systems, you will provide technical leadership for backend, embedded data-management, and data-integration activities supporting a complex, distributed tactical system. You will work across software, systems, hardware, test, and configuration-management disciplines to mature the product, improve development practices, and deliver scalable capabilities.
This role requires an engineer who can lead technical execution while remaining hands-on with database architecture, data modeling, SQL development, ETL processes, implementation, reviews, planning, and mentoring. The selected candidate will help guide the team’s transition toward memory-safe and type-safe technologies, including Go for new development and JavaScript for existing applications.
Key Responsibilities
- Serve as the technical lead for a software team, providing technical direction, mentoring, code reviews, and implementation support.
- Lead the design and sustainment of database schemas, data models, SQL queries, data-access services, and data-integrity controls.
- Define and support ETL processes for extracting, transforming, validating, and loading embedded-system telemetry, event, diagnostic, configuration, test, and operational data.
- Coordinate ESD data interfaces, including data mapping, schema changes, interface compatibility, error handling, and end-to-end data validation.
- Break down features into well-defined, testable tasks aligned with product, subsystem, and data-interface boundaries.
- Partner with the Product Owner, Scrum Master, program leadership, Systems Engineering, and SC&I to plan work, manage priorities, and align with coding and development standards.
- Support Agile execution, including sprint planning, backlog refinement, technical estimation, retrospectives, and delivery tracking.
- Develop, review, and maintain technical artifacts, including database design documentation, data models, interface documentation, test plans, user manuals, administrator manuals, and software-development documentation.
- Support financial and program-planning activities, including COCOMO estimates, Basis of Estimate (BOE) inputs, and Software Bill of Materials (SW BOM) development.
- Conduct and oversee code reviews, ensuring changes meet quality, security, maintainability, testability, data-integrity, and Definition-of-Done expectations.
- Establish data-quality, error-handling, reconciliation, auditability, monitoring, backup/recovery, and retention practices for database and ETL workflows.
- Assess and improve team maturity, code maturity, codebase size and stabilization trends, development efficiency, and scalability across a distributed environment supporting 3,000+ endpoints.
- Help mature CI/CD and DevSecOps capabilities, including automated unit testing, code-quality analysis, configuration management, and repeatable production builds.
- Establish, maintain, or support test beds on SWFPAC.
- Identify technical risks, dependencies, data-interface concerns, and architectural issues early; communicate options, tradeoffs, and recommendations to leadership.
- Mentor existing technical leadership and individual contributors, helping build sustainable team capability and knowledge transfer.
Database Lead Focus Areas
The Backend Lead will additionally support:
- Backend architecture, database design, data modeling, schema management, SQL development, and database performance optimization.
- ETL and data-pipeline development for embedded-system telemetry, event logs, diagnostics, configuration, test, and operational data.
- ESD integration, including data mapping, interface definition, schema/version compatibility, error handling, and end-to-end data validation.
- Data ownership, access control, retention, auditability, backup/recovery, and configuration-management practices for system and support data.
- Middleware and Data Distribution Service (DDS) integration, including evaluation of Rust compatibility with RTI DDS.
- Embedded software and firmware-adjacent development, including FreeRTOS and TCP/IP interfaces, as applicable.
- Containerization, virtualization, CI/CD pipelines, and deployment architecture.
- Migration and adoption of memory-safe/type-safe technologies, particularly Go and Rust where appropriate.
- Build and release management, including Git-based merge, build, and configuration-management workflows.
Preferred Skills and Experience
We encourage you to apply if you have experience with:
- Leading, or serving as the deputy/backup lead for, delivery of a mature tactical, mission, or strategic software system.
- Software architecture, technical planning, feature decomposition, and system-level design.
- Frontend and/or backend development in distributed, multi-component systems.
- Go, Rust, JavaScript/TypeScript, C#, Java, C/C++, or other memory-safe/type-safe programming languages.
- Database architecture, relational database design, data modeling, schema management, SQL, and backend-service development.
- Strong SQL experience, including query development, performance tuning, indexing, transactions, stored procedures, and database troubleshooting.
- ETL or data-pipeline experience, including data extraction, transformation, validation, reconciliation, error handling, and monitoring.
- Experience integrating embedded telemetry, event logs, diagnostics, configuration, test, or operational data with backend databases and services.
- Experience supporting ESD interfaces, including data mappings, interface contracts, and schema compatibility.
- Experience with Oracle, PostgreSQL, SQL Server, MongoDB, or similar relational and NoSQL database technologies.
- Object-oriented software design and modern software-design principles.
- Data Distribution Service (DDS), middleware integration, and RTI DDS.
- Embedded software development, FreeRTOS, TCP/IP, and firmware-adjacent interfaces.
- Linux development or administration.
- Docker, Kubernetes, containerization, virtualization, and deployment automation.
- CI/CD, DevSecOps, automated testing, static analysis, production builds, and configuration management.
- Git, GitLab, source-control workflows, and merge/review practices.
- Software requirements decomposition; preliminary and critical design; implementation and unit testing; and requirements-based testing.
- Factory, hardware, or integration-test environments.
- Agile delivery, Product Owner responsibilities, or SAFe Agile Product Owner/Product Manager practices.
What Sets You Apart
- Strong technical judgment and the ability to guide engineers through complex or ambiguous database, data-flow, and system-integration decisions.
- Ability to translate embedded-system, operational, test, and diagnostic-data needs into scalable database models, SQL solutions, ETL workflows, and interface contracts.
- Demonstrated ability to balance hands-on engineering work with team leadership, mentoring, planning, and stakeholder communication.
- Experience improving engineering processes, data quality, workflows, code quality, and automation in an established product environment.
- Ability to identify data-quality, performance, timing, availability, security, and integration risks early and communicate practical mitigation options.
- Ability to communicate technical risks, tradeoffs, estimates, and recommendations clearly to both technical and program stakeholders.
- Commitment to high-quality, maintainable, secure, and scalable software and data solutions.
- Ability to lead a developing team, create clarity around expectations, and foster a collaborative and accountable engineering culture.
- Willingness to take reasonable, managed risks while maintaining disciplined engineering, testing, data-management, and configuration-management practices.
Workplace Options:
This position is primarily on-site, with opportunities for hybrid/flex work as allowable. While on-site, you will be part of the GDMS Pittsfield, Massachusetts Engineering Team.
#LI-Hybrid