Senior Database Developer

About the role

You will own the full lifecycle design and delivery of enterprise data solutions that directly underpin national mission outcomes. This position requires you to translate ambiguous stakeholder needs into robust, scalable database architectures that balance performance, integrity, and security. You will serve as the primary technical authority for data model decisions, influencing standards and patterns across multiple engagements. You will collaborate closely with data engineers, analysts, and mission owners to ensure that data structures align with evolving operational realities. You will be responsible for optimizing complex data flows to ensure timely delivery of high-quality information to decision-makers. You will implement and refine database objects to support advanced analytics, reporting, and integration across heterogeneous systems. You will mentor junior team members on best practices for database development, code review, and documentation. You will continuously assess emerging technologies and techniques to improve the reliability and efficiency of data platforms.

Key facts

What you'll do

Architect and implement scalable relational database designs that serve as the backbone for mission-critical analytics.

Evaluate existing data landscapes and identify opportunities for restructuring schemas to improve clarity, performance, and maintainability.

Develop and refine stored procedures, functions, and triggers to enforce business logic and automate complex data transformations.

Lead the creation of robust data models that accurately represent entities, relationships, and constraints required for government reporting.

Optimize query performance through indexing strategies, execution plan analysis, and thoughtful partitioning of large datasets.

Implement data validation frameworks to ensure accuracy, consistency, and compliance with regulatory and operational standards.

Collaborate with data integration specialists to design resilient pipelines that move data securely between sources and the warehouse.

Document database structures, change histories, and operational procedures to support continuity and knowledge transfer.

Participate in code reviews and technical discussions to elevate the quality and maintainability of database artifacts across teams.

Support incident response activities by diagnosing data issues, proposing corrective actions, and implementing preventative improvements.

Contribute to the development of monitoring strategies that provide visibility into database health, usage patterns, and potential bottlenecks.

Engage with stakeholders to clarify requirements, validate designs, and ensure that database solutions meet intended objectives.

Apply best practices for version control, testing, and deployment specific to database changes in regulated environments.

Champion data governance initiatives that promote standardized naming, classification, and documentation across databases.

Requirements

U.S. citizenship is required for this position.

Applicants must have a current Secret clearance or the ability to obtain one.

Bachelor's degree in a quantitative field or equivalent practical experience is required.

Minimum of eight years of hands-on database development experience in a professional setting.

Demonstrated expertise in SQL Server, including T-SQL, indexing, and query optimization.

Proven track record of designing and implementing database solutions in complex, high-volume environments.

Experience with ETL processes and data integration patterns relevant to enterprise data warehousing.

Strong understanding of data modeling techniques, including dimensional modeling and normalization principles.

Ability to interpret technical requirements and convert them into efficient database structures.

Experience working in regulated environments where documentation, traceability, and compliance are essential.

Excellent written and verbal communication skills for coordinating with technical and non-technical stakeholders.

Willingness to engage in continuous learning to keep pace with evolving data platforms and analytical techniques.

Ability to manage multiple priorities in a fast-paced environment while maintaining attention to detail.

Commitment to following established development processes and contributing to team code quality standards.

Nice to have

Preferred experience with database performance tuning in large-scale, enterprise-level systems.

Familiarity with data visualization tools and their interaction with underlying database structures.

Knowledge of scripting languages used for automation and data manipulation.

Experience supporting cloud-based data platforms as part of a hybrid data strategy.

Understanding of data security frameworks and methods for implementing row-level security.

Practical notes

This is a full-time position based in Huntsville, Alabama. Travel requirements are not specified in the available source information. No visa sponsorship details are provided in the source material. No specific deadline for applications is mentioned in the source documentation.