Administer SQL Server databases, including configuration, monitoring, backups, restores, indexing, and performance tuning
Ensure data integrity, availability, and security in alignment with Army and DoD regulations, including appropriate handling of survey data and any associated PII
Support routine database management activities, including maintenance tasks, schema updates, and optimization of queries and reports
Collaborate with DPRR and SnapIT’s program and knowledge‑management staff to support institutional approvals and compliance documentation (e.g., ARMD, OMB, IRB, AHRPO submissions)
Provide technical inputs for compliance reports and monthly status reports, documenting database management actions and any relevant approvals or changes
Work with the Software Engineer to design and implement data structures, reporting views, and performance‑efficient access patterns for BH Pulse
Maintain configuration‑management documentation related to database structures, connections, and integration points
Participate in risk and incident response processes for any suspected data issues, security concerns, or performance degradations
Requirements
Bachelor’s degree in Computer Science or related field
6+ years of experience with Microsoft SQL Server (2016–2019 or later) in production environments, including cluster deployment and SSIS package management
Experience administering databases in DoD environments, with strong understanding of security, audit, and data‑protection requirements
Proficiency in performance tuning, query optimization, index strategies, and troubleshooting
Familiarity with reporting tools and methods for generating analytical outputs from relational databases
Strong documentation skills for database configurations, procedures, and changes