SQL Server Database Administrator
Snapit Solutions LLC
Arlington, United States of America
7 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 95KJob location
Remote
Arlington, United States of America
Tech stack
Business Analytics Applications
Configuration Management
Databases
Data Integrity
Data Security
Data Structures
Relational Databases
Database Storage Structures
Knowledge Management
Microsoft SQL Server
Survey Data Collection
Performance Tuning
Query Optimization
SQL Server Integration Services
Indexer
Information Technology
Tools for Reporting
Job description
Summary: The Database Administrator is responsible for the health, performance, security, and compliance of BH Pulse's Microsoft SQL Server environment, supporting survey data collection, aggregation, reporting, and regulatory documentation., * Administer BH Pulse's 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
- Experience working in DoD environment is required.
- 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.
Preferred
- 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.
Benefits & conditions
4.54.5 out of 5 stars Arlington, VA 22202 Hybrid work $75,000 - $95,000 a year - Full-time, Contract