SQL Server Database Administrator

SnapIT Solutions

3h • Remote

About The Position

The Database Administrator is responsible for the health, performance, security, and compliance of Microsoft SQL Server environment, supporting survey data collection, aggregation, reporting, and regulatory documentation.

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.

Nice To Haves

• Experience supporting survey or analytics platforms with high data volumes and complex reporting needs.
• Familiarity with NIST, DoD, and Army data security/IA frameworks relevant to system operations.
• Prior involvement in supporting compliance documentation or ATO‑related processes for federal systems.

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior