SQL Server Database Administrator

SAIC•Quantico, VA

11d•Onsite

About The Position

Make a difference for national security by joining a team of dedicated IT professionals who will sustain, modernize and transform the enterprise IT capabilities for the Defense Counterintelligence and Security Agency (DCSA). The Air Force, Space & Intel Business Group (AFSI) of SAIC is seeking an SQL Server Database Administrator (DBA) to support a transformational infrastructure program for DCSA. SAIC is proud to be supporting DCSA in safeguarding our nation’s information. DCSA is the designated oversight authority on the accreditation of classified facilities, information systems, and the insider threat program. This involves security oversight of more than 10,000 companies and approximately 13,000 facilities involved in classified work throughout the DoD and 31 Federal agencies. Specifically, on the DCSA One IT program, SAIC will provide an enterprise IT solution that delivers highly secure and adaptable IT infrastructure, provide customer support, and cutting-edge technologies that support operations and advance the DCSA mission under a single IT environment (i.e., One IT).

Requirements

Deep understanding of SQL Server database architecture and administration
Ability to collaborate with application developers, system administrators, and other stakeholders

Responsibilities

Install, configure, upgrade, and maintain Microsoft SQL Server instances across development, testing, and production environments.
Perform routine maintenance tasks such as backups, index maintenance, monitoring, and performance tuning.
Monitor database system health, ensuring high availability and low downtime.
Analyze database performance and implement tuning recommendations (e.g., query optimization, index management, etc.).
Identify resource bottlenecks and optimize server and query performance for efficient processing.
Proactively plan for future database needs based on application usage and growth trends.
Monitor database storage and design strategies to optimize space utilization and scalability.
Implement and maintain database security policies, including role-based access control (RBAC), audit trails, and encryption across SQL Server instances.
Ensure compliance with data privacy standards (e.g., GDPR, CCPA, HIPAA, etc.) and corporate security policies.
Develop and implement database backup, restoration, and recovery plans. Perform disaster recovery testing regularly.
Configure and manage high availability solutions such as clustering, Always On Availability Groups, or replication.
Work closely with application developers to design and optimize database structures for new and existing systems.
Collaborate with IT administrators on server resources (e.g., CPU, memory, storage) required to support database operations.
Create and maintain scripts to automate repetitive tasks such as backups, deployments, and monitoring.
Develop and maintain detailed documentation of database configurations, standard operating procedures (SOPs), and maintenance schedules.
Generate reports for monitoring key database performance metrics and trends over time.